trees
19 rows where Neighborhoods (old) = 2 and qSpecies_id = 63 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
These facets timed out: Police Districts, Neighborhoods (old)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▼ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6140 | 243478 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1499X Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008755.36846 | 2097659.39973 | 37.7402676797185 | -122.412285110476 | (37.7402676797185, -122.412285110476) | 10 | 7 | 7 | 28859 | 2 | |||
18973 | 233322 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 51 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008884.18383 | 2098343.89419 | 37.7421543791283 | -122.411888074199 | (37.7421543791283, -122.411888074199) | 10 | 7 | 7 | 28859 | 2 | |||
108195 | 247896 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 351 Mayflower St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 5ft | 6010145.43386 | 2098385.46575 | 37.7423392041921 | -122.407529975731 | (37.7423392041921, -122.407529975731) | 10 | 7 | 7 | 28859 | 2 | |||
2154 | 234510 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 15 | 6004874.94559 | 2096454.63294 | 37.7367411519672 | -122.425616344829 | (37.7367411519672, -122.425616344829) | 2 | 7 | 5 | 28859 | 2 | ||||
5675 | 261201 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 699x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007339 | 2095419 | 37.7340364554683 | -122.417023656077 | (37.7340364554683, -122.417023656077) | 2 | 7 | 7 | 28859 | 2 | ||||
22573 | 105838 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 39X Bonview St | 1 | Front Yard : Yard | Tree | DPW 1 | 15 | 6007716.90579 | 2099172.41141 | 37.7443637468546 | -122.415982827151 | (37.7443637468546, -122.415982827151) | 2 | 7 | 7 | 28859 | 2 | ||||
32405 | 246702 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Bonview St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6007696.68665 | 2099102.86041 | 37.7441716385189 | -122.416047816374 | (37.7441716385189, -122.416047816374) | 2 | 7 | 7 | 28859 | 2 | ||||
43298 | 23673 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 319 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
58718 | 234516 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90x Peralta Ave | 2 | Median : Yard | Tree | DPW 1 | 15 | Width 10ft | 6010366.95066 | 2100295.32111 | 37.7475956480377 | -122.406898611185 | (37.7475956480377, -122.406898611185) | 2 | 7 | 7 | 28859 | 2 | |||
61382 | 234515 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6010924.44859 | 2100544.92665 | 37.7483121900522 | -122.404988378323 | (37.7483121900522, -122.404988378323) | 2 | 7 | 7 | 28859 | 2 | |||
66441 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009924 | 2099647 | 37.7457907048197 | -122.408384592716 | (37.7457907048197, -122.408384592716) | 2 | 7 | 7 | 28859 | 2 | |||
73422 | 234509 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 25 | 6004750.38207 | 2096347.45133 | 37.7364398161369 | -122.426039387727 | (37.7364398161369, -122.426039387727) | 2 | 7 | 5 | 28859 | 2 | ||||
103851 | 247910 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 399 Franconia St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 6009965.37797 | 2098759.56576 | 37.7433563212371 | -122.408178935533 | (37.7433563212371, -122.408178935533) | 2 | 7 | 7 | 28859 | 2 | ||||
128520 | 246698 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Bonview St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6007671.81678 | 2099058.43431 | 37.7440482560225 | -122.416130665494 | (37.7440482560225, -122.416130665494) | 2 | 7 | 7 | 28859 | 2 | ||||
139657 | 256152 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 80X Peralta Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
152878 | 234517 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Benton Ave | 1 | Median : Yard | Tree | DPW 1 | 29 | 6004828.72428 | 2095028.54608 | 37.7328228256069 | -122.425674682059 | (37.7328228256069, -122.425674682059) | 2 | 7 | 7 | 28861 | 2 | ||||
156992 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x Montcalm St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010036 | 2099760 | 37.7461072494139 | -122.408005278478 | (37.7461072494139, -122.408005278478) | 2 | 7 | 7 | 28859 | 2 | ||||
176495 | 234508 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 201 Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 28 | Width 5ft | 6007691.39954 | 2099521.32268 | 37.745320345265 | -122.416095727735 | (37.745320345265, -122.416095727735) | 2 | 7 | 7 | 28859 | 2 | |||
191676 | 247975 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 503 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 21 | 6009813.28917 | 2099236.81382 | 37.744658223 | -122.408738483811 | (37.744658223, -122.408738483811) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );