trees
19 rows where qSpecies_id = 329
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9000 | 223865 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 3700x Cesar Chavez St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 6005794.48367 | 2100533.61064 | 37.7479930188582 | -122.422726883358 | (37.7479930188582, -122.422726883358) | 2 | 4 | 5 | 28859 | 19 | |||
11824 | 191028 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 2001 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6012030.23365 | 2104647.01449 | 37.7596373777823 | -122.401452828609 | (37.7596373777823, -122.401452828609) | 10 | 3 | 8 | 28856 | 29 | |||
17080 | 191027 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 1226 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6012209.7471 | 2102663.13028 | 37.7542000820704 | -122.400692606487 | (37.7542000820704, -122.400692606487) | 10 | 3 | 8 | 28856 | 29 | |||
45698 | 223868 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 2384 Bryant St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6009659.2481 | 2103464.07176 | 37.756256706598 | -122.409569427713 | (37.756256706598, -122.409569427713) | 2 | 4 | 7 | 28859 | 19 | |||
64732 | 223864 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 3700x Cesar Chavez St | 3 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005797.02686 | 2100532.2784 | 37.7479895043193 | -122.422717994438 | (37.7479895043193, -122.422717994438) | 2 | 4 | 5 | 28859 | 19 | |||
90193 | 191026 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 1 01st St | 36 | : Yard | Tree | Private 2 | 3 | 6014407.16325 | 2105848.78864 | 37.7630695252734 | -122.39331625017 | (37.7630695252734, -122.39331625017) | 14 | 3 | 8 | 28856 | 29 | ||||
97908 | 223866 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 80 Crescent Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6005736.0227 | 2095841.06058 | 37.7351050369637 | -122.422595634486 | (37.7351050369637, -122.422595634486) | 2 | 7 | 7 | 28859 | 2 | |||
102756 | 191029 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 391 Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013535.17719 | 2105290.81935 | 37.7614889802521 | -122.396293066368 | (37.7614889802521, -122.396293066368) | 10 | 3 | 8 | 28856 | 29 | |||
104124 | 191025 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 651 Indiana St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6014935.69293 | 2105477.06738 | 37.7620782088543 | -122.39146224199 | (37.7620782088543, -122.39146224199) | 10 | 3 | 8 | 28856 | 29 | |||
116049 | 120303 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 100 23rd Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988688.03017 | 2114630.28331 | 37.7857186225503 | -122.482912572966 | (37.7857186225503, -122.482912572966) | 11 | 6 | 2 | 55 | 26 | |||
132109 | 223862 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 3700x Cesar Chavez St | 1 | Median : Yard | Tree | DPW 1 | 6 | Width 10ft | 6005812.2615 | 2100535.54919 | 37.7479993446903 | -122.422665546004 | (37.7479993446903, -122.422665546004) | 2 | 4 | 5 | 28859 | 19 | |||
158116 | 126438 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 2050 Jefferson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999370.7019 | 2121207.88873 | 37.804394767271 | -122.446427080551 | (37.804394767271, -122.446427080551) | 13 | 9 | 1 | 57 | 17 | |||
158262 | 223867 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6005747.79395 | 2102034.14409 | 37.7521105046093 | -122.422994969468 | (37.7521105046093, -122.422994969468) | 2 | 4 | 5 | 28859 | 19 | |||
162041 | 191024 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 651 Indiana St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6014935.68201 | 2105456.52437 | 37.7620218015918 | -122.391460843542 | (37.7620218015918, -122.391460843542) | 10 | 3 | 8 | 28856 | 29 | |||
166060 | 223869 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 321 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006997.13212 | 2096570.70423 | 37.7371795444991 | -122.418287231674 | (37.7371795444991, -122.418287231674) | 2 | 7 | 7 | 28859 | 2 | |||
166516 | 126437 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 2226 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999525.7287 | 2120876.0232 | 37.8034924073 | -122.445866716574 | (37.8034924073, -122.445866716574) | 13 | 9 | 1 | 57 | 17 | |||
166732 | 2344 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 2384 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6009657.78009 | 2103471.05124 | 37.7562757884232 | -122.409574997205 | (37.7562757884232, -122.409574997205) | 2 | 4 | 7 | 28859 | 19 | ||
167161 | 191030 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 525 Phelps St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015416.50787 | 2098128.73874 | 37.7419279217349 | -122.38928612366 | (37.7419279217349, -122.38928612366) | 10 | 3 | 8 | 58 | 1 | |||
185639 | 223863 | DPW Maintained 1 | Cussonia spicata :: Cabbage tree 329 | 3700x Cesar Chavez St | 2 | Median : Yard | Tree | DPW 1 | 9 | Width 10ft | 6005802.97917 | 2100534.20381 | 37.7479951268836 | -122.422697548374 | (37.7479951268836, -122.422697548374) | 2 | 4 | 5 | 28859 | 19 |
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) );