Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 96011 | 96011 | 53145 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1498@ KEITH Underwood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
| 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) | |
| 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) | |
| 42780 | 42780 | 200073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014933.989 | 2093151.8218 | 37.7282355589188 | -122.390606833955 | (37.7282355589188, -122.390606833955) | |||
| 175342 | 175342 | 200074 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014921.0644 | 2093162.4986 | 37.728264158228896 | -122.39065226097 | (37.7282641582289, -122.39065226097) | |||
| 179097 | 179097 | 30759 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1563 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | Permit Number 48354 | 6014932.9973 | 2093776.0212 | 37.7299494300904 | -122.39065386327499 | (37.7299494300904, -122.390653863275) | |
| 116485 | 116485 | 200075 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014900.2728 | 2093175.985 | 37.7283000356482 | -122.390725081061 | (37.7283000356482, -122.390725081061) | |||
| 36442 | 36442 | 200076 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014887.9102 | 2093187.7857 | 37.728331752097795 | -122.390768643797 | (37.7283317520978, -122.390768643797) | |||
| 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) | |||
| 16162 | 16162 | 51360 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014114.6767 | 2094431.72556 | 37.7317044268964 | -122.39352878961999 | (37.7317044268964, -122.39352878962) |
| 13409 | 13409 | 51359 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.73166388187129 | -122.393534297068 | (37.7316638818713, -122.393534297068) |
| 14652 | 14652 | 51358 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.7193099998 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) |
| 16408 | 16408 | 78332 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52305 | 6014106.86245 | 2094390.7581099998 | 37.73159150443121 | -122.393552939125 | (37.7315915044312, -122.393552939125) |
| 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) | ||
| 61905 | 61905 | 190927 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1050 Wisconsin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6012767.00645 | 2102579.68997 | 37.7540020378723 | -122.39875959738 | (37.7540020378723, -122.39875959738) | |||
| 122539 | 122539 | 190926 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1303 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6012003.88758 | 2102215.75937 | 37.7529602155494 | -122.40137308660401 | (37.7529602155494, -122.401373086604) | |||
| 88498 | 88498 | 35377 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | ||
| 107745 | 107745 | 49836 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 572 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2005 12:00:00 AM | Permit Number 46619 | 6011764.04798466 | 2105724.17808831 | 37.76258017347929 | -122.402449179614 | (37.7625801734793, -122.402449179614) | ||
| 186978 | 186978 | 190925 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 651 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011562.1933699995 | 2105343.91486 | 37.761524784975 | -122.40312057635 | (37.761524784975, -122.40312057635) | |||
| 128328 | 128328 | 67340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.75196069589111 | -122.403505842523 | (37.7519606958911, -122.403505842523) | ||
| 141700 | 141700 | 37459 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39931 | 6010620.6907028 | 2100238.51379536 | 37.7474538625831 | -122.40601718747 | (37.7474538625831, -122.40601718747) | ||
| 99952 | 99952 | 34302 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | ||
| 115026 | 115026 | 34301 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | ||
| 136007 | 136007 | 143086 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | |||
| 121588 | 121588 | 34344 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1325 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.40790749535499 | (37.7508459613928, -122.407907495355) | ||
| 78195 | 78195 | 47741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1384 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.40799907978399 | (37.7499146097647, -122.407999079784) | ||
| 40226 | 40226 | 223024 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 979 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009975.926030001 | 2103539.78877 | 37.756482348291996 | -122.40847958248399 | (37.756482348292, -122.408479582484) | |||
| 78925 | 78925 | 69199 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | ||
| 119254 | 119254 | 65260 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | ||
| 164832 | 164832 | 71420 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | ||
| 89728 | 89728 | 82956 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 96002 | 96002 | 82952 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 96209 | 96209 | 82955 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 100905 | 100905 | 82953 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 117382 | 117382 | 82954 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 107468 | 107468 | 84505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
| 107733 | 107733 | 84504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
| 77680 | 77680 | 63803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.41075136529899 | (37.7385764323817, -122.410751365299) | ||
| 97694 | 97694 | 63806 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.41083595729299 | (37.7396522194543, -122.410835957293) | ||
| 96993 | 96993 | 63825 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.738688578203295 | -122.41136891509899 | (37.7386885782033, -122.411368915099) | ||
| 60482 | 60482 | 247587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008949.04431 | 2096428.8077599998 | 37.7368996080238 | -122.41152853331499 | (37.7368996080238, -122.411528533315) | ||||
| 127030 | 127030 | 69506 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.41153197478901 | (37.7369238689745, -122.411531974789) | ||
| 63732 | 63732 | 247588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008943.011630001 | 2096440.0672900002 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | ||||
| 55439 | 55439 | 223036 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | |||
| 20561 | 20561 | 28791 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.41189526514799 | (37.7535963186214, -122.411895265148) | |||
| 18434 | 18434 | 28792 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008964.243480001 | 2102548.86607 | 37.753704789464294 | -122.411908330514 | (37.7537047894643, -122.411908330514) | |||
| 96973 | 96973 | 43489 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
| 111195 | 111195 | 43490 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
| 126743 | 126743 | 223043 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008381.78974 | 2096055.8705400003 | 37.735843768863795 | -122.413463422917 | (37.7358437688638, -122.413463422917) | |||
| 158851 | 158851 | 223045 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.745150110794896 | -122.413843827126 | (37.7451501107949, -122.413843827126) | |||
| 152052 | 152052 | 223044 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | |||
| 160368 | 160368 | 126382 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1001 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6008670.39988 | 2118624.74661 | 37.7978288673746 | -122.414061717575 | (37.7978288673746, -122.414061717575) | |||
| 130622 | 130622 | 223035 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | |||
| 18096 | 18096 | 24588 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | ||
| 148524 | 148524 | 126381 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1022 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008596.5256900005 | 2118672.84077 | 37.7979567725457 | -122.414320748412 | (37.7979567725457, -122.414320748412) | ||||
| 20665 | 20665 | 24587 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 804 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1996 12:00:00 AM | 18 | 3X3 | 6008146.87115 | 2097150.7739799998 | 37.738836941075 | -122.414353078142 | (37.738836941075, -122.414353078142) | ||
| 7079 | 7079 | 108929 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 12x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008556.45633 | 2119171.5746400002 | 37.79932392101129 | -122.41449470968399 | (37.7993239210113, -122.414494709684) | |||
| 102257 | 102257 | 62913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | ||
| 105369 | 105369 | 62916 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.737909606417496 | -122.415800456905 | (37.7379096064175, -122.415800456905) | ||
| 168058 | 168058 | 223039 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007708.387180001 | 2096815.6091900002 | 37.7378920108046 | -122.41584542843201 | (37.7378920108046, -122.415845428432) | |||
| 39350 | 39350 | 223040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007699.61186 | 2096703.5074099998 | 37.7375837106174 | -122.41586783322799 | (37.7375837106174, -122.415867833228) | |||
| 25265 | 25265 | 223034 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007664.494030001 | 2096661.03983 | 37.7374651296141 | -122.41598624606199 | (37.7374651296141, -122.415986246062) | |||
| 121238 | 121238 | 62920 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23300 | 6007655.13385737 | 2096670.74814693 | 37.7374912602593 | -122.41601929597999 | (37.7374912602593, -122.41601929598) | ||
| 19529 | 19529 | 24597 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.41685698498101 | (37.7391518611665, -122.416856984981) | ||
| 104121 | 104121 | 67138 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | ||
| 104124 | 104124 | 61289 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | ||
| 20916 | 20916 | 24556 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 416 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007294.81147 | 2097256.19199 | 37.739078494466 | -122.41730657855801 | (37.739078494466, -122.417306578558) | |||
| 121976 | 121976 | 62909 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 414 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23286 | 6007271.29358338 | 2097254.92250183 | 37.739073685552896 | -122.41738780295601 | (37.7390736855529, -122.417387802956) | ||
| 18010 | 18010 | 24554 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 412 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007266.67907 | 2097258.15357 | 37.7390822977194 | -122.41740398679899 | (37.7390822977194, -122.417403986799) | |||
| 74097 | 74097 | 223041 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007256.618290001 | 2097259.39898 | 37.7390851512711 | -122.41743886071899 | (37.7390851512711, -122.417438860719) | |||
| 79811 | 79811 | 62908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.41749722959699 | (37.7390843209207, -122.417497229597) | ||
| 16913 | 16913 | 24553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.41755671238501 | (37.7390994163072, -122.417556712385) | |||
| 114576 | 114576 | 61288 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 402 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23284 | 6007176.62571904 | 2097268.48245659 | 37.739105591348704 | -122.417716082945 | (37.7391055913487, -122.417716082945) | ||
| 78398 | 78398 | 62968 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1136 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | Permit Number 23354 | 6007556.73602589 | 2118875.23289672 | 37.7984540273893 | -122.41793308103901 | (37.7984540273893, -122.417933081039) | ||
| 70261 | 70261 | 126380 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1136 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.799775542566294 | -122.41812617837401 | (37.7997755425663, -122.418126178374) | |||
| 175387 | 175387 | 126379 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1136 Havens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | |||
| 76330 | 76330 | 126383 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1116 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | ||||
| 165172 | 165172 | 50986 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1120REVISED Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2004 12:00:00 AM | 6 | Permit Number 47576 | 6007503.31376 | 2119893.93908 | 37.801248132044 | -122.418190201138 | (37.801248132044, -122.418190201138) | ||
| 156749 | 156749 | 126384 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1120 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007500.24433 | 2119896.2377400002 | 37.8012542708165 | -122.418200985801 | (37.8012542708165, -122.418200985801) | ||||
| 91932 | 91932 | 62709 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.798251535762205 | -122.418390975112 | (37.7982515357622, -122.418390975112) | ||
| 69745 | 69745 | 223042 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.736354605390204 | -122.418528488295 | (37.7363546053902, -122.418528488295) | |||
| 103091 | 103091 | 62944 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.738570093545796 | -122.41866583942 | (37.7385700935458, -122.41866583942) | ||
| 103775 | 103775 | 62943 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | ||
| 127085 | 127085 | 58683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | ||
| 17038 | 17038 | 115537 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 78927 | 78927 | 115540 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 89451 | 89451 | 115539 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 120364 | 120364 | 115538 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 142150 | 142150 | 115536 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 120898 | 120898 | 62937 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 324 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23318 | 6006824.33458428 | 2097207.20889429 | 37.7389175168089 | -122.418929803603 | (37.7389175168089, -122.418929803603) | ||
| 77548 | 77548 | 51448 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | |||
| 119395 | 119395 | 51449 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 326 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | |||
| 114488 | 114488 | 62940 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 355 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23321 | 6006807.32064873 | 2097065.68374167 | 37.7385279621224 | -122.41897859484399 | (37.7385279621224, -122.418978594844) | ||
| 123110 | 123110 | 62941 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 357 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23322 | 6006800.83841041 | 2097053.62300346 | 37.738494480992706 | -122.419000152151 | (37.7384944809927, -122.419000152151) | ||
| 90333 | 90333 | 53193 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.745921466667205 | -122.419059278748 | (37.7459214666672, -122.419059278748) | ||
| 127990 | 127990 | 62939 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.41907604266899 | (37.7386903299864, -122.419076042669) | ||
| 52114 | 52114 | 223023 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006515.400219999 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | |||
| 80468 | 80468 | 51543 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | ||
| 174269 | 174269 | 223032 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.735871320489395 | -122.42081628443898 | (37.7358713204894, -122.420816284439) |
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");