trees
29 rows where Zip Codes = 58 and qSpecies_id = 35 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80290 | 200146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 6101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6013586.8559 | 2091305.2042 | 37.7230902914135 | -122.395134667477 | (37.7230902914135, -122.395134667477) | 10 | 3 | 8 | 58 | 1 | |||
85596 | 87013 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | 10 | 3 | 8 | 58 | 1 | |||
54367 | 253555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 27 Ceres St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | ||||
42016 | 87018 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | 10 | 3 | 8 | 58 | 1 | |||
165176 | 87017 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1200 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | 10 | 3 | 8 | 58 | 1 | |||
21134 | 87016 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
109718 | 87015 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
160963 | 87014 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
62488 | 200617 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 58 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | 10 | 3 | 8 | 58 | 1 | |||
153030 | 200615 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 56 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.385540596193 | (37.7336853915549, -122.385540596193) | 10 | 3 | 8 | 58 | 1 | |||
118418 | 200613 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 54 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.7337226328106 | -122.385566946165 | (37.7337226328106, -122.385566946165) | 10 | 3 | 8 | 58 | 1 | |||
169125 | 200573 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 43 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016335.7649 | 2095440.4518 | 37.7345973496971 | -122.385920256211 | (37.7345973496971, -122.385920256211) | 10 | 3 | 8 | 58 | 1 | |||
122774 | 200572 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 42 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016330.8681 | 2095450.735 | 37.7346253143087 | -122.385937902813 | (37.7346253143087, -122.385937902813) | 10 | 3 | 8 | 58 | 1 | |||
131403 | 200571 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 41 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | 10 | 3 | 8 | 58 | 1 | |||
158562 | 200567 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 39 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016322.0539 | 2095480.6054 | 37.7347068446432 | -122.385970458247 | (37.7347068446432, -122.385970458247) | 10 | 3 | 8 | 58 | 1 | |||
86690 | 200559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 35 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | 10 | 3 | 8 | 58 | 1 | |||
136381 | 200558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 34 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016305.3951 | 2095506.8264 | 37.7347779203 | -122.386029881179 | (37.7347779203, -122.386029881179) | 10 | 3 | 8 | 58 | 1 | |||
178827 | 200557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 33 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016298.6383 | 2095516.7839 | 37.7348048876468 | -122.386053935891 | (37.7348048876468, -122.386053935891) | 10 | 3 | 8 | 58 | 1 | |||
22825 | 200547 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 23 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016201.7309 | 2095635.0286 | 37.7351242000527 | -122.386397222999 | (37.7351242000527, -122.386397222999) | 10 | 3 | 8 | 58 | 1 | |||
54931 | 200542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 18 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016191.4179 | 2095647.8311 | 37.7351587822654 | -122.38643377144 | (37.7351587822654, -122.38643377144) | 10 | 3 | 8 | 58 | 1 | |||
54454 | 200536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191 | (37.7352092330314, -122.38648971191) | 10 | 3 | 8 | 58 | 1 | |||
186273 | 200533 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 9 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016162.6096 | 2095677.4311 | 37.7352384631645 | -122.386535436358 | (37.7352384631645, -122.386535436358) | 10 | 3 | 8 | 58 | 1 | |||
174672 | 200529 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6016150.0239 | 2095691.2754 | 37.7352757800904 | -122.386579915171 | (37.7352757800904, -122.386579915171) | 10 | 3 | 8 | 58 | 1 | |||
71238 | 200528 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6016143.3115 | 2095696.7293 | 37.7352903838014 | -122.386603502798 | (37.7352903838014, -122.386603502798) | 10 | 3 | 8 | 58 | 1 | |||
71060 | 200527 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016132.8234 | 2095707.6369 | 37.7353197532414 | -122.386640524716 | (37.7353197532414, -122.386640524716) | 10 | 3 | 8 | 58 | 1 | |||
179540 | 200526 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 2 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6016126.5305 | 2095710.5736 | 37.7353274684402 | -122.386662486514 | (37.7353274684402, -122.386662486514) | 10 | 3 | 8 | 58 | 1 | |||
9009 | 258692 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100x Whitney Young Cir | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | |||||
12415 | 258693 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
120683 | 255712 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 618x Mendell St | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 |
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) );