trees
713 rows where qSpecies_id = 102 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194473 | 258633 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 625 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2021 12:00:00 AM | 3 | 4x6 | 5997754 | 2090591 | 37.7202360579042 | -122.449813998345 | (37.7202360579042, -122.449813998345) | 9 | 8 | 6 | 28861 | 24 | ||
| 193674 | 206727 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993862.54978 | 2104584.34087 | 37.7584348592109 | -122.46428074199 | (37.7584348592109, -122.46428074199) | 1 | 8 | 4 | 56 | 12 | |||
| 193388 | 206704 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5990936.99476 | 2102144.66077 | 37.7515670784743 | -122.474220493479 | (37.7515670784743, -122.474220493479) | 1 | 8 | 4 | 29491 | 12 | |||
| 193348 | 113316 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2495x 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984244.2356 | 2098243.5123 | 37.7404655994923 | -122.497076614535 | (37.7404655994923, -122.497076614535) | 1 | 8 | 3 | 29491 | 35 | |||
| 193246 | 36521 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 142 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39395 | 6007287.70960108 | 2096970.92417792 | 37.7382948125666 | -122.417310923551 | (37.7382948125666, -122.417310923551) | 2 | 7 | 7 | 28859 | 2 | ||
| 192944 | 223123 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 326 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006809.31468 | 2097169.81011 | 37.7388139822879 | -122.418979083733 | (37.7388139822879, -122.418979083733) | 2 | 7 | 7 | 28859 | 2 | |||
| 192599 | 37911 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40172 | 5995790.86348938 | 2094355.79804067 | 37.7304607763423 | -122.456872021896 | (37.7304607763423, -122.456872021896) | 9 | 7 | 4 | 28861 | 40 | ||
| 192510 | 42097 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 195 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42403 | 6006654.48640475 | 2098495.27969695 | 37.7424447060462 | -122.419608424988 | (37.7424447060462, -122.419608424988) | 2 | 7 | 7 | 28859 | 2 | ||
| 192481 | 223233 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 593 Sanchez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003682.6043 | 2104832.57907 | 37.7596775927725 | -122.430336343952 | (37.7596775927725, -122.430336343952) | 2 | 4 | 5 | 28862 | 3 | |||
| 192163 | 223114 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009175.97969 | 2097071.0103 | 37.738675683631 | -122.410789255518 | (37.738675683631, -122.410789255518) | 10 | 7 | 7 | 28859 | 2 | |||
| 192024 | 206769 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 485 Warren Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994381.7364 | 2104518.5556 | 37.7582841418063 | -122.462480405347 | (37.7582841418063, -122.462480405347) | 1 | 5 | 4 | 63 | 12 | |||
| 191877 | 223132 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007708.08815 | 2104990.70699 | 37.7603389712889 | -122.416425358938 | (37.7603389712889, -122.416425358938) | 2 | 4 | 7 | 28859 | 19 | |||
| 191562 | 37907 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40171 | 5995826.42405766 | 2094314.00617458 | 37.7303480678725 | -122.456746063345 | (37.7303480678725, -122.456746063345) | 9 | 7 | 4 | 28861 | 40 | ||
| 191082 | 84028 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 53 Waterville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50148 | 6011483.75557 | 2095836.15931 | 37.7354141717124 | -122.402723197432 | (37.7354141717124, -122.402723197432) | 10 | 3 | 8 | 58 | 1 | |
| 190802 | 223070 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 248 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006485.14188 | 2104634.02884 | 37.7592907673685 | -122.420629647267 | (37.7592907673685, -122.420629647267) | 2 | 4 | 7 | 28859 | 19 | |||
| 190643 | 34345 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39472 | 6010117.3573919 | 2101160.06487497 | 37.7499560747185 | -122.407822661385 | (37.7499560747185, -122.407822661385) | 2 | 4 | 7 | 28859 | 19 | ||
| 190438 | 36520 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 142 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39395 | 6007287.70960108 | 2096970.92417792 | 37.7382948125666 | -122.417310923551 | (37.7382948125666, -122.417310923551) | 2 | 7 | 7 | 28859 | 2 | ||
| 190376 | 45191 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 362 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44034 | 6010581.515091 | 2099593.27903158 | 37.7456799974256 | -122.406107204455 | (37.7456799974256, -122.406107204455) | 2 | 7 | 7 | 28859 | 2 | ||
| 189418 | 50207 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 742@ BALBOA 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 4 | Permit Number 46915 | 5987580.84632 | 2110887.41206 | 37.775377273985 | -122.486468161484 | (37.775377273985, -122.486468161484) | 11 | 6 | 2 | 55 | 26 | |
| 188607 | 190943 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6013990.64503 | 2095115.60513 | 37.7335753279298 | -122.3940054519 | (37.7335753279298, -122.3940054519) | 10 | 3 | 8 | 58 | 1 | |||
| 188350 | 46094 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | Permit Number 44466 | 5995953.68098218 | 2095998.76752974 | 37.734981320791 | -122.456427900432 | (37.734981320791, -122.456427900432) | 9 | 7 | 4 | 59 | 40 | |||
| 188322 | 223251 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001365.4819 | 2108117.26701 | 37.7685650160862 | -122.438585455453 | (37.7685650160862, -122.438585455453) | 15 | 5 | 5 | 29492 | 3 | |||
| 188112 | 37906 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40171 | 5995826.42405766 | 2094314.00617458 | 37.7303480678725 | -122.456746063345 | (37.7303480678725, -122.456746063345) | 9 | 7 | 4 | 28861 | 40 | ||
| 187822 | 39723 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 295 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41100 | 5996021.32504537 | 2095122.64012846 | 37.7325795705533 | -122.456130709172 | (37.7325795705533, -122.456130709172) | 9 | 7 | 4 | 59 | 40 | ||
| 187376 | 37004 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 951 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39618 | 6009174.49889712 | 2103626.77231017 | 37.7566762710675 | -122.411257356485 | (37.7566762710675, -122.411257356485) | 2 | 4 | 7 | 28859 | 19 | ||
| 186629 | 206709 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991483.07743 | 2106081.42222 | 37.7624080091318 | -122.472619086012 | (37.7624080091318, -122.472619086012) | 1 | 8 | 11 | 56 | 12 | |||
| 186434 | 223215 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1199 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003236.12918 | 2101299.7559 | 37.7499519986058 | -122.43162825334 | (37.7499519986058, -122.43162825334) | 2 | 4 | 5 | 28862 | 22 | |||
| 186431 | 250925 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 275 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5987109.38515 | 2114117.08948 | 37.7842175580435 | -122.488336434905 | (37.7842175580435, -122.488336434905) | 11 | 6 | 1 | 55 | 33 | |||
| 186381 | 176077 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012696.95044 | 2087397.86987 | 37.7123120047722 | -122.397936950623 | (37.7123120047722, -122.397936950623) | 10 | 3 | 8 | 309 | 1 | |||
| 186278 | 34276 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 190 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52264 | 5987177.45046872 | 2114685.66544071 | 37.7857826757644 | -122.488142750795 | (37.7857826757644, -122.488142750795) | 11 | 6 | 1 | 55 | 33 | ||
| 185783 | 206726 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993852.03575 | 2104584.23438 | 37.7584339607877 | -122.464317096167 | (37.7584339607877, -122.464317096167) | 1 | 8 | 4 | 56 | 12 | |||
| 185554 | 84159 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2800 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52651 | 6009557.23570783 | 2105031.47254004 | 37.760554718378 | -122.410032871336 | (37.760554718378, -122.410032871336) | 2 | 4 | 7 | 28859 | 19 | ||
| 185365 | 223244 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 75 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001180.54313 | 2107571.99313 | 37.7670573071644 | -122.4391860551 | (37.7670573071644, -122.4391860551) | 15 | 5 | 5 | 29492 | 3 | |||
| 185349 | 223154 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001140.65053 | 2096640.61159 | 37.7370400911356 | -122.4385407232 | (37.7370400911356, -122.4385407232) | 2 | 7 | 5 | 63 | 7 | |||
| 185247 | 108782 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005606.4158 | 2088034.4515 | 37.713662477117 | -122.422489201534 | (37.713662477117, -122.422489201534) | 9 | 7 | 8 | 309 | 18 |
| 185180 | 42184 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
| 185118 | 223087 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010059.28582 | 2102034.7941 | 37.752354636379 | -122.408085158703 | (37.752354636379, -122.408085158703) | 2 | 4 | 7 | 28859 | 19 | |||
| 184961 | 223111 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008998.77105 | 2097114.80848 | 37.7387860061722 | -122.411405054623 | (37.7387860061722, -122.411405054623) | 10 | 7 | 7 | 28859 | 2 | |||
| 184302 | 223206 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 524 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001631.91242 | 2101482.38003 | 37.7503623808223 | -122.437188779556 | (37.7503623808223, -122.437188779556) | 2 | 4 | 5 | 28862 | 22 | |||
| 184154 | 37910 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40172 | 5995790.86348938 | 2094355.79804067 | 37.7304607763423 | -122.456872021896 | (37.7304607763423, -122.456872021896) | 9 | 7 | 4 | 28861 | 40 | ||
| 183727 | 32762 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 118 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 4 | Permit Number 37137 | 5995714.52093 | 2089647.57349 | 37.7175287309449 | -122.456795559591 | (37.7175287309449, -122.456795559591) | 9 | 8 | 6 | 28861 | 24 | |
| 183674 | 223224 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 990 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003752.62115 | 2102518.7549 | 37.7533283458304 | -122.429929140825 | (37.7533283458304, -122.429929140825) | 2 | 4 | 5 | 28862 | 22 | |||
| 183150 | 223060 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3709 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005681.16882 | 2101371.75408 | 37.7502879745135 | -122.423178289942 | (37.7502879745135, -122.423178289942) | 2 | 4 | 5 | 28859 | 19 | |||
| 182900 | 223099 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 474 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003529.69673 | 2098956.83781 | 37.7435355264533 | -122.430445934453 | (37.7435355264533, -122.430445934453) | 2 | 7 | 5 | 63 | 22 | |||
| 182808 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 182323 | 38912 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 215 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40724 | 5994141.27914879 | 2091345.82525201 | 37.7221012612205 | -122.462356600514 | (37.7221012612205, -122.462356600514) | 9 | 8 | 4 | 28861 | 40 | ||
| 182091 | 32300 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2367 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 1 | Permit Number 36876 | 5986385.4755 | 2099136.6325 | 37.7430431173924 | -122.489738810464 | (37.7430431173924, -122.489738810464) | 1 | 8 | 3 | 29491 | 35 | ||
| 182078 | 161275 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 574 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 12:26:00 PM | 3 | Width 0ft | 6002859.41772 | 2090297.55139 | 37.7197211000357 | -122.432145332055 | (37.7197211000357, -122.432145332055) | 9 | 7 | 6 | 28861 | 5 | |
| 181713 | 124088 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 601 Funston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5991897.07787 | 2111001.16091 | 37.7759402465292 | -122.471545739628 | (37.7759402465292, -122.471545739628) | 11 | 6 | 2 | 54 | 11 | ||||
| 181593 | 206779 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000353.87806 | 2095252.78651 | 37.7331846615462 | -122.441161399793 | (37.7331846615462, -122.441161399793) | 9 | 7 | 5 | 63 | 40 | |||
| 181522 | 223243 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 166 Alpine Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001694.08733 | 2107829.29676 | 37.7677930083548 | -122.43742821504 | (37.7677930083548, -122.43742821504) | 15 | 5 | 5 | 29492 | 3 | |||
| 181443 | 39312 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 257 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40890 | 6007011.30280747 | 2107889.38110273 | 37.7682588432998 | -122.419040823391 | (37.7682588432998, -122.419040823391) | 8 | 4 | 7 | 28853 | 19 | ||
| 180938 | 223175 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 357 Ellert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006863.93178 | 2097038.68266 | 37.7384570107857 | -122.418780945994 | (37.7384570107857, -122.418780945994) | 2 | 7 | 7 | 28859 | 2 | |||
| 180468 | 44790 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 585 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43885 | 6009841.4903569 | 2105563.40623193 | 37.7620312154749 | -122.409087294566 | (37.7620312154749, -122.409087294566) | 8 | 4 | 8 | 28859 | 19 | ||
| 180455 | 190931 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | 10 | 3 | 8 | 28856 | 1 | |||
| 180229 | 223204 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 43 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004849.29936 | 2096220.49442 | 37.7360968111203 | -122.425688355348 | (37.7360968111203, -122.425688355348) | 2 | 7 | 5 | 28859 | 2 | |||
| 180147 | 40615 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42266 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
| 179869 | 223235 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000463.2173 | 2104877.87281 | 37.7596190747751 | -122.441473822477 | (37.7596190747751, -122.441473822477) | 2 | 4 | 5 | 28862 | 3 | |||
| 179544 | 34526 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3704 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39403 | 6008431.51779874 | 2097641.44980503 | 37.7402002152374 | -122.413403591094 | (37.7402002152374, -122.413403591094) | 2 | 7 | 7 | 28859 | 2 | ||
| 179283 | 223240 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 64 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001986.3293 | 2105505.11191 | 37.7614279756348 | -122.436251036652 | (37.7614279756348, -122.436251036652) | 15 | 4 | 5 | 28862 | 3 | |||
| 179147 | 145306 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5992847.35421 | 2111936.76759 | 37.7785640995019 | -122.468326596707 | (37.7785640995019, -122.468326596707) | 11 | 6 | 2 | 54 | 11 | |||
| 178970 | 206760 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995833.25703 | 2094287.38686 | 37.7302753699947 | -122.456720516556 | (37.7302753699947, -122.456720516556) | 9 | 7 | 4 | 28861 | 40 | |||
| 178790 | 223138 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001885.01261 | 2100911.26228 | 37.7488086113449 | -122.436272675242 | (37.7488086113449, -122.436272675242) | 2 | 4 | 5 | 28862 | 22 | |||
| 178240 | 223109 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3704 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008435.71974 | 2097585.01225 | 37.7400454860195 | -122.413385072176 | (37.7400454860195, -122.413385072176) | 2 | 7 | 7 | 28859 | 2 | |||
| 177620 | 223119 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 136 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007270.88561 | 2096752.20058 | 37.7376932993062 | -122.417353596897 | (37.7376932993062, -122.417353596897) | 2 | 7 | 7 | 28859 | 2 | |||
| 176902 | 51363 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014143.51923 | 2094573.18836 | 37.7320944574823 | -122.393438970749 | (37.7320944574823, -122.393438970749) | 10 | 3 | 8 | 58 | 1 |
| 176727 | 95098 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54031 | 5993663.8 | 2099799.9 | 37.7452865520346 | -122.464620689927 | (37.7452865520346, -122.464620689927) | 1 | 8 | 4 | 29491 | 40 | |||
| 176632 | 44793 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 585 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43885 | 6009841.4903569 | 2105563.40623193 | 37.7620312154749 | -122.409087294566 | (37.7620312154749, -122.409087294566) | 8 | 4 | 8 | 28859 | 19 | ||
| 176588 | 223118 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 18 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008319.16941 | 2099444.00252 | 37.7451433182199 | -122.413919527559 | (37.7451433182199, -122.413919527559) | 2 | 7 | 7 | 28859 | 2 | |||
| 176535 | 223097 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004260.2997 | 2109306.43724 | 37.7719944368218 | -122.428657301609 | (37.7719944368218, -122.428657301609) | 7 | 9 | 11 | 28852 | 10 | |||
| 176482 | 206749 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995818.46528 | 2090537.82945 | 37.7199791317192 | -122.456500615214 | (37.7199791317192, -122.456500615214) | 9 | 8 | 6 | 28861 | 24 | |||
| 176182 | 51654 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1419 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47937 | 6009793.07047416 | 2094495.54898311 | 37.7316385998268 | -122.408474019407 | (37.7316385998268, -122.408474019407) | 10 | 3 | 7 | 309 | 28 | |||
| 175964 | 223232 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3948 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003356.76386 | 2104795.67253 | 37.7595577940892 | -122.431460628711 | (37.7595577940892, -122.431460628711) | 2 | 4 | 5 | 28862 | 3 | |||
| 175149 | 65684 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50575 | 5994950.68058867 | 2095866.227564 | 37.7345597659214 | -122.459886005804 | (37.7345597659214, -122.459886005804) | 9 | 7 | 4 | 59 | 40 | ||
| 174878 | 206746 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998707.58431 | 2093469.07503 | 37.7281930968274 | -122.446724762433 | (37.7281930968274, -122.446724762433) | 9 | 7 | 4 | 28861 | 40 | |||
| 174257 | 223131 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007729.44509 | 2104993.80364 | 37.7603486749694 | -122.416351714377 | (37.7603486749694, -122.416351714377) | 2 | 4 | 7 | 28859 | 19 | |||
| 172857 | 223117 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 18 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008338.94633 | 2099446.08887 | 37.7451501575667 | -122.413851289731 | (37.7451501575667, -122.413851289731) | 2 | 7 | 7 | 28859 | 2 | |||
| 172833 | 46179 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 264 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44506 | 5996989.54812887 | 2106711.44465885 | 37.7644550890537 | -122.453619839598 | (37.7644550890537, -122.453619839598) | 15 | 5 | 11 | 29492 | 12 | ||
| 172267 | 244962 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 202 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005157.1549 | 2109800.5724 | 37.7734019283256 | -122.425590183018 | (37.7734019283256, -122.425590183018) | 7 | 9 | 11 | 28852 | 10 | |||
| 172233 | 223161 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 735 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008476.63929 | 2095368.54545 | 37.7339618484531 | -122.413086904648 | (37.7339618484531, -122.413086904648) | 10 | 7 | 7 | 28859 | 2 | |||
| 171203 | 223066 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005880.16114 | 2105704.08186 | 37.7621947673055 | -122.422798013443 | (37.7621947673055, -122.422798013443) | 8 | 4 | 5 | 28859 | 19 | |||
| 171134 | 114965 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 778 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776138 | 5994932 | 2093225 | 37.7273065236963 | -122.45975933934 | (37.7273065236963, -122.45975933934) | 9 | 7 | 4 | 28861 | 40 | |||
| 171033 | 223222 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 990 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003749.53865 | 2102554.42106 | 37.7534261021378 | -122.429942344685 | (37.7534261021378, -122.429942344685) | 2 | 4 | 5 | 28862 | 22 | |||
| 170928 | 250890 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 236 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986835.39418 | 2114381.01597 | 37.7849262346079 | -122.489303745667 | (37.7849262346079, -122.489303745667) | 11 | 6 | 1 | 55 | 33 | |||
| 170665 | 190942 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6013977.60623 | 2095098.09187 | 37.7335265154282 | -122.39404930553 | (37.7335265154282, -122.39404930553) | 10 | 3 | 8 | 58 | 1 | |||
| 170589 | 48015 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45737 | 5991376.23311352 | 2098294.58385123 | 37.741021197596 | -122.472420918053 | (37.741021197596, -122.472420918053) | 1 | 8 | 4 | 29491 | 40 | ||
| 170417 | 223177 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 357 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006824.21108 | 2097044.20346 | 37.7384699331325 | -122.418918672677 | (37.7384699331325, -122.418918672677) | 2 | 7 | 7 | 28859 | 2 | |||
| 170378 | 223108 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3704 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008436.99326 | 2097599.41483 | 37.7400851038481 | -122.41338168714 | (37.7400851038481, -122.41338168714) | 2 | 7 | 7 | 28859 | 2 | |||
| 170169 | 83707 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 273-275 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50599 | 6006532.03998102 | 2104526.406535 | 37.758997904553 | -122.420459811381 | (37.758997904553, -122.420459811381) | 2 | 4 | 7 | 28859 | 19 | ||
| 169834 | 223170 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 44 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006977.38993 | 2099699.22842 | 37.7457686626942 | -122.418577273841 | (37.7457686626942, -122.418577273841) | 2 | 7 | 7 | 28859 | 2 | |||
| 169803 | 37900 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 169598 | 223223 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 990 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003751.19271 | 2102533.64738 | 37.7533691561781 | -122.429935142888 | (37.7533691561781, -122.429935142888) | 2 | 4 | 5 | 28862 | 22 | |||
| 169045 | 250635 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 194 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987172.85547 | 2114685.13825 | 37.7857809601798 | -122.488158609233 | (37.7857809601798, -122.488158609233) | 11 | 6 | 1 | 55 | 33 | |||
| 168791 | 37411 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 920 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39890 | 6001892.73765623 | 2101410.4821696 | 37.7501797894928 | -122.436281684424 | (37.7501797894928, -122.436281684424) | 2 | 4 | 5 | 28862 | 22 | ||
| 167107 | 46577 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 996 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | 4 | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | 2 | 4 | 5 | 28862 | 22 | |
| 166895 | 223172 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 98 Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006177.34043 | 2097589.74003 | 37.7399314088036 | -122.421193969128 | (37.7399314088036, -122.421193969128) | 2 | 7 | 7 | 28859 | 2 | |||
| 166719 | 190933 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | 10 | 3 | 8 | 28856 | 1 | |||
| 166140 | 223190 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010325.13431 | 2099720.24071 | 37.7460142630486 | -122.407002682534 | (37.7460142630486, -122.407002682534) | 2 | 7 | 7 | 28859 | 2 | |||
| 166053 | 176079 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1183 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001144.67239 | 2087111.03395 | 37.7108742640178 | -122.437844474361 | (37.7108742640178, -122.437844474361) | 9 | 7 | 6 | 28861 | 5 | |||
| 165939 | 103440 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 |
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) );