-
Notifications
You must be signed in to change notification settings - Fork 4
Data Issues
jerseycoder edited this page Nov 24, 2012
·
5 revisions
Some issues with the playground data:
- Google Places API does not allow for referencing places by their id.
- When doing a search for a Place in Google Places, can only supply lat, long, and what is returned is EVERYTHING in the Google Places database for a particular supplied "Type" (the type which is preset to only certain categories - Playgrounds not being one of them).
Original Data format for playground data is remapped as follows below for ease of use:
- t.string "name" -> no change
- t.integer "mapid" -> no change
- t.string "agelevel" -> no change
- t.integer "totplay" -> refresh data, no change to field name
- t.integer "openaccess" -> change to opentopublic, refresh data
- t.integer "invitation" -> no change
- t.integer "access" -> change to howtogetthere, refresh data
- t.integer "safelocation" -> no change
- t.integer "conditions" -> change to shade, refresh data
- t.integer "monitoring" -> no change
- t.integer "programming" -> no change
- t.integer "weather" -> no change
- t.integer "seating" -> refresh data, no change to field name
- t.integer "restrooms" -> refresh data, no change to field name
- t.integer "drinkingw" -> refresh data, no change to field name
- t.integer "physicald" -> change to activeplay, refresh data
- t.integer "socialdom" -> change to socialplay, refresh data
- t.integer "intellect" -> change to creativeplay, refresh data
- t.integer "naturualen" -> refresh data, no change to field name
- t.integer "freeunstruct" -> change to freeplay, refresh data
- t.text "specificcomments" -> no change
- t.text "generalcomments" -> no change
- t.integer "compsum" -> no change
- t.integer "modsum" -> no change
- t.integer "graspvalue" -> no change
- t.string "playclass" -> no change
- t.text "subarea" -> no change
- t.datetime "created_at" -> no change
- t.datetime "updated_at" -> no change
- t.float "lat"
- t.float "long"
- t.string "google_placesid"
New table
- criteriakeys
- .text "criterianame" -> Actual field name of criteria from playgrounds table
- .integer "scalevalue" -> numerical value
- .text "textvalue" -> text value
11/24 problem identified: For every park listing, there are multiple listings in Google Places based on the different names/variations in names that each park could have. Therefore, have data table for Aliases for each park name:
Table: Alias FK: Playground.id t.string aname