Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940 | 2940 | 250421 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987880.27353 | 2115792.69032 | 37.788863226412296 | -122.485792492053 | (37.7888632264123, -122.485792492053) | |||
| 2944 | 2944 | 232231 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003645.44992 | 2108813.0512099997 | 37.7706049033258 | -122.430748898054 | (37.7706049033258, -122.430748898054) | |
| 2955 | 2955 | 232230 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003632.85461 | 2108809.4147799998 | 37.7705942049744 | -122.430792205812 | (37.7705942049744, -122.430792205812) | |
| 2967 | 2967 | 90257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3230 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985539.08481 | 2111145.48476 | 37.775966641531504 | -122.49355000935199 | (37.7759666415315, -122.493550009352) | ||
| 2983 | 2983 | 250419 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 8 | Width 4ft | Permit Number 38081 | 5987849.1846199995 | 2115791.00757 | 37.7888567944531 | -122.48589993045601 | (37.7888567944531, -122.485899930456) | |
| 2985 | 2985 | 250408 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5988046.91633 | 2115796.65095 | 37.7888838100916 | -122.485216228949 | (37.7888838100916, -122.485216228949) | |||
| 2987 | 2987 | 250422 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987891.12003 | 2115793.8659200002 | 37.7888670862959 | -122.48575505145399 | (37.7888670862959, -122.485755051454) | |||
| 3001 | 3001 | 7734 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.6082200003 | 37.777446266458 | -122.42133372647699 | (37.777446266458, -122.421333726477) | |||
| 3017 | 3017 | 250423 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987905.22883 | 2115793.56651 | 37.7888670863011 | -122.485706215587 | (37.7888670863011, -122.485706215587) | |||
| 3089 | 3089 | 2184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1030 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6000920.2689 | 2112277.9741 | 37.779963933965995 | -122.440423847121 | (37.779963933966, -122.440423847121) | |||
| 3157 | 3157 | 6076 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1950 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001110.3773 | 2112486.1881 | 37.780546459454996 | -122.439781110889 | (37.780546459455, -122.439781110889) | |||
| 3167 | 3167 | 210018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 129 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25335 | 5995846.58682 | 2096221.4645200002 | 37.7355866437016 | -122.45681426186701 | (37.7355866437016, -122.456814261867) | |
| 3173 | 3173 | 6353 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1985 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1992 12:00:00 AM | 6 | 3X3 | 6001392.1135 | 2112821.0565 | 37.7814819554931 | -122.43883045753701 | (37.7814819554931, -122.438830457537) | ||
| 3175 | 3175 | 10515 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | ||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
| 3314 | 3314 | 8704 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997630.7244 | 2113099.07 | 37.7820305944204 | -122.45186304771099 | (37.7820305944204, -122.451863047711) | |||
| 3381 | 3381 | 8153 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1052 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002732.6953 | 2111326.1234 | 37.777453421805895 | -122.434085798199 | (37.7774534218059, -122.434085798199) | |||
| 3426 | 3426 | 8640 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5999291.3601 | 2113278.772 | 37.782618982387596 | -122.446130957827 | (37.7826189823876, -122.446130957827) | |||
| 3470 | 3470 | 8669 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998067.7961 | 2113159.1399 | 37.7822205542064 | -122.450355317805 | (37.7822205542064, -122.450355317805) | |||
| 3476 | 3476 | 8169 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1178 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6002155.3413 | 2111245.817 | 37.7772001368339 | -122.436077305312 | (37.7772001368339, -122.436077305312) | |||
| 3477 | 3477 | 22794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1015X Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6000886.4267 | 2112199.4602 | 37.7797464277805 | -122.440535289267 | (37.7797464277805, -122.440535289267) | |||
| 3487 | 3487 | 18489 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6010385.55842 | 2113872.45132 | 37.784876392368396 | -122.40779148690201 | (37.7848763923684, -122.407791486902) | |||
| 3529 | 3529 | 6070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:12:00 AM | 3 | 3X3 | 6001158.0948 | 2112492.6181 | 37.78056683058671 | -122.43961649489799 | (37.7805668305867, -122.439616494898) | ||
| 3635 | 3635 | 210326 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 6 | Width 2ft | Permit Number 31364 | 5994586.35542 | 2105191.7373900004 | 37.760144306721 | -122.46182156022499 | (37.760144306721, -122.461821560225) | |
| 3648 | 3648 | 210351 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 15 | Width 4ft | Permit Number 35554 | 5992053.09945 | 2099023.47402 | 37.743061697037895 | -122.470133645862 | (37.7430616970379, -122.470133645862) | |
| 3659 | 3659 | 209947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 13 | Width 3ft | Permit Number 35554 | 5992051.55672 | 2099045.56782 | 37.7431222717841 | -122.47014058862301 | (37.7431222717841, -122.470140588623) | |
| 3677 | 3677 | 210350 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992051.8911 | 2099003.24187 | 37.7430060748628 | -122.470136351038 | (37.7430060748628, -122.470136351038) | |||
| 3734 | 3734 | 118035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |||
| 3770 | 3770 | 94964 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 12 | 5999368.8526 | 2116683.0767599996 | 37.791970737501 | -122.446107814943 | (37.791970737501, -122.446107814943) | |||
| 3807 | 3807 | 90290 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980449.0 | 2110794.0 | 37.7747024934985 | -122.51113148443301 | (37.7747024934985, -122.511131484433) | ||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 3833 | 3833 | 246108 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997166.7764 | 2108416.598 | 37.769147161957605 | -122.453129960901 | (37.7691471619576, -122.453129960901) | |||
| 3844 | 3844 | 246107 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997126.5002 | 2108412.0556 | 37.7691323812935 | -122.453268945279 | (37.7691323812935, -122.453268945279) | |||
| 3847 | 3847 | 246106 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997112.57 | 2108409.6329 | 37.769124930744795 | -122.453316953855 | (37.7691249307448, -122.453316953855) | |||
| 3848 | 3848 | 131894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1902 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5999986.70949 | 2115482.27208 | 37.788708906339295 | -122.443883720452 | (37.7887089063393, -122.443883720452) | |||
| 3861 | 3861 | 253579 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3862 | 3862 | 253583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3865 | 3865 | 253578 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3867 | 3867 | 253577 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3869 | 3869 | 253580 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3870 | 3870 | 253584 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3871 | 3871 | 253582 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3910 | 3910 | 14420 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998841.5976 | 2113071.3194 | 37.7820236767836 | -122.44767199806299 | (37.7820236767836, -122.447671998063) | ||||
| 3911 | 3911 | 11896 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.9074400002 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | ||
| 4018 | 4018 | 2214 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x6 | 6000870.8593 | 2112663.4365 | 37.7810195019401 | -122.440622432274 | (37.7810195019401, -122.440622432274) | |||
| 4039 | 4039 | 3143 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998281.9325 | 2114822.5676 | 37.7868001428071 | -122.449734414591 | (37.7868001428071, -122.449734414591) | |||
| 4170 | 4170 | 6079 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1968 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001023.7414 | 2112472.9897 | 37.780505288271705 | -122.44007987815701 | (37.7805052882717, -122.440079878157) | |||
| 4225 | 4225 | 6366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2072 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000952.842 | 2112811.2423 | 37.7814300071208 | -122.44034941736601 | (37.7814300071208, -122.440349417366) | |||
| 4275 | 4275 | 24939 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7315 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:40:00 AM | 3 | 3X3 | 5984290.37601 | 2112411.90952 | 37.7793707517194 | -122.497963093664 | (37.7793707517194, -122.497963093664) | ||
| 4310 | 4310 | 7733 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006420.56293 | 2111227.36292 | 37.7773908583325 | -122.42132120880501 | (37.7773908583325, -122.421321208805) | |||
| 4323 | 4323 | 5070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5549 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001778.0 | 2097299.0 | 37.738884107486 | -122.43638423012699 | (37.738884107486, -122.436384230127) | |||
| 4641 | 4641 | 177599 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2901 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 2ft | 5997064.2298099995 | 2087562.19472 | 37.7118801719014 | -122.451979889667 | (37.7118801719014, -122.451979889667) | |||
| 4647 | 4647 | 177597 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | Width 2ft | 5996885.021480001 | 2087397.68975 | 37.7114182126546 | -122.45258741589399 | (37.7114182126546, -122.452587415894) | |||
| 4667 | 4667 | 177596 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 2ft | 5996863.1047 | 2087380.0497599998 | 37.7113685215187 | -122.452661893251 | (37.7113685215187, -122.452661893251) | |||
| 4677 | 4677 | 177598 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 4ft | 5996913.03077 | 2087421.1486099998 | 37.7114842300863 | -122.452492300898 | (37.7114842300863, -122.452492300898) | |||
| 4706 | 4706 | 2834 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6008517.592999999 | 2116245.0199599997 | 37.791286140299 | -122.414422000399 | (37.791286140299, -122.414422000399) | |||
| 4767 | 4767 | 7019 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1060 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002340.5774 | 2110230.3568 | 37.774422458417504 | -122.43536385962601 | (37.7744224584175, -122.435363859626) | |||
| 4773 | 4773 | 8756 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996698.2031 | 2112866.405 | 37.781338303610504 | -122.45507230946801 | (37.7813383036105, -122.455072309468) | |||
| 4808 | 4808 | 248401 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 721 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 10 | Width 0ft | Permit Number 35191 | 5998539.5007 | 2108099.8388 | 37.7683559999766 | -122.44835899152099 | (37.7683559999766, -122.448358991521) | |
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5016 | 5016 | 8176 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001924.4605 | 2111208.7057 | 37.7770851190514 | -122.43687333680799 | (37.7770851190514, -122.436873336808) | |||
| 5017 | 5017 | 27394 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2264 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007125.97571 | 2120126.616 | 37.801865757665894 | -122.419512476126 | (37.8018657576659, -122.419512476126) | |||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5115 | 5115 | 14434 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998899.8061 | 2113051.3525 | 37.781972179426205 | -122.447469186406 | (37.7819721794262, -122.447469186406) | |||
| 5260 | 5260 | 10676 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002794.3343 | 2110592.0399 | 37.775441309285604 | -122.433820087 | (37.7754413092856, -122.433820087) | |||
| 5266 | 5266 | 2205 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1119 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000838.0324 | 2112547.0194 | 37.7806979809143 | -122.440727643404 | (37.7806979809143, -122.440727643404) | |||
| 5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
| 5296 | 5296 | 117021 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | |
| 5297 | 5297 | 9909 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.790533307027296 | -122.425657110207 | (37.7905333070273, -122.425657110207) | |||
| 5344 | 5344 | 5307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.43983385427099 | (37.7844511257674, -122.439833854271) | |||
| 5372 | 5372 | 3142 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998246.7366 | 2114816.476 | 37.7867814031738 | -122.449855744427 | (37.7867814031738, -122.449855744427) | |||
| 5407 | 5407 | 5304 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6001115.9968 | 2113959.0141 | 37.7845907831124 | -122.439867300639 | (37.7845907831124, -122.439867300639) | |||
| 5408 | 5408 | 8173 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001985.2987 | 2111217.5273 | 37.777112798515205 | -122.436663510376 | (37.7771127985152, -122.436663510376) | |||
| 5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
| 5436 | 5436 | 10673 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002708.9937 | 2110579.4703 | 37.775401953211706 | -122.434114401257 | (37.7754019532117, -122.434114401257) | |||
| 5469 | 5469 | 19012 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3107 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999843.28922 | 2115392.90967 | 37.7884553586667 | -122.444373507449 | (37.7884553586667, -122.444373507449) | |||
| 5485 | 5485 | 8672 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998008.9107 | 2113150.6793 | 37.7821939533855 | -122.45055842381599 | (37.7821939533855, -122.450558423816) | |||
| 5508 | 5508 | 8174 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001968.8724 | 2111216.0063 | 37.777107688726204 | -122.436720225115 | (37.7771076887262, -122.436720225115) | |||
| 5533 | 5533 | 8673 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997990.2975 | 2113148.3104 | 37.7821863836314 | -122.45062264598499 | (37.7821863836314, -122.450622645985) | |||
| 5551 | 5551 | 8643 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999146.1772 | 2113255.7593 | 37.78254750349429 | -122.44663157016399 | (37.7825475034943, -122.446631570164) | |||
| 5556 | 5556 | 6080 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1970 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001000.0518 | 2112470.2823 | 37.7804965057813 | -122.440161637274 | (37.7804965057813, -122.440161637274) | |||
| 5564 | 5564 | 8191 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1280 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6001633.6542 | 2111170.6819 | 37.7769641829366 | -122.437876600816 | (37.7769641829366, -122.437876600816) | |||
| 5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 5628 | 5628 | 8642 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999172.2357 | 2113259.8204 | 37.7825601426854 | -122.446541711639 | (37.7825601426854, -122.446541711639) | |||
| 5635 | 5635 | 8758 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996732.7221 | 2112870.4661 | 37.781351434582206 | -122.45495318481001 | (37.7813514345822, -122.45495318481) | |||
| 5651 | 5651 | 8712 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3120 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997408.0428 | 2113069.6273 | 37.781936995917896 | -122.45263129483801 | (37.7819369959179, -122.452631294838) | |||
| 5666 | 5666 | 8170 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1190 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002123.0971 | 2111240.3416 | 37.7771832708527 | -122.436188456168 | (37.7771832708527, -122.436188456168) | |||
| 5688 | 5688 | 18490 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6010377.42756 | 2113906.8182 | 37.784970300477 | -122.407822041378 | (37.784970300477, -122.407822041378) | |||
| 5693 | 5693 | 8759 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996749.9816 | 2112873.8503 | 37.781361716788204 | -122.454893720301 | (37.7813617167882, -122.454893720301) | |||
| 5699 | 5699 | 97727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.3141099997 | 37.8034239311172 | -122.42380284664699 | (37.8034239311172, -122.423802846647) | |
| 5705 | 5705 | 2688 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2103 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1991 12:00:00 AM | 6 | 3X3 | 6003377.8906 | 2114832.113 | 37.7871165862827 | -122.432104286971 | (37.7871165862827, -122.432104286971) | ||
| 5744 | 5744 | 117020 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.6658799998 | 37.7824049150971 | -122.41557516146601 | (37.7824049150971, -122.415575161466) | |
| 5756 | 5756 | 8772 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3434 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5996377.3792 | 2112940.8578 | 37.781524320662 | -122.456187581392 | (37.781524320662, -122.456187581392) | |||
| 5800 | 5800 | 20309 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 5832 | 5832 | 20376 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 5847 | 5847 | 8661 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2830 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998270.9338 | 2113188.3287 | 37.7823123226421 | -122.449654659499 | (37.7823123226421, -122.449654659499) | |||
| 5849 | 5849 | 21633 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1615 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004763.9583 | 2114678.6617 | 37.786773733259395 | -122.42729786002701 | (37.7867737332594, -122.427297860027) |
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");