trees
23 rows where DBH = 5, Fire Prevention Districts = 8 and qSpecies_id = 50
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9980 | 110373 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
20883 | 229739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | 8 | 4 | 5 | 28859 | 19 | |||
21203 | 190740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010535.58814 | 2107583.98443 | 37.7676181235051 | -122.406829079197 | (37.7676181235051, -122.406829079197) | 8 | 4 | 8 | 28853 | 19 | |||
45167 | 110369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.407448516042 | (37.7683165361048, -122.407448516042) | 8 | 4 | 8 | 28853 | 19 | |||
48019 | 190731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010525.63223 | 2107742.12089 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | 8 | 4 | 8 | 28853 | 19 | |||
52726 | 226462 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007188.60102 | 2106179.35089 | 37.7635734837649 | -122.418306305386 | (37.7635734837649, -122.418306305386) | 8 | 4 | 7 | 28859 | 19 | |||
70077 | 110371 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
98448 | 190738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010533.72626 | 2107613.44503 | 37.7676989114041 | -122.406837595798 | (37.7676989114041, -122.406837595798) | 8 | 4 | 8 | 28853 | 19 | |||
99494 | 110374 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
99838 | 228533 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | 8 | 4 | 7 | 28853 | 19 | |||
105723 | 110372 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
117455 | 190725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.407179113336 | (37.7683353022519, -122.407179113336) | 8 | 4 | 8 | 28853 | 19 | |||
128607 | 229793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Trainor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008301.70607 | 2108167.22951 | 37.7690943309545 | -122.414597094793 | (37.7690943309545, -122.414597094793) | 8 | 4 | 7 | 28853 | 19 | |||
131487 | 228534 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.410992374607 | (37.7669349094434, -122.410992374607) | 8 | 4 | 7 | 28853 | 19 | |||
139411 | 228538 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009238.10189 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | 8 | 4 | 7 | 28853 | 19 | |||
144753 | 229809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009528.66718 | 2106237.67868 | 37.7638650844166 | -122.410216840643 | (37.7638650844166, -122.410216840643) | 8 | 4 | 8 | 28859 | 19 | |||
147709 | 110368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | 8 | 4 | 8 | 28853 | 19 | |||
160502 | 190735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | 8 | 4 | 8 | 28853 | 19 | |||
171679 | 110370 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
175279 | 190729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010522.64899 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | 8 | 4 | 8 | 28853 | 19 | |||
180841 | 190739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010536.50922 | 2107598.98356 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | 8 | 4 | 8 | 28853 | 19 | |||
186236 | 226328 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007822.68734 | 2105830.62056 | 37.7626516238081 | -122.416088496301 | (37.7626516238081, -122.416088496301) | 8 | 4 | 7 | 28859 | 19 | |||
194227 | 228537 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009258.78622 | 2107356.53697 | 37.7669220806253 | -122.411229322595 | (37.7669220806253, -122.411229322595) | 8 | 4 | 7 | 28853 | 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) );