Properties Database and Filtering

 
 

Property Search Admin

Log in with your admin account:
http://dev.lillibridge.sitebasin.com/user

Then click over to content

Filter content by type "property"

 
 
 

Then click on edit to edit a specific property.

Currently, every property entry was loaded from the spreadsheet import. (more on future imports below).

You can override anything from the import and turn a property search result into a featured property – see below.

 
 
 

NOTE: What's displayed as a property name in the search results is not always the name of the property as identified within the spreadsheet. 

When searching for properties to edit, look for the name in italics (only shown in admin view).

 

 

Add New Property Manually

/node/add

 

Fill in information similar to existing imported properties.

 

New Spreadsheet Imports

/admin/content/data-import

 

NOTE:  The import runs up hits to Google Maps, and if we run it too often, they'll block us.

 
 
 
 
 

Objective

 

Create a new properties search interface that bypasses the click map with a UI that allows for instant filtering and results.

Return 3 types of property listings:

  • Listing Type A: Featured properties | Enhanced Squarespace driven landing pages
  • Listing Type B: The existing property pages
  • Listing Type C: Data from the spreadsheet in a simplified, limited, but complete (as far as search) results set.

Website Data September 2016 (cube)

 

10/5/2016 Spreadsheet

Square Footage Low/High

LOW: 2000

LOW: 2000

HIGH: 275k

HIGH: 275k

 

10/3/2016 Carla to Rick Greenbury

The purpose of the list is to create a multi-select search function on the website - instead of a map or other means to find a building (think: Zillow).

Fields to build the database of current owned/managed buildings for the website would include:

 

  • Yardi ID
  • Address
  • City
  • State
  • Zip
  • County (if available)
  • MSA (if available)
  • Geocode coordinates lat/long (if available) 
  • Building name
  • On / off campus
  • Health sys affiliation
  • Hospital affiliation
  • Building size (sf)
  • If there is a field indicating building is a disco - please include
  • If there are other fields in Yardi you think could be useful, please feel free to include
 

10/5/2016 spreadsheet (above) from Rick G.

  • Property ID
  • Property Name
  • Is Held For Sale
  • Address
  • City
  • Postal Code
  • State
  • Property MSA
  • Metropolitan Statistical Area Rank
  • Hospital
  • Hospital System Affiliation
  • On Off Campus
  • Building RSF

    GL Cube
     
  • Property #
  • Property Name
  • Is held For Sale
  • Hospital
  • Hospital System Affiliation
  • On Off Campus

    VAMS Cube
     
  • Property ID
  • Property Name
  • Address
  • City
  • Potal Code
  • State
  • Property MSA
  • Metropolitan Statistical Area Rank
  • Disposition Date
  • MOB - Occupied SF
  • MOB - Total SF
  • MOB Occupancy