Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75402 | 75402 | 206548 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993741.1056699995 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | |||
| 63202 | 63202 | 206604 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995043.01031 | 2100739.53906 | 37.747945979831 | -122.45991969824 | (37.747945979831, -122.45991969824) | |||
| 66581 | 66581 | 206606 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | |||
| 152678 | 152678 | 206603 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995045.25769 | 2100752.48094 | 37.7479816442318 | -122.459912864313 | (37.7479816442318, -122.459912864313) | |||
| 164769 | 164769 | 206602 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5995047.859019999 | 2100763.4476 | 37.7480119055303 | -122.45990466338101 | (37.7480119055303, -122.459904663381) | |||
| 168564 | 168564 | 206601 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5995052.26314 | 2100785.00395 | 37.7480713471357 | -122.45989099549601 | (37.7480713471357, -122.459890995496) | |||
| 170563 | 170563 | 206605 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995038.86988 | 2100730.57279 | 37.7479211225827 | -122.459933366148 | (37.7479211225827, -122.459933366148) | |||
| 70255 | 70255 | 206531 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.730879244086296 | -122.46533008801399 | (37.7308792440863, -122.465330088014) | |||
| 166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
| 99443 | 99443 | 60142 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | ||
| 111681 | 111681 | 81908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484453999 | (37.7580580577361, -122.47378484454) | ||
| 101018 | 101018 | 33392 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | ||
| 139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
| 163888 | 163888 | 38590 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.732560324707705 | -122.38990600380698 | (37.7325603247077, -122.389906003807) | |
| 67024 | 67024 | 206497 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993722.387569999 | 2104477.6450099996 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | |||
| 176558 | 176558 | 38592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1618 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40547 | 6015152.7308 | 2094735.8699 | 37.7325971695789 | -122.389961235194 | (37.7325971695789, -122.389961235194) | |
| 141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
| 54773 | 54773 | 206638 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994538.83302 | 2100858.6540099997 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | |||
| 73810 | 73810 | 223029 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997728.707169999 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | |||
| 19500 | 19500 | 68125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.744400650970604 | -122.42180635131201 | (37.7444006509706, -122.421806351312) | ||
| 75436 | 75436 | 206640 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994518.44354 | 2100835.0258299997 | 37.7481779797266 | -122.46174053670201 | (37.7481779797266, -122.461740536702) | |||
| 156496 | 156496 | 206639 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.39425 | 2100823.8744099997 | 37.748146897381794 | -122.461767562235 | (37.7481468973818, -122.461767562235) | |||
| 161600 | 161600 | 206530 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Garcia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994631.6545 | 2099433.40276 | 37.744335991408896 | -122.46124747260099 | (37.7443359914089, -122.461247472601) | |||
| 84074 | 84074 | 66157 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1765 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29228 | 6013882.21689766 | 2094959.68148484 | 37.733141166757896 | -122.39436940843201 | (37.7331411667579, -122.394369408432) | ||
| 72707 | 72707 | 190928 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1778 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.39288202418301 | (37.73426491189, -122.392882024183) | |||
| 97044 | 97044 | 68702 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | ||
| 137986 | 137986 | 223050 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001422.84544 | 2108013.2139 | 37.7682825750187 | -122.43837958446301 | (37.7682825750187, -122.438379584463) | |||
| 24597 | 24597 | 206648 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.46176019139799 | (37.748320765087, -122.461760191398) | |||
| 74465 | 74465 | 206646 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994489.718859999 | 2100854.37735 | 37.7482294605322 | -122.46184126797701 | (37.7482294605322, -122.461841267977) | |||
| 76418 | 76418 | 206650 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.14401 | 2100922.4103 | 37.748417898168995 | -122.461747907542 | (37.748417898169, -122.461747907542) | |||
| 134479 | 134479 | 206645 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994475.58114 | 2100840.87711 | 37.748191578392294 | -122.461889176638 | (37.7481915783923, -122.461889176638) | |||
| 161837 | 161837 | 206649 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.46873 | 2100904.0082799997 | 37.7483673895631 | -122.461745450587 | (37.7483673895631, -122.461745450587) | |||
| 170709 | 170709 | 206644 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994467.924 | 2100831.48615 | 37.748165352368105 | -122.46191497372 | (37.7481653523681, -122.46191497372) | |||
| 171384 | 171384 | 206647 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | |||
| 44246 | 44246 | 206584 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993659.8453 | 2099783.1011200002 | 37.745240198571295 | -122.464633144905 | (37.7452401985713, -122.464633144905) | |||
| 148911 | 148911 | 206583 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | |||
| 175013 | 175013 | 206619 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994070.38957 | 2104649.5630900003 | 37.758625920162295 | -122.463566678468 | (37.7586259201623, -122.463566678468) | |||
| 106193 | 106193 | 47123 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.753887161855104 | -122.47200398758899 | (37.7538871618551, -122.472003987589) | ||
| 106851 | 106851 | 94159 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954005 | -122.464686168912 | (37.754134227954, -122.464686168912) | ||
| 173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
| 137767 | 137767 | 206593 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995062.081040001 | 2100706.4698799998 | 37.74785627694121 | -122.45985135785101 | (37.7478562769412, -122.459851357851) | |||
| 72290 | 72290 | 82688 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | |
| 40135 | 40135 | 206582 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765798996 | -122.464803087101 | (37.745215765799, -122.464803087101) | |||
| 41542 | 41542 | 206581 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.745210335700605 | -122.46487003355301 | (37.7452103357006, -122.464870033553) | |||
| 161050 | 161050 | 199671 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1905 Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015210.0019 | 2093419.3228 | 37.728985371993396 | -122.389671313679 | (37.7289853719934, -122.389671313679) | |||
| 129639 | 129639 | 223056 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004346.640459999 | 2097517.13802 | 37.739628683514496 | -122.427518598925 | (37.7396286835145, -122.427518598925) | |||
| 49647 | 49647 | 206622 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.752445798858396 | -122.466499759777 | (37.7524457988584, -122.466499759777) | |||
| 132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
| 116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
| 140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
| 143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
| 167733 | 167733 | 206503 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.751788644440495 | -122.46662048837 | (37.7517886444405, -122.46662048837) | |||
| 26518 | 26518 | 206504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.46661639913602 | (37.7517116786758, -122.466616399136) | |||
| 58009 | 58009 | 206641 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.748079875384796 | -122.462020618849 | (37.7480798753848, -122.462020618849) | |||
| 162090 | 162090 | 206642 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.46211643714899 | (37.7480147959636, -122.462116437149) | |||
| 172567 | 172567 | 206643 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994392.211730001 | 2100761.6142700003 | 37.74796914278121 | -122.462171715751 | (37.7479691427812, -122.462171715751) | |||
| 39199 | 39199 | 206623 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | |||
| 28309 | 28309 | 206505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993138.76599 | 2102124.2403700002 | 37.7516383146611 | -122.46660507218701 | (37.7516383146611, -122.466605072187) | |||
| 83006 | 83006 | 68501 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.751535602028206 | -122.46642090906602 | (37.7515356020282, -122.466420909066) | ||
| 131438 | 131438 | 126378 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | |||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
| 106375 | 106375 | 63593 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 24225 | 6005185.44614551 | 2109584.80310454 | 37.7728110766439 | -122.425476960922 | (37.7728110766439, -122.425476960922) | ||
| 539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | ||
| 553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
| 9865 | 9865 | 122387 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779324 | 5994732.0 | 2099337.0 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | |||
| 33381 | 33381 | 206506 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.46657681008301 | (37.7512177970674, -122.466576810083) | |||
| 137122 | 137122 | 206507 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.46657295558599 | (37.751190371338, -122.466572955586) | |||
| 49506 | 49506 | 206607 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2 Sola Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994975.69537 | 2100714.97086 | 37.7478746501056 | -122.460150689128 | (37.7478746501056, -122.460150689128) | |||
| 187736 | 187736 | 206608 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994960.813709999 | 2100721.5804 | 37.7478919422595 | -122.460202627649 | (37.7478919422595, -122.460202627649) | |||
| 43524 | 43524 | 206628 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | |||
| 77448 | 77448 | 45122 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 93753 | 93753 | 45119 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 107169 | 107169 | 45118 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 111028 | 111028 | 45121 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 124557 | 124557 | 45120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 143621 | 143621 | 45117 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 104764 | 104764 | 50527 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/2003 12:00:00 AM | Permit Number 47168 | 6001454.91140265 | 2108251.59060829 | 37.7689389222278 | -122.438285751105 | (37.7689389222278, -122.438285751105) | ||
| 121572 | 121572 | 42999 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 81114 | 81114 | 41708 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.43519418820401 | (37.7355450223799, -122.435194188204) | ||
| 121951 | 121951 | 41707 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.43519418820401 | (37.7355450223799, -122.435194188204) | ||
| 158004 | 158004 | 223037 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002071.560219999 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | |||
| 189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
| 64939 | 64939 | 206563 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | |||
| 89831 | 89831 | 43002 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 47365 | 47365 | 141302 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 208 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998449.1975 | 2112684.3341 | 37.780938681749895 | -122.449001631605 | (37.7809386817499, -122.449001631605) | |||
| 180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
| 72855 | 72855 | 206620 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993657.1596800005 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | |||
| 118978 | 118978 | 60133 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2012 12:00:00 AM | Permit Number 768747 | 6003532.52706643 | 2096003.65082334 | 37.7354269125656 | -122.43022550454201 | (37.7354269125656, -122.430225504542) | ||
| 97268 | 97268 | 45125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 215 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43982 | 6001423.51922816 | 2108204.04749997 | 37.7688065951097 | -122.438390927701 | (37.7688065951097, -122.438390927701) | ||
| 72889 | 72889 | 206577 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993636.2641900005 | 2099712.16168 | 37.745044057332294 | -122.464709533316 | (37.7450440573323, -122.464709533316) | |||
| 146174 | 146174 | 40167 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 216 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41360 | 5994849.72626239 | 2095987.73496493 | 37.7348875889443 | -122.46024383672199 | (37.7348875889443, -122.460243836722) | ||
| 137011 | 137011 | 137657 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.778804413574704 | -122.444756988886 | (37.7788044135747, -122.444756988886) | |||
| 170640 | 170640 | 137632 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.44489608677401 | (37.7787937523144, -122.444896086774) | |||
| 126800 | 126800 | 65799 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.746750736934295 | -122.473717291816 | (37.7467507369343, -122.473717291816) | ||
| 153437 | 153437 | 206522 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.47370838535801 | (37.7465686447317, -122.473708385358) | |||
| 113954 | 113954 | 65803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | ||
| 20614 | 20614 | 65804 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.47384127538099 | (37.7459566686168, -122.473841275381) | ||
| 39830 | 39830 | 70315 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 226 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 5 | 5997860.8667 | 2109778.6627 | 37.7729267975155 | -122.450827376517 | (37.7729267975155, -122.450827376517) | ||
| 177940 | 177940 | 206677 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.46005157662901 | (37.7347770452256, -122.460051576629) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");