Project: Listing Data Query

Cass: Please send me the query that pulls listing data from pub_data.

11/08/10Listing Data Query

Try: Search local files in Textpad for the string "pub_data"

Found: /Query/sel/selSearch_View.cfm

Dump Attributes

  • Try: There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment.
  • Result: There is no dump, the page renders, but the page does not load houses.

Middle School

  • Try: Find a Laurelhurst, WA listing with no middle school, add "PostonJH" to the default in selSearchView.cfm and see if it adds it.
  • Result: jhs is not listed with the defaults.

To Do

  • SQL - find the zip code with the smallest number of listing. Neighborhood.
  • Make a table of all the abbr. Column names in table pub_data and their meanings. Is it on the other side of the map? Is it in the wiki?

 

 


Stephen Lloyd 11/12/2010