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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
55221 | 55221 | 73723 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | ||
55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
55339 | 55339 | 247955 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6010457.43679 | 2098876.1187400003 | 37.743703890335205 | -122.40648572526001 | (37.7437038903352, -122.40648572526) | ||||
56433 | 56433 | 68920 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1652 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32904 | 6008796.25541 | 2118594.60343 | 37.79775316962 | -122.41362408767598 | (37.79775316962, -122.413624087676) | |
56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
56944 | 56944 | 68985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.0114700003 | 37.804602105955404 | -122.44453584225 | (37.8046021059554, -122.44453584225) | |
57084 | 57084 | 59130 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | |
57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
57357 | 57357 | 60034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 108 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.8494700002 | 37.7815842801353 | -122.39431291753401 | (37.7815842801353, -122.394312917534) | |
57491 | 57491 | 62699 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | ||
58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
58191 | 58191 | 207377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5992030.8504800005 | 2107135.40247 | 37.7653336512411 | -122.47080133672199 | (37.7653336512411, -122.470801336722) | ||||
58270 | 58270 | 59242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 563 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 8 | Permit Number 18573 | 5992504.0033599995 | 2111618.37405 | 37.777670040058496 | -122.469491184767 | (37.7776700400585, -122.469491184767) | ||
58938 | 58938 | 73718 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 73 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | 6001058.666669999 | 2093583.8318599998 | 37.7286422173636 | -122.438605218052 | (37.7286422173636, -122.438605218052) | ||
59630 | 59630 | 65900 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 168 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28907 | 5995947.205130001 | 2113189.79047 | 37.782183121353896 | -122.457693785315 | (37.7821831213539, -122.457693785315) | |
59917 | 59917 | 66499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1608 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 12 | Permit Number 29662 | 5999635.4257 | 2114496.7899 | 37.7859829858425 | -122.445028233013 | (37.7859829858425, -122.445028233013) | |
60703 | 60703 | 54978 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 11 | Permit Number 10856 | 5993145.12705 | 2111021.56757 | 37.7760684014385 | -122.46722993386899 | (37.7760684014385, -122.467229933869) | ||
60821 | 60821 | 68981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2365 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 6 | Permit Number 32971 | 6000015.55575 | 2119854.08532 | 37.8007143961175 | -122.444098179086 | (37.8007143961175, -122.444098179086) | |
60857 | 60857 | 65931 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 115 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 7 | Permit Number 28950 | 5995872.00692 | 2113664.41853 | 37.7834820032566 | -122.45798829440201 | (37.7834820032566, -122.457988294402) | |
61002 | 61002 | 60588 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | |
61200 | 61200 | 207832 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999123.91286 | 2093462.3743099999 | 37.7281984720769 | -122.44528502248001 | (37.7281984720769, -122.44528502248) | ||||
61599 | 61599 | 227266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | ||||
62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
62544 | 62544 | 226705 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1100 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004844.71466 | 2096725.50128 | 37.7374831871032 | -122.42574014009199 | (37.7374831871032, -122.425740140092) | ||||
63022 | 63022 | 59140 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | Permit Number 18446 | 5992233.6974599995 | 2111729.4961200003 | 37.7779595257589 | -122.470434351154 | (37.7779595257589, -122.470434351154) | ||
63108 | 63108 | 56420 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.564180001 | 2113818.4640099998 | 37.783578588527796 | -122.47755460021799 | (37.7835785885278, -122.477554600218) | ||
64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
64784 | 64784 | 37497 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633000005 | -122.408090243478 | (37.790172633, -122.408090243478) | |
65546 | 65546 | 61848 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | ||
65681 | 65681 | 54939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | ||
65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
66714 | 66714 | 227264 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001689.2287 | 2099738.29729 | 37.7455768013454 | -122.436865735887 | (37.7455768013454, -122.436865735887) | ||||
68009 | 68009 | 60029 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.39331563861099 | (37.7818164104522, -122.393315638611) | |
68464 | 68464 | 59131 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18436 | 5992565.527000001 | 2111184.99606 | 37.7764836569005 | -122.469246804392 | (37.7764836569005, -122.469246804392) | ||
69430 | 69430 | 208008 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 247 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998434.03995 | 2093773.3668900002 | 37.72901298084221 | -122.44769230795299 | (37.7290129808422, -122.447692307953) | ||||
70184 | 70184 | 67244 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.50757954173599 | (37.7772032645806, -122.507579541736) | |
70419 | 70419 | 227286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 691 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002107.89107 | 2098826.5345400004 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | ||||
70598 | 70598 | 65826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | |
70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
70979 | 70979 | 59128 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 473 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18433 | 5992483.23161 | 2112207.48548 | 37.779286379459 | -122.469605937359 | (37.779286379459, -122.469605937359) | ||
71526 | 71526 | 62206 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 50 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 13 | Permit Number 22328 | 6001109.87298 | 2093671.7514 | 37.728886537067396 | -122.438434491679 | (37.7288865370674, -122.438434491679) | |
72514 | 72514 | 61855 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066002 | (37.7540649402035, -122.40731493066) | ||
72931 | 72931 | 72136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 535 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1990 12:00:00 AM | 9 | 6014127.25361 | 2104594.96459 | 37.759611242589706 | -122.39419658392099 | (37.7596112425897, -122.394196583921) | ||
73115 | 73115 | 68918 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1731 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32899 | 6009145.56642 | 2119236.5699 | 37.799535459556 | -122.412460772349 | (37.799535459556, -122.412460772349) | |
73281 | 73281 | 114558 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.42581446009599 | (37.7936541667538, -122.425814460096) | ||
74977 | 74977 | 74222 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 10 | 6012358.62681 | 2102848.31202 | 37.7547168532055 | -122.400190745215 | (37.7547168532055, -122.400190745215) | ||
75056 | 75056 | 32770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | |
75355 | 75355 | 57997 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 407 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 10 | Permit Number 22184 | 6013252.809230001 | 2105139.22095 | 37.761057008003796 | -122.397259036287 | (37.7610570080038, -122.397259036287) | |
75453 | 75453 | 60026 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.094769999 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | |
75640 | 75640 | 59136 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 8 | Permit Number 18442 | 5992181.25908 | 2111926.88103 | 37.7784984588509 | -122.47063013268401 | (37.7784984588509, -122.470630132684) | ||
75753 | 75753 | 108149 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
76042 | 76042 | 70030 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | ||
76450 | 76450 | 32769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) | |
76780 | 76780 | 40626 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | |
77052 | 77052 | 53446 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/1986 12:00:00 AM | 13 | Permit Number 23061 | 6007531.55063 | 2119171.09402 | 37.799264970461 | -122.418041215832 | (37.799264970461, -122.418041215832) | |
77722 | 77722 | 50451 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.768953206578296 | -122.445784947419 | (37.7689532065783, -122.445784947419) | |||
78044 | 78044 | 68850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | ||
78084 | 78084 | 61853 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.75412631741629 | -122.407320968841 | (37.7541263174163, -122.407320968841) | ||
79610 | 79610 | 32821 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
79613 | 79613 | 51053 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | |||
79635 | 79635 | 61858 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1150 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21898 | 6010250.43626462 | 2102515.61174925 | 37.7536855558022 | -122.40745802144 | (37.7536855558022, -122.40745802144) | ||
79967 | 79967 | 67901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175004 | -122.45122163283001 | (37.729148458175, -122.45122163283) | ||
80636 | 80636 | 33769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
81286 | 81286 | 35152 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | ||
82276 | 82276 | 96882 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
82585 | 82585 | 44826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.40619016379601 | (37.7120713475932, -122.406190163796) | |||
82598 | 82598 | 62789 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.44101991790899 | (37.7234373055999, -122.441019917909) | ||
83421 | 83421 | 41268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
83522 | 83522 | 35726 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
84112 | 84112 | 68819 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.44437438127702 | (37.729117226145, -122.444374381277) | ||
84624 | 84624 | 96883 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
84977 | 84977 | 98681 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
85009 | 85009 | 98240 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 800 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
85474 | 85474 | 61845 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21884 | 6010284.24906681 | 2102833.32009511 | 37.7545598048232 | -122.407363484663 | (37.7545598048232, -122.407363484663) | ||
86463 | 86463 | 96884 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
86556 | 86556 | 61933 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | 36 | Permit Number 21990 | 6005702.47179 | 2100196.42976905 | 37.747062005493206 | -122.42302109514699 | (37.7470620054932, -122.423021095147) | |
87389 | 87389 | 46271 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | Permit Number 44555 | 6006560.87997001 | 2097281.80561087 | 37.739107504355005 | -122.419846001297 | (37.739107504355, -122.419846001297) | |||
87503 | 87503 | 34773 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1130 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38414 | 6008029.42163869 | 2101336.50490812 | 37.7503234289999 | -122.41505535764 | (37.7503234289999, -122.41505535764) | |
87544 | 87544 | 61695 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 9 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1984 12:00:00 AM | Permit Number 21694 | 6005214.10969137 | 2107753.44919209 | 37.7677842392376 | -122.425247470035 | (37.7677842392376, -122.425247470035) | ||
87789 | 87789 | 63516 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3130 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24125 | 6009013.02136045 | 2104526.43175215 | 37.7591374742847 | -122.41187937836399 | (37.7591374742847, -122.411879378364) | ||
88011 | 88011 | 58120 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 839 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 17101 | 6003847.07815842 | 2110734.06414103 | 37.7758909552538 | -122.430188532102 | (37.7758909552538, -122.430188532102) | ||
88051 | 88051 | 62207 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | Permit Number 22329 | 6001115.41413851 | 2093618.10384038 | 37.728739548363 | -122.438411493533 | (37.728739548363, -122.438411493533) | ||
88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
88113 | 88113 | 41267 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
88630 | 88630 | 38432 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498002 | (37.7895138928462, -122.45834869498) | |||
88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
90728 | 90728 | 63893 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435.0 | 2109828.0 | 37.773549358695796 | -122.42117187599301 | (37.7735493586958, -122.421171875993) | ||
90947 | 90947 | 61850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1078 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21889 | 6010226.10973791 | 2102942.52266102 | 37.754856396543204 | -122.407572245672 | (37.7548563965432, -122.407572245672) | ||
91185 | 91185 | 61842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.40741936190001 | (37.7551438802467, -122.4074193619) | ||
91213 | 91213 | 68860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.554712901 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | ||
91968 | 91968 | 37256 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
91983 | 91983 | 61697 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 22 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1984 12:00:00 AM | Permit Number 21696 | 6005166.04109398 | 2107681.05439541 | 37.767582744756 | -122.425408581153 | (37.767582744756, -122.425408581153) | ||
92018 | 92018 | 110190 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | |||||
92448 | 92448 | 69203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33251 | 6008996.86818866 | 2101940.25932804 | 37.752035522179206 | -122.411752505652 | (37.7520355221792, -122.411752505652) | ||
92729 | 92729 | 98679 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
93483 | 93483 | 68881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | ||
93525 | 93525 | 66553 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 160 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29737 | 6005262.81634386 | 2104026.69666345 | 37.7575542112069 | -122.424813838267 | (37.7575542112069, -122.424813838267) | ||
93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) |
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");