trees
614 rows where qSpecies_id = 29 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194319 | 252846 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
194297 | 252847 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
193221 | 246761 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 5 | Front Yard : Yard | Tree | Private 2 | 16 | 6009235.42267 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | 2 | 7 | 7 | 28859 | 2 | ||||
193050 | 112539 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | 3 | 1 | 10 | 308 | 23 | ||
192970 | 214028 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.439675077642 | (37.7312270433827, -122.439675077642) | 9 | 7 | 4 | 63 | 40 | |||
192914 | 89014 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2147 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2008 12:00:00 AM | 3X3 | Permit Number 51763 | 6008963 | 2120596 | 37.803257869178 | -122.413188701365 | (37.803257869178, -122.413188701365) | 3 | 1 | 10 | 308 | 23 | |||
192605 | 47744 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982434.29257 | 2113064.02501 | 37.7810522765206 | -122.504432281557 | (37.7810522765206, -122.504432281557) | 11 | 6 | 2 | 55 | 26 | |
192565 | 214025 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.8435 | 2094480.08399 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | 9 | 7 | 4 | 63 | 40 | |||
191792 | 50561 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2365 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.447268015984 | (37.7810296062885, -122.447268015984) | 15 | 5 | 1 | 54 | 16 | |||
191578 | 41726 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
191500 | 41691 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107594 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | 2 | 7 | 5 | 63 | 7 | |||
191450 | 122282 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990106.33926 | 2111321.30269 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | 11 | 6 | 2 | 55 | 26 | |||
191449 | 240376 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007185.77161 | 2107529.73267 | 37.7672811565308 | -122.418411847135 | (37.7672811565308, -122.418411847135) | 8 | 4 | 7 | 28853 | 19 | |||
191033 | 34936 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 11 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1997 12:00:00 AM | Permit Number 38531 | 6004292.24994663 | 2098281.86304207 | 37.7417253672991 | -122.427761131369 | (37.7417253672991, -122.427761131369) | 2 | 7 | 5 | 63 | 7 | |||
190786 | 81886 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 44 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50856 | 6001667.32434 | 2120063.59572 | 37.8013837462123 | -122.438397406323 | (37.8013837462123, -122.438397406323) | 13 | 9 | 1 | 57 | 17 | |
190732 | 253817 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001018 | 2098627 | 37.7424872697547 | -122.439107103686 | (37.7424872697547, -122.439107103686) | 2 | 7 | 5 | 63 | 7 | ||||
190698 | 136321 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | 3 | 1 | 10 | 308 | 23 | ||||
190642 | 117962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | 11 | 6 | 2 | 55 | 26 | |||
190458 | 240404 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4362 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000898.63467 | 2103311.26449 | 37.7553423460847 | -122.439855611169 | (37.7553423460847, -122.439855611169) | 2 | 4 | 5 | 28862 | 38 | |||
190336 | 240406 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | 2 | 7 | 5 | 63 | 7 | |||
189923 | 41745 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
188763 | 100236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5983814.22353 | 2110811.15249 | 37.7749476096575 | -122.499491947241 | (37.7749476096575, -122.499491947241) | 11 | 6 | 2 | 55 | 26 | |||
188192 | 38638 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | ||
187916 | 87935 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 | ||
187632 | 197333 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014202.14844 | 2101967.42619 | 37.7524007500093 | -122.393753643523 | (37.7524007500093, -122.393753643523) | 10 | 3 | 8 | 28856 | 1 | ||||
187462 | 122278 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.7767187801238 | -122.477666227559 | (37.7767187801238, -122.477666227559) | 11 | 6 | 2 | 55 | 26 | |||
187305 | 42777 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47615 | 6004966.00219495 | 2108807.30598956 | 37.7706638565131 | -122.426180680587 | (37.7706638565131, -122.426180680587) | 7 | 9 | 5 | 28852 | 10 | ||
187105 | 41210 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3537 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 2 | Permit Number 41919 | 6002146.81597 | 2120360.98329 | 37.8022275558181 | -122.436759454895 | (37.8022275558181, -122.436759454895) | 13 | 9 | 1 | 57 | 17 | |
185992 | 207054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993334.80991 | 2106859.56975 | 37.7646516098981 | -122.466271235742 | (37.7646516098981, -122.466271235742) | 11 | 8 | 11 | 56 | 12 | |||
185546 | 136299 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001939.11813 | 2119948.35287 | 37.8010827755037 | -122.43744862338 | (37.8010827755037, -122.43744862338) | 13 | 9 | 1 | 57 | 17 | |||
185234 | 41728 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
184819 | 87877 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 32 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50849 | 6001971.5755 | 2119984.56576 | 37.8011840517703 | -122.43733890159 | (37.8011840517703, -122.43733890159) | 13 | 9 | 1 | 57 | 17 | |
184769 | 32858 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
184366 | 32517 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.7341870072318 | -122.41618038454 | (37.7341870072318, -122.41618038454) | 2 | 7 | 7 | 28859 | 2 | |
184309 | 30907 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2363 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37373 | 5987310.2980544 | 2099201.63941585 | 37.7432755629796 | -122.486545838163 | (37.7432755629796, -122.486545838163) | 1 | 8 | 3 | 29491 | 35 | |
184026 | 37648 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.7768688906692 | -122.469715476155 | (37.7768688906692, -122.469715476155) | 11 | 6 | 2 | 54 | 11 | ||
183989 | 51741 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 700 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48018 | 6007951.80914494 | 2095656.00646211 | 37.7347216770682 | -122.414921747465 | (37.7347216770682, -122.414921747465) | 2 | 7 | 7 | 28859 | 2 | |||
183798 | 42698 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1659 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45472 | 6009187.38661424 | 2118931.29098858 | 37.798699585947 | -122.412294470142 | (37.798699585947, -122.412294470142) | 3 | 1 | 10 | 308 | 21 | ||
182459 | 37978 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
182264 | 240397 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6001997.9354 | 2099211.95257 | 37.7441491230941 | -122.435760625573 | (37.7441491230941, -122.435760625573) | 2 | 7 | 5 | 63 | 22 | |||
181412 | 42274 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1522 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | 1 | 8 | 3 | 56 | 35 | |
181210 | 41725 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
181144 | 13408 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 364 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
180060 | 136318 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2431 Jones St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.8036473290331 | -122.416686400679 | (37.8036473290331, -122.416686400679) | 5 | 1 | 1 | 308 | 32 | |||
180058 | 98670 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
179944 | 112532 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011441.2715 | 2118651.07916 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | 3 | 1 | 10 | 308 | 23 | |||
179927 | 63484 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2139 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1989 12:00:00 AM | Permit Number 28328 | 5999347.56552659 | 2111497.12488065 | 37.7777302487495 | -122.44580833834 | (37.7777302487495, -122.44580833834) | 15 | 5 | 11 | 54 | 16 | ||
179229 | 179379 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 899 Mansell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009540.44789 | 2090000.72733 | 37.7192826139853 | -122.40903035607 | (37.7192826139853, -122.40903035607) | 9 | 3 | 8 | 309 | 18 | |||
179122 | 32857 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
178870 | 112526 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
178825 | 42676 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.416889660934 | (37.7984433372469, -122.416889660934) | 5 | 1 | 10 | 28858 | 21 | ||
178791 | 240391 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006743.91028 | 2097051.28536 | 37.7384848564878 | -122.419196816782 | (37.7384848564878, -122.419196816782) | 2 | 7 | 7 | 28859 | 2 | |||
178687 | 112543 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011394 | 2118786 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | 3 | 1 | 10 | 308 | 23 | ||||
178523 | 105432 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 341 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772598 | 6004076.5 | 2108982.1 | 37.7710934821162 | -122.429269947188 | (37.7710934821162, -122.429269947188) | 7 | 9 | 11 | 29492 | 10 | |
178499 | 197349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008993.79561 | 2110246.5783 | 37.7748425951336 | -122.412350180929 | (37.7748425951336, -122.412350180929) | 8 | 2 | 9 | 28853 | 34 | |||
178489 | 100234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983811.49615 | 2110876.46915 | 37.7751267903243 | -122.499506209788 | (37.7751267903243, -122.499506209788) | 11 | 6 | 2 | 55 | 26 | |||
178410 | 93722 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.7386518615207 | -122.467087971441 | (37.7386518615207, -122.467087971441) | 1 | 8 | 4 | 59 | 40 | ||
178307 | 37981 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
177888 | 42953 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2490X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2016 12:00:00 AM | 3 | Permit Number 778307 | 6000770.46048888 | 2116827.23264279 | 37.7924464923902 | -122.441268603286 | (37.7924464923902, -122.441268603286) | 13 | 6 | 1 | 29490 | 27 | ||
177757 | 69085 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33095 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 | ||
177533 | 214039 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6000414.26094 | 2095519.56512 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | 9 | 7 | 5 | 63 | 40 | |||
177388 | 136316 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009084.75499 | 2119036.14381 | 37.798981726274 | -122.412657026025 | (37.798981726274, -122.412657026025) | 3 | 1 | 10 | 308 | 21 | |||
177366 | 52145 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | |||
177127 | 240392 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008038.16649 | 2107910.13922 | 37.7683736115782 | -122.415490461517 | (37.7683736115782, -122.415490461517) | 8 | 4 | 7 | 28853 | 19 | |||
176877 | 181332 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1458 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988697.9248 | 2105396.3508 | 37.7603653792146 | -122.482201591019 | (37.7603653792146, -122.482201591019) | 1 | 8 | 3 | 56 | 35 | |||
176361 | 41876 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.7682507021815 | -122.430228105724 | (37.7682507021815, -122.430228105724) | 7 | 9 | 5 | 28862 | 3 | ||
176245 | 42161 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2010 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42456 | 5989367.84309334 | 2111281.28093807 | 37.7765627312838 | -122.480315427669 | (37.7765627312838, -122.480315427669) | 11 | 6 | 2 | 55 | 26 | ||
176192 | 197334 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6014199.99182 | 2102083.09836 | 37.7527182412529 | -122.393769197285 | (37.7527182412529, -122.393769197285) | 10 | 3 | 8 | 28856 | 29 | |||
176087 | 82850 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1457 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52367 | 6015981.5985 | 2094038.4652 | 37.730728169212 | -122.387046987845 | (37.730728169212, -122.387046987845) | 10 | 3 | 8 | 58 | 1 | |
175401 | 42682 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1646 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49825 | 5999927.74605546 | 2110588.07160314 | 37.7752673299483 | -122.443735976936 | (37.7752673299483, -122.443735976936) | 15 | 5 | 11 | 29492 | 16 | |
174273 | 197352 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1240 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017442.65456 | 2093993.31463 | 37.7306849905143 | -122.381992698304 | (37.7306849905143, -122.381992698304) | 10 | 3 | 8 | 58 | 1 | |||
174268 | 35870 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.7381679129171 | -122.405598135739 | (37.7381679129171, -122.405598135739) | 10 | 3 | 8 | 58 | 1 | |
174030 | 140856 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 619 Euclid Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5996442.8638 | 2113795.8805 | 37.7838757446976 | -122.456022870631 | (37.7838757446976, -122.456022870631) | 11 | 6 | 1 | 54 | 31 | |||
173586 | 136310 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008741.78085 | 2116636.60472 | 37.7923739278622 | -122.413674022565 | (37.7923739278622, -122.413674022565) | 5 | 1 | 10 | 28857 | 21 | |||
173068 | 41875 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.7682507021815 | -122.430228105724 | (37.7682507021815, -122.430228105724) | 7 | 9 | 5 | 28862 | 3 | ||
172606 | 38215 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 350 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | 10 | 3 | 7 | 309 | 28 | ||
171729 | 183281 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1267 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5981168.1745 | 2106457.5745 | 37.762838347579 | -122.508321804919 | (37.762838347579, -122.508321804919) | 1 | 8 | 3 | 56 | 35 | |||
171137 | 41768 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
171084 | 38639 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | ||
170178 | 214019 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 112 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994645.41712 | 2093146.00663 | 37.7270731423102 | -122.460744326189 | (37.7270731423102, -122.460744326189) | 9 | 8 | 4 | 28861 | 40 | |||
170055 | 25184 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3448X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 25 | 3X3 | 6000085.266119 | 2103906.7160848 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | 2 | 5 | 5 | 28862 | 3 | ||
169888 | 240403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.432572903928 | (37.7457049727185, -122.432572903928) | 2 | 7 | 5 | 63 | 22 | |||
169726 | 41765 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
169408 | 214045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 115 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999297.76132 | 2093768.33781 | 37.7290484986852 | -122.444706006572 | (37.7290484986852, -122.444706006572) | 9 | 7 | 4 | 28861 | 40 | |||
169312 | 50015 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373@ 24th ST Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2005 12:00:00 AM | Permit Number 46746 | 6010905.44286633 | 2101942.7131649 | 37.7521491430994 | -122.405152511945 | (37.7521491430994, -122.405152511945) | 10 | 4 | 8 | 28859 | 19 | ||
169003 | 51632 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2005 12:00:00 AM | 2.5x2.5 | Permit Number 47922 | 5999017.47730743 | 2106744.44536788 | 37.7646617464886 | -122.446608191655 | (37.7646617464886, -122.446608191655) | 15 | 5 | 11 | 29492 | 9 | ||
168828 | 240425 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 7 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002456.87513 | 2096374.31689 | 37.7363836921523 | -122.433970918943 | (37.7363836921523, -122.433970918943) | 2 | 7 | 5 | 63 | 7 | |||
168528 | 136308 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008610.17492 | 2116437.51898 | 37.7918198960214 | -122.414115292883 | (37.7918198960214, -122.414115292883) | 5 | 1 | 10 | 28857 | 21 | |||
168305 | 214032 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997805.13378 | 2093821.66004 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | 9 | 7 | 4 | 28861 | 40 | |||
167906 | 40701 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41680 | 6005025.18813412 | 2093548.59411277 | 37.7287703058889 | -122.424890201858 | (37.7287703058889, -122.424890201858) | 9 | 7 | 6 | 28861 | 5 | ||
167694 | 84809 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 648 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | 3 | Permit No. 49264 | 5987557.75332 | 2111531.90689 | 37.7771455293989 | -122.486595377302 | (37.7771455293989, -122.486595377302) | 11 | 6 | 2 | 55 | 26 | ||
167630 | 136323 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | Permit Number 775228 | 6011675.19116 | 2118742.88561 | 37.7983215564568 | -122.403672558643 | (37.7983215564568, -122.403672558643) | 3 | 1 | 10 | 308 | 23 | |
167181 | 47743 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.7810441521097 | -122.50448647782 | (37.7810441521097, -122.50448647782) | 11 | 6 | 2 | 55 | 26 | |
166802 | 240380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008113.4152 | 2107953.3802 | 37.7684965704858 | -122.415233243732 | (37.7684965704858, -122.415233243732) | 8 | 4 | 7 | 28853 | 19 | |||
166076 | 84942 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49348 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.464319342417 | (37.7637090714706, -122.464319342417) | 1 | 8 | 11 | 56 | 12 | |||
166067 | 89200 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51816 | 5999879.09694 | 2119719.87548 | 37.8003381062886 | -122.444560730091 | (37.8003381062886, -122.444560730091) | 13 | 9 | 1 | 57 | 17 | |
165949 | 48456 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.48397 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | 14 | 2 | 9 | 28853 | 34 | ||
165801 | 207053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993333.09346 | 2106842.13123 | 37.7646036292737 | -122.466275905005 | (37.7646036292737, -122.466275905005) | 11 | 8 | 11 | 56 | 12 | |||
164354 | 240409 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002196.79726 | 2096967.09193 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | 2 | 7 | 5 | 63 | 7 | |||
164027 | 35432 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.49848 | 2102013.02263 | 37.7525225775725 | -122.393966574215 | (37.7525225775725, -122.393966574215) | 10 | 3 | 8 | 28856 | 29 |
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) );