trees
20 rows where PlotSize = "Width 0ft" and qSpecies_id = 133
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9249 | 183317 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.500875914404 | (37.7640002060456, -122.500875914404) | 1 | 8 | 3 | 56 | 35 | |||
| 19807 | 200076 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014887.9102 | 2093187.7857 | 37.7283317520978 | -122.390768643797 | (37.7283317520978, -122.390768643797) | 10 | 3 | 8 | 58 | 1 | |||
| 33901 | 183040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | 1 | 8 | 3 | 29491 | 35 | |||
| 47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
| 54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
| 74334 | 244873 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | 15 | 5 | 11 | 29492 | 9 | |||
| 95861 | 200074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014921.0644 | 2093162.4986 | 37.7282641582289 | -122.39065226097 | (37.7282641582289, -122.39065226097) | 10 | 3 | 8 | 58 | 1 | |||
| 108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
| 111111 | 137657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.7788044135747 | -122.444756988886 | (37.7788044135747, -122.444756988886) | 15 | 5 | 11 | 29490 | 16 | |||
| 114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
| 118642 | 137632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.444896086774 | (37.7787937523144, -122.444896086774) | 15 | 5 | 11 | 29490 | 16 | |||
| 123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
| 131143 | 199671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1903 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015210.0019 | 2093419.3228 | 37.7289853719934 | -122.389671313679 | (37.7289853719934, -122.389671313679) | 10 | 3 | 8 | 58 | 1 | |||
| 151781 | 200073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014933.989 | 2093151.8218 | 37.7282355589188 | -122.390606833955 | (37.7282355589188, -122.390606833955) | 10 | 3 | 8 | 58 | 1 | |||
| 168589 | 183679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.496998863919 | (37.7626128114068, -122.496998863919) | 1 | 8 | 3 | 56 | 35 | |||
| 170237 | 141302 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 208 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998449.1975 | 2112684.3341 | 37.7809386817499 | -122.449001631605 | (37.7809386817499, -122.449001631605) | 15 | 6 | 2 | 54 | 16 | |||
| 170391 | 200075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014900.2728 | 2093175.985 | 37.7283000356482 | -122.390725081061 | (37.7283000356482, -122.390725081061) | 10 | 3 | 8 | 58 | 1 | |||
| 171037 | 182595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.7466767317389 | -122.4767165565 | (37.7466767317389, -122.4767165565) | 1 | 8 | 3 | 29491 | 35 | |||
| 174811 | 161273 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002889.18037 | 2090346.52899 | 37.7198572690851 | -122.432045948864 | (37.7198572690851, -122.432045948864) | 9 | 7 | 6 | 28861 | 5 | ||
| 193008 | 218121 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994024.91011 | 2100655.57636 | 37.7476568343048 | -122.463434125583 | (37.7476568343048, -122.463434125583) | 1 | 8 | 4 | 29491 | 40 |
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) );