trees
23 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 124
This data as json, CSV (advanced)
Location ✖
- (37.7129218386335, -122.472360778797) 9
- (37.7412487294723, -122.440130121954) 2
- (37.7465000939866, -122.429093192907) 2
- (37.7306120580701, -122.450547001775) 1
- (37.7431350167668, -122.433288323925) 1
- (37.745574339333, -122.434624822764) 1
- (37.7505323633681, -122.441515551873) 1
- (37.7530927489395, -122.421374265597) 1
- (37.7551075738744, -122.455348004876) 1
- (37.7617865703457, -122.438527441627) 1
- (37.7629107285672, -122.440577579902) 1
- (37.7702434139345, -122.430641520581) 1
- (37.7893679393503, -122.398843573251) 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
621 | 104871 | Undocumented 4 | Acer japonicum :: Japanese Maple 124 | 50-52 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x4 | Permit Number 770461 | 6000747.1 | 2106070.8 | 37.7629107285672 | -122.440577579902 | (37.7629107285672, -122.440577579902) | 15 | 5 | 5 | 28862 | 3 | |||
4521 | 264728 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 75 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:00:00 AM | 3 | 2.5x3 | Permit Number 785580 | 6000712.91132 | 2098182.25098 | 37.7412487294723 | -122.440130121954 | (37.7412487294723, -122.440130121954) | 2 | 7 | 5 | 63 | 7 | |
11904 | 264727 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 75 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:00:00 AM | 3 | 2.5x3 | Permit Number 785580 | 6000712.91132 | 2098182.25098 | 37.7412487294723 | -122.440130121954 | (37.7412487294723, -122.440130121954) | 2 | 7 | 5 | 63 | 7 | |
22415 | 254782 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
23274 | 105044 | Undocumented 4 | Acer japonicum :: Japanese Maple 124 | 115 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 6006223.6 | 2102382.1 | 37.7530927489395 | -122.421374265597 | (37.7530927489395, -122.421374265597) | 2 | 4 | 5 | 28859 | 19 | ||||
28239 | 25165 | DPW Maintained 1 | Acer japonicum :: Japanese Maple 124 | 2710 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001331.1247754 | 2105649.2774538 | 37.7617865703457 | -122.438527441627 | (37.7617865703457, -122.438527441627) | 15 | 4 | 5 | 28862 | 3 | |||
37597 | 254781 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
42081 | 51535 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 575 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | Permit Number 47836 | 5997620.77530153 | 2094372.6871886 | 37.7306120580701 | -122.450547001775 | (37.7306120580701, -122.450547001775) | 9 | 7 | 4 | 28861 | 40 | |||
58122 | 120503 | Undocumented 4 | Acer japonicum :: Japanese Maple 124 | 50X Ecker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013004 | 2115455 | 37.7893679393503 | -122.398843573251 | (37.7893679393503, -122.398843573251) | 12 | 2 | 9 | 28855 | 6 | ||||
58601 | 254784 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
74177 | 105990 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 651X Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002337 | 2099724 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | 2 | 7 | 5 | 63 | 22 | |||||
95362 | 106973 | Undocumented 4 | Acer japonicum :: Japanese Maple 124 | 493 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002705 | 2098828 | 37.7431350167668 | -122.433288323925 | (37.7431350167668, -122.433288323925) | 2 | 7 | 5 | 63 | 22 | ||||
96843 | 107207 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 15 Fountain St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2014 12:00:00 AM | 3x3 | Permit Number 769542 | 6000382.52033 | 2101570.18202 | 37.7505323633681 | -122.441515551873 | (37.7505323633681, -122.441515551873) | 2 | 4 | 5 | 28862 | 22 | |||
99670 | 67240 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 332 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1998 12:00:00 AM | 6 | Permit Number 30704 | 6003673.76431871 | 2108680.81312012 | 37.7702434139345 | -122.430641520581 | (37.7702434139345, -122.430641520581) | 15 | 9 | 11 | 29492 | 10 | |
100787 | 253125 | DPW Maintained 1 | Acer japonicum :: Japanese Maple 124 | 1 Oak Park Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5996419 | 2103319 | 37.7551075738744 | -122.455348004876 | (37.7551075738744, -122.455348004876) | 1 | 5 | 4 | 63 | 12 | ||||
113968 | 254789 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
115970 | 95090 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 1409 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2010 12:00:00 AM | 3x3 | Permit Number 54028 | 6003943 | 2100028 | 37.7465000939866 | -122.429093192907 | (37.7465000939866, -122.429093192907) | 2 | 7 | 5 | 63 | 22 | ||
133159 | 254790 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
134708 | 254791 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
164659 | 254793 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
183688 | 95089 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 1409 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2010 12:00:00 AM | 3x3 | Permit Number 54028 | 6003943 | 2100028 | 37.7465000939866 | -122.429093192907 | (37.7465000939866, -122.429093192907) | 2 | 7 | 5 | 63 | 22 | ||
183948 | 254783 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
189732 | 254792 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 |
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) );