trees
19 rows where Fire Prevention Districts = 2 and qSpecies_id = 98 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17230 | 242808 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007180.24018 | 2105207.60423 | 37.7609048229145 | -122.418266321545 | (37.7609048229145, -122.418266321545) | 2 | 4 | 7 | 28859 | 19 | |||
85221 | 242807 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.55989 | 2105223.19925 | 37.760947661217 | -122.418266321527 | (37.760947661217, -122.418266321527) | 2 | 4 | 7 | 28859 | 19 | |||
96231 | 242805 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007179.22681 | 2105245.51436 | 37.7610088582918 | -122.418272514273 | (37.7610088582918, -122.418272514273) | 2 | 4 | 7 | 28859 | 19 | |||
130102 | 242809 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.51421 | 2105199.12934 | 37.760881568258 | -122.418264772906 | (37.760881568258, -122.418264772906) | 2 | 4 | 7 | 28859 | 19 | |||
150786 | 242806 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007179.92075 | 2105235.69355 | 37.7609819316884 | -122.418269417912 | (37.7609819316884, -122.418269417912) | 2 | 4 | 7 | 28859 | 19 | |||
139376 | 87088 | Permitted Site 7 | Ulmus spp :: Elm Spp 98 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50036 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
80457 | 242810 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3620 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006059.28413 | 2101437.67499 | 37.7504903093996 | -122.421875422335 | (37.7504903093996, -122.421875422335) | 2 | 4 | 5 | 28859 | 19 | |||
73993 | 242798 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3750 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6005399.69435 | 2101395.51192 | 37.7503373194083 | -122.424153337625 | (37.7503373194083, -122.424153337625) | 2 | 4 | 5 | 28859 | 19 | |||
171682 | 242797 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3750 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005422.77896 | 2101397.5471 | 37.7503442109259 | -122.4240736541 | (37.7503442109259, -122.4240736541) | 2 | 4 | 5 | 28859 | 19 | |||
149878 | 242802 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3755 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005401.27831 | 2101358.72982 | 37.7502364136768 | -122.424145244627 | (37.7502364136768, -122.424145244627) | 2 | 4 | 5 | 28859 | 19 | |||
71278 | 25187 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3765 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000249.08614 | 2102834.07361 | 37.7539951005144 | -122.442067687981 | (37.7539951005144, -122.442067687981) | 2 | 4 | 5 | 63 | 38 | |||
69075 | 242800 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3775 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6005335.62293 | 2101352.55073 | 37.7502157400659 | -122.424371845882 | (37.7502157400659, -122.424371845882) | 2 | 4 | 5 | 28859 | 19 | |||
180558 | 242801 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3775 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6005357.61324 | 2101353.89107 | 37.7502206620698 | -122.424295897257 | (37.7502206620698, -122.424295897257) | 2 | 4 | 5 | 28859 | 19 | |||
79597 | 242799 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3799 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 6005227.89709 | 2101349.02972 | 37.7501999884601 | -122.424744118457 | (37.7501999884601, -122.424744118457) | 2 | 4 | 5 | 28859 | 19 | |||
104475 | 242803 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 6ft | 6005476.43132 | 2101343.24584 | 37.7501981412405 | -122.423884259558 | (37.7501981412405, -122.423884259558) | 2 | 4 | 5 | 28859 | 19 | |||
19603 | 119905 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 517 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003302 | 2096146 | 37.7358047110715 | -122.431032679091 | (37.7358047110715, -122.431032679091) | 2 | 7 | 5 | 63 | 7 | ||||
61872 | 242804 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 517 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003295.69623 | 2096166.76652 | 37.7358613739981 | -122.431055955391 | (37.7358613739981, -122.431055955391) | 2 | 7 | 5 | 63 | 7 | |||
15812 | 243781 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 530 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007733.67911 | 2095675.76674 | 37.7347636749953 | -122.415677298363 | (37.7347636749953, -122.415677298363) | 2 | 7 | 7 | 28859 | 2 | |||
9499 | 10082 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005631.67807 | 2105272.56381 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | 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) );