Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10235 | 10235 | 173926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
| 78027 | 78027 | 107959 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 80541 | 80541 | 111018 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 81547 | 81547 | 103610 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | ||||
| 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) | |||
| 87413 | 87413 | 116811 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3660x 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005401.0 | 2102665.0 | 37.7538231135776 | -122.42423909941999 | (37.7538231135776, -122.42423909942) | ||||
| 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) | ||||
| 89173 | 89173 | 117520 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601 PAGE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 91394 | 91394 | 121040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
| 93011 | 93011 | 113435 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 93704 | 93704 | 111067 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1800 10TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993175.0 | 2103134.0 | 37.754412945302796 | -122.46655315826901 | (37.7544129453028, -122.466553158269) | ||||
| 95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | 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) | ||||
| 95860 | 95860 | 114797 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 96424 | 96424 | 37257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 2 | 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) | ||
| 96494 | 96494 | 110186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 97203 | 97203 | 89033 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 99490 | 99490 | 34781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.74978206863771 | -122.41482315731301 | (37.7497820686377, -122.414823157313) | ||
| 99934 | 99934 | 33771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 100780 | 100780 | 63619 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 801X Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | Permit Number 24261 | 5993268.63068404 | 2106608.32607844 | 37.7639579422382 | -122.466481867874 | (37.7639579422382, -122.466481867874) | |||
| 102595 | 102595 | 34533 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 395 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38241 | 6007729.86435225 | 2097252.7163141 | 37.7390934181522 | -122.415802113579 | (37.7390934181522, -122.415802113579) | |||
| 103792 | 103792 | 35727 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 2 | 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) | ||
| 103890 | 103890 | 32822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 2 | 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) | ||
| 104594 | 104594 | 121622 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298X Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998141.0 | 2093851.0 | 37.72920939055871 | -122.44871095421401 | (37.7292093905587, -122.448710954214) | ||||
| 106587 | 106587 | 122454 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||||
| 106910 | 106910 | 40057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | ||
| 110352 | 110352 | 89007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558.0 | 2104034.0 | 37.757590932481 | -122.42379349206001 | (37.757590932481, -122.42379349206) | ||
| 113124 | 113124 | 114878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 226 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001315.0 | 2109584.0 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | ||||
| 128670 | 128670 | 122343 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994723.0 | 2112183.0 | 37.7793483429351 | -122.461855927769 | (37.7793483429351, -122.461855927769) | ||||
| 129054 | 129054 | 101245 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
| 141019 | 141019 | 105874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 146055 | 146055 | 109820 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.779331512641896 | -122.42693096158101 | (37.7793315126419, -122.426930961581) | ||||
| 64682 | 64682 | 207404 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.737752914457396 | -122.472028548874 | (37.7377529144574, -122.472028548874) | |||
| 147156 | 147156 | 182589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | |||
| 157262 | 157262 | 207897 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991557.6312 | 2097072.51432 | 37.7376762031927 | -122.471704678736 | (37.7376762031927, -122.471704678736) | |||
| 32071 | 32071 | 227389 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3014 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009181.84583 | 2104530.5514 | 37.759158255859106 | -122.411295791464 | (37.7591582558591, -122.411295791464) | |||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 39838 | 39838 | 227348 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 383 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006101.45441 | 2097927.38523 | 37.7408542283508 | -122.421480324955 | (37.7408542283508, -122.421480324955) | |||
| 47166 | 47166 | 227292 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1831 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002653.15618 | 2100170.70248 | 37.746818822623894 | -122.433563522461 | (37.7468188226239, -122.433563522461) | ||||
| 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) | |
| 71064 | 71064 | 183299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983077.482999999 | 2106392.3859 | 37.7627716918826 | -122.501713459776 | (37.7627716918826, -122.501713459776) | |||
| 73996 | 73996 | 129577 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000796.651269999 | 2116729.75273 | 37.7921803299124 | -122.44117098565 | (37.7921803299124, -122.44117098565) | |||
| 130904 | 130904 | 129591 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.42352338950899 | (37.7939448878875, -122.423523389509) | |||
| 149944 | 149944 | 207913 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994687.05198 | 2099628.96292 | 37.7448761386401 | -122.461070093006 | (37.7448761386401, -122.461070093006) | |||
| 163811 | 163811 | 207919 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993555.00989 | 2095089.8986 | 37.73234779381271 | -122.464654913005 | (37.7323477938127, -122.464654913005) | |||
| 187836 | 187836 | 138111 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2109 BUSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003316.4709 | 2114827.0332 | 37.787099156045606 | -122.432316422563 | (37.7870991560456, -122.432316422563) | |||
| 22502 | 22502 | 1654 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 3X3 | 6006190.88992 | 2115436.6109700003 | 37.788935469840105 | -122.42241488063699 | (37.7889354698401, -122.422414880637) | ||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
| 36298 | 36298 | 207910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 272 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992257.40464 | 2097504.13559 | 37.7389017884968 | -122.46931665586 | (37.7389017884968, -122.46931665586) | |||
| 38750 | 38750 | 208004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.15319 | 2094958.3543599998 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | |||
| 40319 | 40319 | 207930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.45689963632499 | (37.7259343298845, -122.456899636325) | |||
| 47750 | 47750 | 96007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.791788061820704 | -122.41048002812599 | (37.7917880618207, -122.410480028126) |
| 51405 | 51405 | 207949 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992678.23044 | 2100499.52384 | 37.74715067338229 | -122.468079477383 | (37.7471506733823, -122.468079477383) | |||
| 51625 | 51625 | 129675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012092.09526 | 2116799.4138599997 | 37.79300852816029 | -122.402093232241 | (37.7930085281603, -122.402093232241) | |||
| 54549 | 54549 | 227289 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 687 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002191.96194 | 2098829.02358 | 37.743108709092496 | -122.435062343346 | (37.7431087090925, -122.435062343346) | ||||
| 56260 | 56260 | 226732 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005449.890380001 | 2104032.03059 | 37.7575794213831 | -122.42416723932301 | (37.7575794213831, -122.424167239323) | |||
| 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) | ||
| 76053 | 76053 | 129617 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048005 | -122.417971832253 | (37.776795356048, -122.417971832253) | |||
| 101641 | 101641 | 78999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 130205 | 130205 | 207917 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994692.52857 | 2099722.50735 | 37.7451333033531 | -122.461057935084 | (37.7451333033531, -122.461057935084) | |||
| 136993 | 136993 | 129589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005852.90495 | 2116274.14842 | 37.7912160669044 | -122.423643836609 | (37.7912160669044, -122.423643836609) | |||
| 141590 | 141590 | 109255 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1533 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2015 12:00:00 AM | 3 | 3x3 | 6006572.5 | 2115603.9 | 37.78941632368 | -122.421106442083 | (37.78941632368, -122.421106442083) | ||
| 146083 | 146083 | 17143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 150511 | 150511 | 207974 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995054.28957 | 2096220.4880400002 | 37.7355384364438 | -122.45955344665501 | (37.7355384364438, -122.459553446655) | |||
| 162490 | 162490 | 227199 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 385 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008809.712730001 | 2097016.0222900002 | 37.738504155041 | -122.41205175259199 | (37.738504155041, -122.412051752592) | |||
| 167970 | 167970 | 207952 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993588.025769999 | 2101347.20495 | 37.7495306895917 | -122.464995058183 | (37.7495306895917, -122.464995058183) | |||
| 172277 | 172277 | 207907 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992559.1719 | 2097834.73481 | 37.7398269642322 | -122.468297338164 | (37.7398269642322, -122.468297338164) | |||
| 182178 | 182178 | 129664 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009352.05636 | 2121603.21217 | 37.8060452561514 | -122.411913571751 | (37.8060452561514, -122.411913571751) | |||
| 186286 | 186286 | 129567 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 245 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997570.752730001 | 2115509.3434099997 | 37.788645132713796 | -122.45224449091101 | (37.7886451327138, -122.452244490911) | |||
| 188009 | 188009 | 177141 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 355 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003671.36983 | 2091507.3370599998 | 37.7230889064227 | -122.429424930532 | (37.7230889064227, -122.429424930532) | |||
| 4584 | 4584 | 129646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 4 | Width 3ft | 6009824.55896 | 2121666.13191 | 37.8062445153435 | -122.41028283828899 | (37.8062445153435, -122.410282838289) | ||
| 23288 | 23288 | 15312 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | ||
| 33884 | 33884 | 227436 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000934.92196 | 2104940.29183 | 37.759817324036796 | -122.439846911128 | (37.7598173240368, -122.439846911128) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 36010 | 36010 | 124006 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993993.05196 | 2113317.82829 | 37.782422226449 | -122.46446352346001 | (37.782422226449, -122.46446352346) | |||
| 40353 | 40353 | 207983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.44423726735799 | (37.7326518231051, -122.444237267358) | |||
| 47017 | 47017 | 129614 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824896999 | (37.7854973571526, -122.42115824897) | |||
| 63027 | 63027 | 207411 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 368 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994209.72393 | 2101319.30186 | 37.7494899026486 | -122.462843199076 | (37.7494899026486, -122.462843199076) | |||
| 66479 | 66479 | 246041 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 635 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998971.6377 | 2108485.0374 | 37.769438354581 | -122.446891997517 | (37.769438354581, -122.446891997517) | |||
| 68993 | 68993 | 207925 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 275 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994659.0424 | 2100279.1844900004 | 37.746659871972795 | -122.461214068202 | (37.7466598719728, -122.461214068202) | |||
| 71982 | 71982 | 207810 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 275 Dalewood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995297.028940001 | 2097233.56959 | 37.73833406445161 | -122.458787531816 | (37.7383340644516, -122.458787531816) | |||
| 75215 | 75215 | 177113 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005075.07966 | 2093337.7914900002 | 37.728194306415 | -122.42470273344 | (37.728194306415, -122.42470273344) | |||
| 76560 | 76560 | 177125 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 418 Amherst St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007739.52277 | 2091837.25861 | 37.724224288797004 | -122.41538544049 | (37.724224288797, -122.41538544049) | |||
| 86580 | 86580 | 20261 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 4 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 123815 | 123815 | 207396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5992865.43172 | 2103190.1743799997 | 37.754549316717 | -122.467627800978 | (37.754549316717, -122.467627800978) | |||
| 127107 | 127107 | 227425 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000719.82066 | 2104645.16587 | 37.7589947339254 | -122.440569671059 | (37.7589947339254, -122.440569671059) | |||
| 149924 | 149924 | 123764 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5993275.9255 | 2110687.3078900003 | 37.775158163745395 | -122.466753167394 | (37.7751581637454, -122.466753167394) | |||
| 182667 | 182667 | 244099 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998841.7867 | 2108999.0531 | 37.7708422919425 | -122.44737814683 | (37.7708422919425, -122.44737814683) | |||
| 183136 | 183136 | 207985 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998813.609180001 | 2095274.4257 | 37.733156221377 | -122.446488060895 | (37.733156221377, -122.446488060895) | |||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 2916 | 2916 | 140305 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997929.2973 | 2109958.9845 | 37.7734258317863 | -122.450603670824 | (37.7734258317863, -122.450603670824) | |||
| 19050 | 19050 | 4227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 5 | 3X3 | 6004005.18822 | 2100441.9925599997 | 37.7476403416378 | -122.428907662964 | (37.7476403416378, -122.428907662964) | ||
| 30591 | 30591 | 207827 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999363.8655900005 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | |||
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 44679 | 44679 | 101107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.48175694812299 | (37.7542321578078, -122.481756948123) | ||
| 75405 | 75405 | 129594 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005803.86488 | 2117245.73922 | 37.793881043227 | -122.423882631794 | (37.793881043227, -122.423882631794) | |||
| 130102 | 130102 | 226696 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Ramona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005201.48103 | 2107781.05684 | 37.767859329770296 | -122.42529311588999 | (37.7678593297703, -122.42529311589) |
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");