trees
17 rows where qSpecies_id = 441
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37848 | 233926 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2427 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6011248.07781 | 2102739.69759 | 37.7543566360652 | -122.404023703426 | (37.7543566360652, -122.404023703426) | 10 | 4 | 8 | 28859 | 19 | ||
40111 | 968 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 1590 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001795.10153 | 2092966.31669 | 37.7269885268937 | -122.43601515438 | (37.7269885268937, -122.43601515438) | 9 | 7 | 6 | 28861 | 25 | |||
41768 | 233925 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2427 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6011235.05581 | 2102740.23311 | 37.7543573789161 | -122.404068774755 | (37.7543573789161, -122.404068774755) | 10 | 4 | 8 | 28859 | 19 | ||
43657 | 1494 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 324 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995577.80377 | 2114269.78736 | 37.7851272759959 | -122.459049963834 | (37.7851272759959, -122.459049963834) | 11 | 6 | 1 | 54 | 31 | |||
49030 | 178082 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 642 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009934.88848 | 2090246.95019 | 37.7199807792642 | -122.40768426881 | (37.7199807792642, -122.40768426881) | 10 | 3 | 7 | 309 | 28 | |||
94325 | 123630 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 237 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995501.76344 | 2114684.47732 | 37.7862615315277 | -122.459343079595 | (37.7862615315277, -122.459343079595) | 11 | 6 | 1 | 54 | 11 | |||
98058 | 210902 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 200x Terrace Dr | 43 | Median : Yard | Tree | DPW 1 | 9 | 5993874.81646 | 2096520.07215 | 37.7362931286123 | -122.463653037673 | (37.7362931286123, -122.463653037673) | 1 | 8 | 4 | 59 | 40 | ||||
110218 | 178083 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 1424 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002295.33122 | 2093719.99221 | 37.729086354732 | -122.434339731789 | (37.729086354732, -122.434339731789) | 9 | 7 | 6 | 28861 | 25 | |||
135733 | 1491 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 306 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5995572.60896 | 2114379.78311 | 37.7854289961432 | -122.459075903561 | (37.7854289961432, -122.459075903561) | 11 | 6 | 1 | 54 | 31 | |||
137413 | 27663 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 930 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X10 | 6009093.83073 | 2089989.28092 | 37.7192261554318 | -122.410573341811 | (37.7192261554318, -122.410573341811) | 9 | 3 | 7 | 309 | 28 | |||
138495 | 1521 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 412 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/1994 12:00:00 AM | 18 | 9x5 | 5995599.47459 | 2113643.2041 | 37.7834080920918 | -122.45892960755 | (37.7834080920918, -122.45892960755) | 11 | 6 | 1 | 54 | 31 | ||
142141 | 132066 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 101 Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999324.39961 | 2119524.85026 | 37.7997709524386 | -122.446466156986 | (37.7997709524386, -122.446466156986) | 13 | 9 | 1 | 57 | 17 | |||
145944 | 96721 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2049 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007184.38277 | 2119401.11743 | 37.7998770112863 | -122.419258865528 | (37.7998770112863, -122.419258865528) | 5 | 1 | 1 | 28858 | 32 | |||
146702 | 233924 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2427 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6011189.3984 | 2102738.18792 | 37.7543492121551 | -122.404226526651 | (37.7543492121551, -122.404226526651) | 10 | 4 | 8 | 28859 | 19 | ||
146967 | 10352 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 1001 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001272.05571 | 2108987.20412 | 37.7709483319284 | -122.438970960635 | (37.7709483319284, -122.438970960635) | 15 | 5 | 11 | 29492 | 9 | |||
175357 | 96722 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2049 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007183.55193 | 2119384.91309 | 37.7998324714572 | -122.419260590431 | (37.7998324714572, -122.419260590431) | 5 | 1 | 1 | 28858 | 32 | |||
190861 | 132065 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2400 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000294.13235 | 2119593.15257 | 37.8000138323267 | -122.443115441341 | (37.8000138323267, -122.443115441341) | 13 | 9 | 1 | 57 | 17 |
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) );