Street_Tree_List

Data source: data.sfgov.org

2,671 rows where qSpecies = 35

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
92 98091 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
158 21682 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1830 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
213 28640 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
343 244298 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 350 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
368 18096 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 3008 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
426 21683 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1840 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
605 23903 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
853 244350 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 300 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/20/2017 07:22:00 AM 3 Width 0ft   6005619.219 2110418.7508 37.77512539438639 -122.424035805431 (37.7751253943864, -122.424035805431)
1012 246499 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 311 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779776 6004393.833380001 2099835.13521 37.7459960419019 -122.427520522551 (37.7459960419019, -122.427520522551)
1259 238460 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 52 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2017 12:00:00 AM 3 Width 3ft Permit Number 779768 6002902.99046 2108581.89909 37.7699281239255 -122.433300551682 (37.7699281239255, -122.433300551682)
1472 244877 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1349 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6000105.0 2109153.0 37.7713370947812 -122.443019734512 (37.7713370947812, -122.443019734512)
1998 135937 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 98 Spruce St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2017 12:00:00 AM 3 3x3 Permit Number 780098 5997052.02369 2116054.59656 37.7901125223289 -122.45407860247299 (37.7901125223289, -122.454078602473)
2000 237999 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 4302 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 2 Width 4ft Permit Number 769743 6001218.46057 2101752.36044 37.7510801711245 -122.438637864349 (37.7510801711245, -122.438637864349)
2427 23895 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1581 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/30/2006 12:00:00 AM 3 3X3   6003532.7108 2114115.4269999997 37.7851575236987 -122.431517459739 (37.7851575236987, -122.431517459739)
2489 119760 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2492 119762 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2501 119761 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2508 119759 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2513 138183 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.6580000003 37.7869904804487 -122.43016773530199 (37.7869904804487, -122.430167735302)
2541 138182 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003933.6106 2114790.6807 37.7870343146011 -122.43017866131201 (37.7870343146011, -122.430178661312)
2544 138181 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003932.1968 2114801.9909 37.7870652894849 -122.43018435992599 (37.7870652894849, -122.430184359926)
2550 138186 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 Width 0ft   6003941.622 2114719.9923 37.786840675810396 -122.43014589889499 (37.7868406758104, -122.430145898895)
2613 98090 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
2665 21684 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1840 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/2004 12:00:00 AM 3 4x4   6003739.9244 2114585.2131 37.7864591803505 -122.43083410335501 (37.7864591803505, -122.430834103355)
3013 39333 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
3043 244994 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 231 Lily St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM 4 Width 0ft Permit Number 45013 6005396.3109 2110099.8972 37.774237312156295 -122.4247842062 (37.7742373121563, -122.4247842062)
3194 253362 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1737 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3195 253357 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1705 Buchanan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3197 253348 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1728 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3199 253365 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1745 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3200 253352 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1756 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3205 253356 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1705 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3207 253355 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1705 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3209 253364 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1741 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3215 253360 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1723 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3217 253347 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1700 Buchanan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3218 139416 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1701 POST ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2014 12:00:00 AM 3 Width 0ft   6004006.3401 2114230.9234 37.7855014808051 -122.429887091087 (37.7855014808051, -122.429887091087)
3221 253361 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1737 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3224 253358 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1715 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3225 253351 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1756 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3226 138479 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1700 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM 2 Width 0ft Permit Number 47204 6004045.5542 2114285.9086 37.7856546769882 -122.429755345095 (37.7856546769882, -122.429755345095)
3229 253353 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1705 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3233 253345 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1700 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3234 253359 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1723 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3236 253349 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1756 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3238 253363 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1741 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3242 253354 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1705 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3244 253350 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1756 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3245 138485 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1700 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM 2 Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3246 253346 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1700 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3398 245004 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1201 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6000727.3724 2109263.3505 37.7716755548589 -122.44087484303499 (37.7716755548589, -122.440874843035)
3528 13088 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 722 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6008925.6016 2120449.3844 37.802853199751794 -122.413307745784 (37.8028531997518, -122.413307745784)
3617 196400 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 380x Clara St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6011308.09655 2111275.91215 37.7777985048225 -122.404416956276 (37.7777985048225, -122.404416956276)
4145 113403 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2052 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006463.2485 2117908.2188 37.7957372487994 -122.42164817262501 (37.7957372487994, -122.421648172625)
4166 143128 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2052 POLK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6006467.2287 2117887.8753 37.795681615093 -122.421632954779 (37.795681615093, -122.421632954779)
4179 23894 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1581 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 09:37:00 AM 3 3X3   6003529.5219 2114142.2135 37.7852308919409 -122.431530405312 (37.7852308919409, -122.431530405312)
4250 139410 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1500 GEARY BLVD 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 10:27:00 AM 3 Width 0ft   6004177.291 2114035.4814 37.78497452552379 -122.429281709952 (37.7849745255238, -122.429281709952)
4281 139414 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1500 GEARY BLVD 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 10:29:00 AM 3 Width 0ft   6004053.5092 2114020.2427 37.7849256755107 -122.42970886814301 (37.7849256755107, -122.429708868143)
4309 1910 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 47 Beideman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6001514.9606 2113070.1349 37.782172849750296 -122.43842331734601 (37.7821728497503, -122.438423317346)
4331 87404 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 9 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 3x3   6003683.0746 2113412.9921 37.783237334948105 -122.43094709822701 (37.7832373349481, -122.430947098227)
4409 114730 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2536 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 780830 6002593.47602 2116148.5251 37.790686613557504 -122.43491236523899 (37.7906866135575, -122.434912365239)
4504 8092 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 762 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Arts Commission 19   12/04/2010 12:00:00 AM 3 3X3   6004291.3267 2111546.8391 37.778147787093 -122.428709714706 (37.778147787093, -122.428709714706)
4516 28647 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 9 Median : Cutout 11 Tree 1 DPW 2     8 6   6003547.8453 2114380.4001 37.785885930849204 -122.431484021877 (37.7858859308492, -122.431484021877)
4753 98088 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
5269 8090 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 762 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Arts Commission 19   12/04/2010 12:00:00 AM 3 3X3   6004349.2473 2111557.1689 37.7781794280627 -122.428510082803 (37.7781794280627, -122.428510082803)
5333 26937 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1529 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6002019.9705 2111862.8998 37.7788867994939 -122.436589775324 (37.7788867994939, -122.436589775324)
5350 28646 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
5373 31852 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1117 Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35299          
5466 21688 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1881 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1992 12:00:00 AM 2 4x4   6003696.9634 2114537.7544 37.7863264365495 -122.430979349218 (37.7863264365495, -122.430979349218)
5518 39334 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
5536 8091 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 762 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Arts Commission 19   12/04/2010 12:00:00 AM 3 3X3   6004317.1512 2111553.1108 37.7781664691559 -122.42862082556499 (37.7781664691559, -122.428620825565)
5542 8104 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 780 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/04/2010 12:00:00 AM 3 3X3   6004088.9733 2111516.0342 37.7780517500412 -122.429407531137 (37.7780517500412, -122.429407531137)
5618 87403 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 8 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 10 3x3   6003687.1999 2113392.3659 37.7831809343135 -122.430931353807 (37.7831809343135, -122.430931353807)
5957 28643 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 5 Median : Cutout 11 Tree 1 DPW 2     10 20   6003700.2631 2113325.6745 37.7829985565916 -122.43088139933201 (37.7829985565916, -122.430881399332)
5979 98098 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 81 Frank Norris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6006897.32558 2115510.94052 37.789179385771604 -122.41997598040399 (37.7891793857716, -122.419975980404)
5993 23902 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 5 Median : Cutout 11 Tree 1 DPW 2     8 20   6003560.0188 2114334.411 37.7857603463241 -122.431438620741 (37.7857603463241, -122.431438620741)
6039 23898 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1581 Webster St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/30/2006 12:00:00 AM 3 3X3   6003553.1196 2113987.2345 37.7848066960652 -122.43143769715701 (37.7848066960652, -122.431437697157)
6273 106722 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2905 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   5999550.4676 2114295.9601 37.7854267102234 -122.44530771900499 (37.7854267102234, -122.445307719005)
6354 98096 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 81 Frank Norris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6006843.26628 2115504.44745 37.789158511592 -122.420162558272 (37.789158511592, -122.420162558272)
6475 23884 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1750X Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6003258.4682 2113929.8349 37.7846323872704 -122.432452992684 (37.7846323872704, -122.432452992684)
6496 23490 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2500X Van Ness Ave 6 Median : Cutout 11 Tree 1 DPW 2     30 9   6005777.87956 2119177.1307599996 37.799182688783496 -122.424109961515 (37.7991826887835, -122.424109961515)
6740 39332 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
6750 21685 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1840 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/1999 12:00:00 AM 6 4x4   6003694.6838 2114582.3856 37.7864488534059 -122.43099042257299 (37.7864488534059, -122.430990422573)
6792 23871 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1499X Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003600.3539 2113692.9201 37.784001259600295 -122.43125326646499 (37.7840012596003, -122.431253266465)
6874 13090 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 724 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/26/2004 12:00:00 AM 12 3X3   6008885.9219 2120447.4555 37.8028456756355 -122.413444921903 (37.8028456756355, -122.413444921903)
6947 26936 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1529 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6002004.7416 2111860.8692 37.7788803585551 -122.436642312661 (37.7788803585551, -122.436642312661)
7053 23897 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1581 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/30/2006 12:00:00 AM 3 3X3   6003549.9307 2114010.8321 37.784871308404 -122.431450414863 (37.784871308404, -122.431450414863)
7067 28641 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 3 Median : Cutout 11 Tree 1 DPW 2     8 20   6003709.2011 2113267.9212 37.7828404869024 -122.43084635463 (37.7828404869024, -122.43084635463)
7387 98089 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007160.90241 2115572.1732 37.789362361841505 -122.41906838009899 (37.7893623618415, -122.419068380099)
7425 8168 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1160 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6002214.9627 2111253.4218 37.7772244047313 -122.435871600468 (37.7772244047313, -122.435871600468)
7475 28644 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 6 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003694.7628 2113348.3634 37.7830605429851 -122.430902047868 (37.7830605429851, -122.430902047868)
7481 21730 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1955 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1990 12:00:00 AM 6 3X3   6003249.1628 2114463.8768 37.786098203806205 -122.43252334451599 (37.7860982038062, -122.432523344516)
7927 13089 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 722 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235)
8037 12253 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 528 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2003 12:00:00 AM 6 3x3   6005030.2517 2110722.9994 37.7759275170107 -122.426094839447 (37.7759275170107, -122.426094839447)
8106 114661 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1603 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/27/2016 12:00:00 AM 3 3x3   6004477.5231 2114370.1159 37.7859103404926 -122.42826686028299 (37.7859103404926, -122.428266860283)
8518 18226 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1675 Post St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004172.0667 2114245.454 37.785550761919 -122.42931476245899 (37.785550761919, -122.429314762459)
8560 98097 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 81 Frank Norris St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6006875.6654 2115508.14993 37.789170503156704 -122.420050723983 (37.7891705031567, -122.420050723983)
8595 28648 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 10 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 6   6003548.747 2114394.8281 37.7859255976047 -122.43148193261601 (37.7859255976047, -122.431481932616)
8638 98095 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 81 Frank Norris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6006820.270769999 2115499.9051599996 37.789144743881295 -122.420241797518 (37.7891447438813, -122.420241797518)
8790 105143 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 432 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3 DPW for City Agency 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 634.767ms · Data source: data.sfgov.org