trees
15 rows where PlotSize = "Width 6ft" and qSpecies_id = 6
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
12985 | 229829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1472 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 6ft | 6010097.10021 | 2100699.13339 | 37.7486893243481 | -122.407860213076 | (37.7486893243481, -122.407860213076) | 2 | 4 | 7 | 28859 | 19 | ||
21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 1 | |||
63555 | 201813 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.7288565518864 | -122.369345258092 | (37.7288565518864, -122.369345258092) | 10 | 3 | 8 | 58 | 1 | ||
80797 | 201815 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | 10 | 3 | 8 | 58 | 1 | ||
112005 | 227095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6005946.52179 | 2104309.35666 | 37.7583689226977 | -122.422469389447 | (37.7583689226977, -122.422469389447) | 2 | 4 | 5 | 28859 | 19 | |||
125237 | 201811 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | 10 | 3 | 8 | 58 | 1 | |||
135455 | 201808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 247 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | 10 | 3 | 8 | 58 | 1 | |||
136658 | 227102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1451 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003961.99133 | 2099782.46881 | 37.7458269972341 | -122.4290100202 | (37.7458269972341, -122.4290100202) | 2 | 7 | 5 | 63 | 22 | |||
156146 | 201814 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.369257791817 | (37.728943392223, -122.369257791817) | 10 | 3 | 8 | 58 | 1 | ||
175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
193987 | 201809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 237 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020945.51773 | 2093059.30039 | 37.7283131886973 | -122.369818081152 | (37.7283131886973, -122.369818081152) | 10 | 3 | 8 | 58 | 1 |
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) );