trees
395 rows where qSpecies_id = 35 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2100 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Side Yard : Cutout | Tree | Private 2 | 5x10 | ||||||||||||||
3808 | 20305 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
3943 | 87019 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 10 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49949 | |||||||||||||
4106 | 19663 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5212 | 19664 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5625 | 19976 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
6586 | 258122 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:11:00 PM | 3 | 5x5 | ||||||||||||
6613 | 19666 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
6935 | 258120 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:06:00 PM | 3 | 5x5 | ||||||||||||
7691 | 19980 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
7975 | 19667 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
13326 | 258119 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:14:00 PM | 3 | 5x5 | ||||||||||||
13843 | 20301 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
14131 | 258121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:09:00 PM | 3 | 5x5 | ||||||||||||
15936 | 19986 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
57367 | 132164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011515.19186 | 2120799.84951 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | 3 | 1 | 10 | 28860 | 6 | |||
58106 | 132162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.407713714409 | (37.8053168133783, -122.407713714409) | 3 | 1 | 10 | 308 | 23 | ||||
129267 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 600 Front St | Front Yard : Yard | Tree | Private 2 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.399449857041 | (37.7974274520849, -122.399449857041) | 3 | 1 | 10 | 28860 | 6 | ||||
129810 | 132163 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011528.08163 | 2120803.57488 | 37.8039714887622 | -122.404326723704 | (37.8039714887622, -122.404326723704) | 3 | 1 | 10 | 28860 | 6 | |||
172237 | 108298 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 10X Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830 | 2116175 | 37.7913351933509 | -122.399496166675 | (37.7913351933509, -122.399496166675) | 4 | 1 | 10 | 28854 | 6 | ||
182602 | 132161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 6010552.8238 | 2121311.79296 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | 3 | 1 | 10 | 308 | 23 | ||||
3739 | 261012 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
18405 | 261011 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
25362 | 194422 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 52 | Width 5ft | 6007901.53326 | 2109054.57818 | 37.771508291196 | -122.416044121944 | (37.771508291196, -122.416044121944) | 8 | 2 | 9 | 28853 | 19 | |||
82054 | 194426 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 5ft | 6007946.83693 | 2109121.10943 | 37.7716935173803 | -122.415892125715 | (37.7716935173803, -122.415892125715) | 8 | 2 | 9 | 28853 | 19 | |||
90902 | 194427 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008110 | 2110227 | 37.7747392032863 | -122.415406037323 | (37.7747392032863, -122.415406037323) | 8 | 2 | 9 | 28853 | 34 | |||
100596 | 194423 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 5ft | 6007917.867 | 2109077.33792 | 37.771571702413 | -122.41598923453 | (37.771571702413, -122.41598923453) | 8 | 2 | 9 | 28853 | 19 | |||
129835 | 194424 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 5ft | 6007931.05098 | 2109095.29996 | 37.7716217631679 | -122.415944902456 | (37.7716217631679, -122.415944902456) | 8 | 2 | 9 | 28853 | 19 | |||
133229 | 194425 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6007938.01013 | 2109107.31213 | 37.771655137004 | -122.415921681048 | (37.771655137004, -122.415921681048) | 8 | 2 | 9 | 28853 | 19 | |||
192931 | 173637 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008672 | 2111900 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | 8 | 2 | 9 | 28853 | 34 | ||||
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 | |||||
9342 | 23614 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
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 | |||
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 | |||
32593 | 23612 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | 10 | 3 | 8 | 28856 | 29 | |||
33716 | 178129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 345 Tocoloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012554.38724 | 2086809.43241 | 37.7106883309719 | -122.398388432799 | (37.7106883309719, -122.398388432799) | 10 | 3 | 8 | 309 | 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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
161693 | 3773 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1098 Carolina St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | |||
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 | |||
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 | |||
178910 | 61559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1096 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.7547787864142 | -122.399837764002 | (37.7547787864142, -122.399837764002) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | |||
71549 | 234477 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Grand View Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999979.48342 | 2101750.0189 | 37.7510031819599 | -122.442922193204 | (37.7510031819599, -122.442922193204) | 2 | 4 | 5 | 28862 | 22 | ||||
86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
107565 | 252925 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Sanchez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
120441 | 234471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350 Noe St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6003196.85258 | 2100348.13678 | 37.7473368492221 | -122.431696139568 | (37.7473368492221, -122.431696139568) | 2 | 4 | 5 | 63 | 22 | ||||
186953 | 173744 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
193081 | 173746 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
19548 | 234472 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4810 17th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 2ft | 5998175.60392 | 2105685.14055 | 37.7617050378737 | -122.449443663887 | (37.7617050378737, -122.449443663887) | 15 | 5 | 11 | 29492 | 9 | |||
20185 | 8536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651 | (37.7837972495813, -122.43786449651) | 15 | 5 | 11 | 29490 | 13 | ||
23996 | 8576 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | 15 | 5 | 11 | 29490 | 41 | |||
26940 | 8472 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | 13 | 5 | 11 | 29490 | 41 | |||
38568 | 8471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.7838791576421 | -122.43635890448 | (37.7838791576421, -122.43635890448) | 13 | 5 | 11 | 29490 | 41 | ||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
65234 | 8577 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.7831949132778 | -122.440376203878 | (37.7831949132778, -122.440376203878) | 15 | 5 | 11 | 29490 | 41 | |||
66433 | 8563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
71757 | 8562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
83309 | 247525 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101 Waller St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | 6000029.93527 | 2108491.27934 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | 15 | 5 | 11 | 29492 | 9 | ||||
101800 | 8581 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | 15 | 5 | 1 | 29490 | 41 | |||
107231 | 8560 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
110569 | 8474 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001879.2717 | 2113651.882 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | 13 | 5 | 11 | 29490 | 41 | |||
112575 | 8469 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | 13 | 5 | 11 | 29490 | 41 | |||
113256 | 8561 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
116060 | 8575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | 15 | 5 | 11 | 29490 | 41 | |||
122803 | 8535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | 15 | 5 | 11 | 29490 | 41 | |||
126371 | 8532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.7835757427727 | -122.438389071264 | (37.7835757427727, -122.438389071264) | 15 | 5 | 11 | 29490 | 41 | ||
127126 | 8475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.437368062109 | (37.7837696172579, -122.437368062109) | 13 | 5 | 11 | 29490 | 41 | ||
141624 | 8586 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.7829526738098 | -122.442300177437 | (37.7829526738098, -122.442300177437) | 15 | 5 | 1 | 29490 | 41 | |||
170733 | 8578 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.440558168856 | (37.7831658887746, -122.440558168856) | 15 | 5 | 11 | 29490 | 41 | |||
183037 | 8530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.7836763773468 | -122.438063730933 | (37.7836763773468, -122.438063730933) | 15 | 5 | 11 | 29490 | 41 | |||
186033 | 8582 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000649.7853 | 2113412.1102 | 37.7830625764785 | -122.441440973241 | (37.7830625764785, -122.441440973241) | 15 | 5 | 1 | 29490 | 41 | |||
187307 | 8537 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 3 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651 | (37.7837972495813, -122.43786449651) | 15 | 5 | 11 | 29490 | 13 | ||
22684 | 120262 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 24th Ave | 6 | Side Yard : Yard | Tree | Private 2 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | 11 | 6 | 1 | 55 | 33 | ||||
33534 | 27300 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.93354 | 2112415.51016 | 37.7792783288562 | -122.503991098801 | (37.7792783288562, -122.503991098801) | 11 | 6 | 2 | 55 | 26 | ||
82660 | 27295 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 2 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.7792423135673 | -122.503361806845 | (37.7792423135673, -122.503361806845) | 11 | 6 | 2 | 55 | 26 | ||
83492 | 116067 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4150X CLEMENT ST | 5 | Front Yard : Yard | Tree | DPW 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |
136516 | 27297 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 4 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.86392 | 2112396.64212 | 37.7792343387449 | -122.503529847504 | (37.7792343387449, -122.503529847504) | 11 | 6 | 2 | 55 | 26 | ||
144700 | 118538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900x Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 5982472.23583 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | 11 | 6 | 2 | 55 | 26 |
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) );