Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3258 | 3258 | 253374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 79769 | 79769 | 113436 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 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) | ||||
| 82008 | 82008 | 105875 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 84994 | 84994 | 89034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 3 | 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) | |||
| 89620 | 89620 | 114798 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 97255 | 97255 | 110187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | |||||
| 97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | 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) | ||||
| 98674 | 98674 | 37252 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | 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) | ||
| 102300 | 102300 | 35728 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 3 | 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) | ||
| 104609 | 104609 | 121041 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
| 108877 | 108877 | 107463 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | |||||
| 116161 | 116161 | 34044 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 125971 | 125971 | 108151 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 138925 | 138925 | 37164 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3555 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.747982034538296 | -122.420875232711 | (37.7479820345383, -122.420875232711) | ||
| 140772 | 140772 | 32771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.774318351022295 | -122.440968898129 | (37.7743183510223, -122.440968898129) | ||
| 140948 | 140948 | 111019 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 3 | 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) | |||
| 33606 | 33606 | 207898 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | |||
| 60067 | 60067 | 207405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.745630001 | 2097109.88885 | 37.737773449589795 | -122.47202854890499 | (37.7377734495898, -122.472028548905) | |||
| 40608 | 40608 | 129578 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000794.176109999 | 2116746.49388 | 37.7922261557494 | -122.441180751388 | (37.7922261557494, -122.441180751388) | |||
| 56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
| 57403 | 57403 | 207920 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993561.46186 | 2095084.6811400002 | 37.73233383991511 | -122.46463222850599 | (37.7323338399151, -122.464632228506) | |||
| 60893 | 60893 | 129592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.79392892673889 | -122.42362005315 | (37.7939289267389, -122.42362005315) | |||
| 69900 | 69900 | 141422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004543.5906 | 2111042.8919 | 37.7767783457628 | -122.42780112527001 | (37.7767783457628, -122.42780112527) | |||
| 179397 | 179397 | 101144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | |||
| 187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
| 14433 | 14433 | 17144 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.5240900002 | 37.728978186084 | -122.38036919809099 | (37.728978186084, -122.380369198091) | ||
| 26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
| 35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
| 45456 | 45456 | 207958 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995753.89015 | 2100245.5855099997 | 37.7466305648554 | -122.457425790981 | (37.7466305648554, -122.457425790981) | |||
| 46018 | 46018 | 207936 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.84945 | 2094603.0079700002 | 37.731195952027996 | -122.453491559201 | (37.731195952028, -122.453491559201) | |||
| 53642 | 53642 | 177061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5999007.9061199995 | 2090532.0864 | 37.720145957757104 | -122.44547544316002 | (37.7201459577571, -122.44547544316) | |||
| 54907 | 54907 | 207912 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993750.78708 | 2099620.0090799998 | 37.744797631402996 | -122.46430684749501 | (37.744797631403, -122.464306847495) | |||
| 60928 | 60928 | 207951 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993609.19049 | 2101330.01407 | 37.7494847081672 | -122.4649206222 | (37.7494847081672, -122.4649206222) | |||
| 64260 | 64260 | 226666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004707.88321 | 2109244.5049400004 | 37.771849706222504 | -122.42710466345899 | (37.7718497062225, -122.427104663459) | |||
| 67836 | 67836 | 207948 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992690.99199 | 2100498.58562 | 37.7471488342554 | -122.468035281115 | (37.7471488342554, -122.468035281115) | |||
| 99189 | 99189 | 20272 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | ||
| 100018 | 100018 | 78992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 102161 | 102161 | 103603 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 122515 | 122515 | 100230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.49952497559799 | (37.7753575879766, -122.499524975598) | |||
| 134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
| 134858 | 134858 | 96008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.6515099998 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) |
| 140063 | 140063 | 74108 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 3 | 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) | |
| 146675 | 146675 | 227205 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 533 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008456.33815 | 2096517.71816 | 37.7371160874276 | -122.413238327983 | (37.7371160874276, -122.413238327983) | |||
| 146811 | 146811 | 129676 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 167437 | 167437 | 226661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.99983 | 2108080.69145 | 37.7686555760307 | -122.42693488134199 | (37.7686555760307, -122.426934881342) | |||
| 24746 | 24746 | 207954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Sotelo Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994065.04944 | 2100893.3637099997 | 37.7483120506561 | -122.46331257952801 | (37.7483120506561, -122.463312579528) | |||
| 28195 | 28195 | 191490 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008642.47534 | 2110374.13795 | 37.775173122971296 | -122.41357449906299 | (37.7751731229713, -122.413574499063) | |||
| 32273 | 32273 | 227514 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006464.67083 | 2109591.57876 | 37.7729018752621 | -122.42105245002399 | (37.7729018752621, -122.421052450024) | |||
| 68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
| 163117 | 163117 | 191445 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 19th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013335.759880001 | 2105192.0474900003 | 37.761206675862205 | -122.396975847857 | (37.7612066758622, -122.396975847857) | |||
| 185719 | 185719 | 207828 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999348.944080001 | 2093797.91328 | 37.729132626663706 | -122.444531189165 | (37.7291326266637, -122.444531189165) | |||
| 187665 | 187665 | 124007 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993994.36391 | 2113305.2433 | 37.7823877470983 | -122.464458070673 | (37.7823877470983, -122.464458070673) | |||
| 34291 | 34291 | 207820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998217.897469999 | 2093812.4595700002 | 37.729107964547794 | -122.44844233986099 | (37.7291079645478, -122.448442339861) | |||
| 34352 | 34352 | 227426 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000732.63696 | 2104644.90008 | 37.7589947339321 | -122.440525327306 | (37.7589947339321, -122.440525327306) | |||
| 58696 | 58696 | 207965 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.44931106965299 | (37.7345149737803, -122.449311069653) | |||
| 63493 | 63493 | 227262 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1334 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001352.76553 | 2099787.74958 | 37.745693456895204 | -122.43803271325001 | (37.7456934568952, -122.43803271325) | |||
| 105226 | 105226 | 138704 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2521 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001167.2865 | 2114524.96 | 37.786147644599 | -122.439730444644 | (37.786147644599, -122.439730444644) | |||
| 155744 | 155744 | 129665 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.806093654068796 | -122.411922953492 | (37.8060936540688, -122.411922953492) | |||
| 159356 | 159356 | 139818 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1672 EDDY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002454.8426 | 2112669.6973 | 37.7811267653815 | -122.43514310289801 | (37.7811267653815, -122.435143102898) | |||
| 167651 | 167651 | 207397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992858.7373 | 2103189.98205 | 37.7545484021055 | -122.467650937865 | (37.7545484021055, -122.467650937865) | |||
| 176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
| 182185 | 182185 | 177119 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6003367.9404 | 2092809.07535 | 37.7266460056919 | -122.430566665719 | (37.7266460056919, -122.430566665719) | |||
| 185976 | 185976 | 227167 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998089.83813 | 2106503.39659 | 37.76394685618 | -122.449799262145 | (37.76394685618, -122.449799262145) | |||
| 2918 | 2918 | 140306 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997911.1716 | 2109955.9635 | 37.773416499401705 | -122.450666152059 | (37.7734164994017, -122.450666152059) | |||
| 7677 | 7677 | 11437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005576.77796 | 2117294.0070599997 | 37.7940007519905 | -122.42467181025499 | (37.7940007519905, -122.424671810255) | |||
| 28015 | 28015 | 227442 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002319.53063 | 2104152.62296 | 37.7577332935784 | -122.435001901726 | (37.7577332935784, -122.435001901726) | |||
| 32666 | 32666 | 245945 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 97 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998847.6292 | 2107686.9313 | 37.7672398720062 | -122.44726348656 | (37.7672398720062, -122.44726348656) | |||
| 33447 | 33447 | 208010 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998766.05843 | 2093398.5760400002 | 37.728002863243205 | -122.446517546066 | (37.7280028632432, -122.446517546066) | |||
| 49183 | 49183 | 227263 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 743 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001723.660019999 | 2099680.3247 | 37.7454195791479 | -122.436742528759 | (37.7454195791479, -122.436742528759) | |||
| 52188 | 52188 | 36155 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.1283 | 2114145.8086 | 37.784842652821496 | -122.45568053932399 | (37.7848426528215, -122.455680539324) | |
| 54644 | 54644 | 227344 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008419.04093 | 2096682.95648 | 37.7375677017941 | -122.413378963976 | (37.7375677017941, -122.413378963976) | |||
| 70640 | 70640 | 191448 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1375 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | |||
| 82162 | 82162 | 20277 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 89702 | 89702 | 20267 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 99318 | 99318 | 5483 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 700X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 6 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 119444 | 119444 | 15325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1X1 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 128542 | 128542 | 14788 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 154412 | 154412 | 177052 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998953.787769999 | 2090172.9381799998 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | |||
| 158341 | 158341 | 118272 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5984451.19382 | 2110333.53689 | 37.7736735662944 | -122.497253299741 | (37.7736735662944, -122.497253299741) | |||
| 165829 | 165829 | 227281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4181 23rd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6001938.68503 | 2102334.04898 | 37.752718294320296 | -122.43618888093701 | (37.7527182943203, -122.436188880937) | |||
| 182818 | 182818 | 123765 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993254.87771 | 2110685.3073 | 37.775151455932104 | -122.466825830328 | (37.7751514559321, -122.466825830328) | |||
| 187790 | 187790 | 226726 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2730 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010313.932519999 | 2102839.26817 | 37.7545777982407 | -122.40726125021601 | (37.7545777982407, -122.407261250216) | |||
| 32769 | 32769 | 226755 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004144.01902 | 2098653.98264 | 37.7427387360976 | -122.428300179912 | (37.7427387360976, -122.428300179912) | |||
| 65316 | 65316 | 191478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014500.76851 | 2112629.04154 | 37.781691790478796 | -122.39346703317499 | (37.7816917904788, -122.393467033175) | |||
| 74148 | 74148 | 227250 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005794.59689 | 2096357.13637 | 37.7365253704536 | -122.422429779736 | (37.7365253704536, -122.422429779736) | |||
| 136024 | 136024 | 227308 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002314.2643 | 2098316.80791 | 37.7417092282111 | -122.43460283744699 | (37.7417092282111, -122.434602837447) | |||
| 153917 | 153917 | 227421 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4611 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000615.840030001 | 2104640.77483 | 37.758976755599704 | -122.440928969103 | (37.7589767555997, -122.440928969103) | |||
| 164871 | 164871 | 226669 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.057440001 | 2106924.30834 | 37.7657133036545 | -122.412553697512 | (37.7657133036545, -122.412553697512) | |||
| 165662 | 165662 | 141576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1480 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000723.6824 | 2110698.6413 | 37.7756162917204 | -122.440990592453 | (37.7756162917204, -122.440990592453) | |||
| 168921 | 168921 | 250110 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006127.47241 | 2115428.56912 | 37.7889098112749 | -122.422633725286 | (37.7889098112749, -122.422633725286) | |||
| 175375 | 175375 | 141040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 80 Cook St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997545.9497 | 2113169.6309 | 37.7822194802715 | -122.452161420734 | (37.7822194802715, -122.452161420734) | |||
| 176132 | 176132 | 138670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1718 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999600.9508 | 2114760.7686 | 37.786705834843204 | -122.44516649185199 | (37.7867058348432, -122.445166491852) | |||
| 177041 | 177041 | 227379 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006865.432019999 | 2101476.6726599997 | 37.750642818218104 | -122.419090462054 | (37.7506428182181, -122.419090462054) | |||
| 186971 | 186971 | 72130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | ||
| 29762 | 29762 | 191469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.39423389317699 | (37.7818525865622, -122.394233893177) | |||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) |
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");