Street_Tree_List

Data source: data.sfgov.org

2,671 rows where qSpecies = 35 sorted by PermitNotes

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
9626 173611 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 3779 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6005304.0 2101328.0 37.7501465436699 -122.424479453971 (37.7501465436699, -122.424479453971)
9842 12410 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1610X Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/13/1989 12:00:00 AM 7 4X4   6004460.5933 2114341.7023 37.78583136591 -122.42832340690398 (37.78583136591, -122.428323406904)
9845 12411 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1610X Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/13/1989 12:00:00 AM 6 4X4   6004443.6433 2114336.5232 37.785816186279504 -122.42838167990801 (37.7858161862795, -122.428381679908)
9984 106984 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1737-1795 Post St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2012 12:00:00 AM 3     6003775.6189 2114189.0991 37.7853735733153 -122.430682332536 (37.7853735733153, -122.430682332536)
10132 18098 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 3016 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/31/2017 11:58:00 AM 3     5999364.6601 2114676.4418 37.7864608055495 -122.445977930803 (37.7864608055495, -122.445977930803)
10144 173880 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1922 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998581.0 2110425.0 37.7747426714218 -122.448382913575 (37.7747426714218, -122.448382913575)
10293 86369 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1281 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5987992.2676 2106611.2343 37.7636600473858 -122.484731221945 (37.7636600473858, -122.484731221945)
10326 86251 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2230 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988566.0868 2100132.7531 37.7459052793749 -122.48227190373699 (37.7459052793749, -122.482271903737)
10332 86580 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2539 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2007 12:00:00 AM 3 3x3   5987975.8922 2098002.1559 37.740020874126394 -122.484156469463 (37.7400208741264, -122.484156469463)
10336 86256 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1754 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988460.2167 2103365.3979 37.75477510171329 -122.482874855725 (37.7547751017133, -122.482874855725)
10350 86577 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2519 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2007 12:00:00 AM 3 3x3   5987971.7931 2098127.9672 37.740366080244 -122.484179866453 (37.740366080244, -122.484179866453)
10354 95012 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 107 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/1998 12:00:00 AM 3 3x3   6010407.8674 2087313.2581 37.7119519253908 -122.40584279071301 (37.7119519253908, -122.405842790713)
10357 85931 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1686 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988131.3934 2103830.0344 37.756031730146 -122.48404607344901 (37.756031730146, -122.484046073449)
10374 85990 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2234 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987638.7841 2100062.768 37.7456591364178 -122.485473213008 (37.7456591364178, -122.485473213008)
10379 86560 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1887 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/28/2006 12:00:00 AM 6 3x3   5987821.2541 2102469.8936 37.7522790893532 -122.48501883929899 (37.7522790893532, -122.485018839299)
10400 94994 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 82 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6010574.5301 2087274.9346 37.7118560160688 -122.405264057289 (37.7118560160688, -122.405264057289)
10403 95015 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 83 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3     6010521.9467 2087254.8816 37.711798014587295 -122.40544438972 (37.7117980145873, -122.40544438972)
10407 85987 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2286 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987649.8793 2099748.6884 37.744797403731106 -122.485411804387 (37.7447974037311, -122.485411804387)
10410 86450 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2362 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/29/2006 12:00:00 AM 3 3x3   5987982.1495 2099214.8079 37.7433508614418 -122.4842237451 (37.7433508614418, -122.4842237451)
10421 86100 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2628 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988972.7801 2097431.8111 37.738512846904996 -122.48066793928899 (37.738512846905, -122.480667939289)
10438 95023 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 45 Leland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6010750.3281 2087136.1233 37.711484695229295 -122.404646681546 (37.7114846952293, -122.404646681546)
10444 86261 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1726 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988455.289 2103558.6714 37.7553054920736 -122.482906060899 (37.7553054920736, -122.482906060899)
10450 86208 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2447 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2007 12:00:00 AM 3 3x3   5988885.905 2098662.6727 37.741887422325 -122.48105840788601 (37.741887422325, -122.481058407886)
10452 86308 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1503 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988358.1168 2105058.904 37.7594190709864 -122.48335207735599 (37.7594190709864, -122.483352077356)
10454 86246 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2292X 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988581.0227 2099729.0585 37.744797709288605 -122.48219068753401 (37.7447977092886, -122.482190687534)
10461 92319 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 35 2788 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)

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 1322.137ms · Data source: data.sfgov.org