Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174631 | 174631 | 212880 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1856 17th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5990966.0543 | 2102781.91653 | 37.7533184991505 | -122.474166496407 | (37.7533184991505, -122.474166496407) | |||
175620 | 175620 | 117840 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983808.599090001 | 2111637.58628 | 37.777216427782896 | -122.499572493795 | (37.7772164277829, -122.499572493795) | |||
176432 | 176432 | 236680 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000047.77826 | 2100801.34251 | 37.748402239176706 | -122.442617915704 | (37.7484022391767, -122.442617915704) | |||
176572 | 176572 | 178833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6001567.75342 | 2086664.56423 | 37.709672405530796 | -122.43635027774401 | (37.7096724055308, -122.436350277744) | |||
178112 | 178112 | 178839 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 921 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001840.757 | 2086804.7866200001 | 37.7100729338953 | -122.435416754499 | (37.7100729338953, -122.435416754499) | |||
178238 | 178238 | 212560 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 121 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993496.587590001 | 2096822.61338 | 37.7371020301329 | -122.464982687119 | (37.7371020301329, -122.464982687119) | |||
181727 | 181727 | 212396 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991908.91474 | 2095741.00543 | 37.734040533740796 | -122.47039319289 | (37.7340405337408, -122.47039319289) | |||
183711 | 183711 | 178832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 26 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002753.4939 | 2087126.6504400002 | 37.711008496830004 | -122.43228513165 | (37.71100849683, -122.43228513165) | |||
1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
23970 | 23970 | 212728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1287 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992976.77161 | 2106756.7423799997 | 37.764348608513 | -122.467502106342 | (37.764348608513, -122.467502106342) | |||
24246 | 24246 | 123150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 530 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5992860.06337 | 2111844.7190400003 | 37.778312093174 | -122.468275933095 | (37.778312093174, -122.468275933095) | |||
24615 | 24615 | 212913 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1805 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992793.90733 | 2103137.66659 | 37.7544010140192 | -122.467871330222 | (37.7544010140192, -122.467871330222) | |||
25745 | 25745 | 237671 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6003229.55375 | 2107394.7071700003 | 37.7666869052036 | -122.432086185446 | (37.7666869052036, -122.432086185446) | |||
26427 | 26427 | 236953 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 188 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007061.54193 | 2097987.47414 | 37.741073305877 | -122.41816495174601 | (37.741073305877, -122.418164951746) | |||
28498 | 28498 | 218176 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1450 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992814.7731 | 2097288.8664 | 37.7383429066102 | -122.467373901707 | (37.7383429066102, -122.467373901707) | |||
28584 | 28584 | 196158 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 390x Hampshire St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6010042.156719999 | 2106501.92637 | 37.764619417770206 | -122.408459468244 | (37.7646194177702, -122.408459468244) | |||
31470 | 31470 | 236880 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5999599.46075 | 2106928.4775400003 | 37.7652002791041 | -122.44460850030701 | (37.7652002791041, -122.444608500307) | |||
32650 | 32650 | 236949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 412 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006925.33494 | 2097909.09051 | 37.7408504143261 | -122.418630350009 | (37.7408504143261, -122.418630350009) | |||
33076 | 33076 | 214242 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999236.96696 | 2095747.8899 | 37.734480414624706 | -122.445058430207 | (37.7344804146247, -122.445058430207) | |||
34488 | 34488 | 237867 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4014 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6003831.33798 | 2100728.37019 | 37.748416826181 | -122.42952924738998 | (37.748416826181, -122.42952924739) | |||
34878 | 34878 | 212667 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 412 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | |||
35635 | 35635 | 218057 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5991870.78261 | 2095844.7512599998 | 37.73432318885929 | -122.47053257972401 | (37.7343231888593, -122.470532579724) | |||
36599 | 36599 | 236814 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5997128.391419999 | 2106071.17733 | 37.7627050363405 | -122.453093398751 | (37.7627050363405, -122.453093398751) | |||
38115 | 38115 | 123151 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5992855.02904 | 2111985.99608 | 37.7786997108705 | -122.46830362906 | (37.7786997108705, -122.46830362906) | |||
38804 | 38804 | 218054 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991875.535130001 | 2095741.56423 | 37.7340401380298 | -122.470508636163 | (37.7340401380298, -122.470508636163) | |||
39845 | 39845 | 236879 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5999597.94254 | 2106903.1548099997 | 37.7651306625862 | -122.44461193121599 | (37.7651306625862, -122.444611931216) | |||
42175 | 42175 | 214239 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999201.62865 | 2095749.0512700002 | 37.7344815864478 | -122.445180689449 | (37.7344815864478, -122.445180689449) | |||
42317 | 42317 | 135828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.798941486106294 | -122.414133314422 | (37.7989414861063, -122.414133314422) | |||
43071 | 43071 | 236296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 131 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006185.48176 | 2102196.43125 | 37.7525807960811 | -122.42149290110201 | (37.7525807960811, -122.421492901102) | |||
43113 | 43113 | 236325 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3332 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007320.64846 | 2105014.6843 | 37.760383011974795 | -122.41776703501499 | (37.7603830119748, -122.417767035015) | |||
43964 | 43964 | 123532 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3 05th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5994221.03215 | 2115580.18797 | 37.7886471906725 | -122.46383908202299 | (37.7886471906725, -122.463839082023) | |||
44881 | 44881 | 235864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 639 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009871.95446 | 2105109.50281 | 37.7607866061324 | -122.408949903639 | (37.7607866061324, -122.408949903639) | |||
45330 | 45330 | 212729 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1278 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5993026.02058 | 2106790.52899 | 37.764444220853896 | -122.46733422631 | (37.7644442208539, -122.46733422631) | |||
47299 | 47299 | 236849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1444 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 5996862.52602 | 2106356.19776 | 37.76347238916011 | -122.454033513157 | (37.7634723891601, -122.454033513157) | |||
47453 | 47453 | 237868 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4014 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6003811.191869999 | 2100726.09136 | 37.7484094283511 | -122.429598749699 | (37.7484094283511, -122.429598749699) | |||
48234 | 48234 | 196302 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011407.60626 | 2111629.45684 | 37.7787748169373 | -122.404097603449 | (37.7787748169373, -122.404097603449) | |||
49544 | 49544 | 236876 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 64 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5999551.33857 | 2106808.63327 | 37.764868470628 | -122.444766327708 | (37.764868470628, -122.444766327708) | |||
50433 | 50433 | 123122 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 624 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5992573.24713 | 2111201.55414 | 37.7765295670124 | -122.46922130393601 | (37.7765295670124, -122.469221303936) | |||
50576 | 50576 | 236324 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3310 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007441.00953 | 2105022.38069 | 37.7604109170425 | -122.41735130632601 | (37.7604109170425, -122.417351306326) | |||
51070 | 51070 | 236950 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 237 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006734.3645 | 2097735.5512599996 | 37.740363160727895 | -122.419278348426 | (37.7403631607279, -122.419278348426) | |||
51638 | 51638 | 135831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008642.5114400005 | 2119028.50949 | 37.7989359337052 | -122.41418680068199 | (37.7989359337052, -122.414186800682) | |||
51917 | 51917 | 235852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6008657.32082 | 2102253.80275 | 37.7528773879975 | -122.412948881185 | (37.7528773879975, -122.412948881185) | |||
51973 | 51973 | 236847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1440 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 5996859.18306 | 2106388.66419 | 37.7635613420159 | -122.454047420273 | (37.7635613420159, -122.454047420273) | |||
52281 | 52281 | 178707 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6001240.954969999 | 2090204.3189700001 | 37.7193732098917 | -122.437733096898 | (37.7193732098917, -122.437733096898) | |||
52951 | 52951 | 214244 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999262.24529 | 2095747.3644599998 | 37.7344804146383 | -122.44497099721902 | (37.7344804146383, -122.444970997219) | |||
55696 | 55696 | 196277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015638.97442 | 2096745.3057 | 37.738141628436296 | -122.38842036162501 | (37.7381416284363, -122.388420361625) | |||
57508 | 57508 | 135835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008609.072240001 | 2119027.30535 | 37.7989307491201 | -122.41430242651899 | (37.7989307491201, -122.414302426519) | |||
57961 | 57961 | 218056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 San Rafael Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991873.67484 | 2095791.69493 | 37.7341776767595 | -122.470518717562 | (37.7341776767595, -122.470518717562) | |||
58383 | 58383 | 236455 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 591 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5999875.02699 | 2107475.1639400003 | 37.7667170639599 | -122.443694663204 | (37.7667170639599, -122.443694663204) | |||
60157 | 60157 | 196303 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 249 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011469.591109999 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | |||
61225 | 61225 | 236319 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2870 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6008996.29845 | 2103350.92649 | 37.7559088650107 | -122.41185414906602 | (37.7559088650107, -122.411854149066) | |||
61813 | 61813 | 218059 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5991870.61406 | 2095888.6752900002 | 37.7344437834486 | -122.47053636046302 | (37.7344437834486, -122.470536360463) | |||
62696 | 62696 | 236851 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1448 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5996862.21496 | 2106323.8076400002 | 37.7633834363127 | -122.454032249585 | (37.7633834363127, -122.454032249585) | |||
62925 | 62925 | 135836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008591.776769999 | 2119025.88036 | 37.7989258649019 | -122.41436217388001 | (37.7989258649019, -122.41436217388) | |||
63946 | 63946 | 212726 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1273 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5992975.277419999 | 2106809.7864900003 | 37.7644941673851 | -122.46751113193899 | (37.7644941673851, -122.467511131939) | |||
64656 | 64656 | 218269 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1450 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 5992804.79849 | 2097276.3121700003 | 37.7383078600075 | -122.467407476082 | (37.7383078600075, -122.467407476082) | |||
65897 | 65897 | 218053 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 5991877.93817 | 2095717.1940099997 | 37.7339733624818 | -122.47049855388398 | (37.7339733624818, -122.470498553884) | |||
66260 | 66260 | 236951 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 243 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006714.11577 | 2097699.01901 | 37.740261710903 | -122.419345769708 | (37.740261710903, -122.419345769708) | |||
66707 | 66707 | 236454 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 591 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5999868.57016 | 2107489.3560900004 | 37.7667556637821 | -122.443718015895 | (37.7667556637821, -122.443718015895) | |||
67337 | 67337 | 212892 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1485 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5991130.51563 | 2105331.7867 | 37.7603292954688 | -122.473783764707 | (37.7603292954688, -122.473783764707) | |||
67673 | 67673 | 196304 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 249 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011481.859569999 | 2111700.79426 | 37.7789748414544 | -122.403845751896 | (37.7789748414544, -122.403845751896) | |||
71627 | 71627 | 121889 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.78684768786071 | -122.47659987163799 | (37.7868476878607, -122.476599871638) | |||
71872 | 71872 | 236326 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3372 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007047.05423 | 2104999.9665 | 37.7603272000518 | -122.41871222879101 | (37.7603272000518, -122.418712228791) | |||
74862 | 74862 | 123152 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992856.05195 | 2111969.64084 | 37.7786548628959 | -122.46829890029899 | (37.7786548628959, -122.468298900299) | |||
75053 | 75053 | 124628 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 739 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5996019.75868 | 2113776.29204 | 37.7837976659747 | -122.457485230667 | (37.7837976659747, -122.457485230667) | |||
75616 | 75616 | 218058 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5991870.26774 | 2095854.9254400001 | 37.7343510948266 | -122.470535100539 | (37.7343510948266, -122.470535100539) | |||
75682 | 75682 | 237536 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6004059.79149 | 2102981.8423599997 | 37.7546172658849 | -122.42889989461399 | (37.7546172658849, -122.428899894614) | |||
115832 | 115832 | 218055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 San Rafael Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5991874.63554 | 2095768.08089 | 37.734112894094295 | -122.470513676886 | (37.7341128940943, -122.470513676886) | |||
130518 | 130518 | 235878 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1316 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6010051.08389 | 2101493.8163099997 | 37.75086877198721 | -122.408075374074 | (37.7508687719872, -122.408075374074) | |||
131356 | 131356 | 120335 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 West Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5988814.20904 | 2115019.72522 | 37.7867952605979 | -122.48250458154399 | (37.7867952605979, -122.482504581544) | |||
131516 | 131516 | 236850 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1448 Willard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 5996862.16891 | 2106339.09686 | 37.7634254139725 | -122.454033513142 | (37.7634254139725, -122.454033513142) | |||
132743 | 132743 | 218060 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5991870.79201 | 2095914.4431200002 | 37.7345145457153 | -122.470537621341 | (37.7345145457153, -122.470537621341) | |||
133112 | 133112 | 218075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992618.92703 | 2095332.80725 | 37.7329607501197 | -122.467908801376 | (37.7329607501197, -122.467908801376) | |||
148285 | 148285 | 212893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1485 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991128.893730001 | 2105319.02448 | 37.760294159865 | -122.47378844299699 | (37.760294159865, -122.473788442997) | |||
148455 | 148455 | 235898 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3623 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6005449.1497599995 | 2104867.0331900003 | 37.7598721008326 | -122.424229185527 | (37.7598721008326, -122.424229185527) | |||
148881 | 148881 | 212582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 698 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5996839.75246 | 2094438.5528099998 | 37.7307481750864 | -122.453251853909 | (37.7307481750864, -122.453251853909) | |||
148941 | 148941 | 218063 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 210 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 5992122.20278 | 2095338.1764900002 | 37.7329467962506 | -122.46962648127399 | (37.7329467962506, -122.469626481274) | |||
149355 | 149355 | 236846 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1432 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5996858.16965 | 2106410.1620099996 | 37.7636203114386 | -122.454052478047 | (37.7636203114386, -122.454052478047) | |||
149486 | 149486 | 212730 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1280 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5993644.93025 | 2106798.8325400003 | 37.7645027298541 | -122.465194208543 | (37.7645027298541, -122.465194208543) | |||
151376 | 151376 | 122064 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5 17th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 5990491.562030001 | 2115003.9867599998 | 37.7868494825782 | -122.476700244886 | (37.7868494825782, -122.476700244886) | |||
155500 | 155500 | 214241 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999225.40751 | 2095748.55696 | 37.734481586442705 | -122.44509844284201 | (37.7344815864427, -122.445098442842) | |||
155763 | 155763 | 135834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | |||
157748 | 157748 | 236878 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 64 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 5999563.5863 | 2106825.17196 | 37.764914580669206 | -122.444725154952 | (37.7649145806692, -122.444725154952) | |||
162963 | 162963 | 236954 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6007075.87853 | 2098013.0701200003 | 37.7411443936867 | -122.418117195053 | (37.7411443936867, -122.418117195053) | |||
163614 | 163614 | 236293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 350 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006180.03828 | 2101063.55318 | 37.7494698657552 | -122.421431278627 | (37.7494698657552, -122.421431278627) | |||
163718 | 163718 | 236295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 137 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6006186.4686 | 2102179.00145 | 37.752532993502 | -122.421488250687 | (37.752532993502, -122.421488250687) | |||
164655 | 164655 | 235861 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 639 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009872.79585 | 2105074.27 | 37.7606899119429 | -122.40894450769301 | (37.7606899119429, -122.408944507693) | |||
165816 | 165816 | 236815 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 64 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5997122.17196 | 2106111.1918 | 37.7628145494616 | -122.453117798252 | (37.7628145494616, -122.453117798252) | |||
166240 | 166240 | 124629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 749 Euclid Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5995991.233580001 | 2113774.73723 | 37.7837917583619 | -122.457583803683 | (37.7837917583619, -122.457583803683) | |||
168056 | 168056 | 214243 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5999250.24874 | 2095747.61382 | 37.734480414633104 | -122.44501249102899 | (37.7344804146331, -122.445012491029) | |||
168245 | 168245 | 196151 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6013517.53008 | 2104664.07423 | 37.7597670932918 | -122.396310171496 | (37.7597670932918, -122.396310171496) | |||
171671 | 171671 | 218064 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 210 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5992124.80439 | 2095323.2393099999 | 37.732905932857896 | -122.46961639989999 | (37.7329059328579, -122.4696163999) | |||
173336 | 173336 | 237649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 679 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6003711.85338 | 2104310.8313 | 37.7582466544715 | -122.430197963459 | (37.7582466544715, -122.430197963459) | |||
173765 | 173765 | 235863 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 639 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6009872.27365 | 2105099.65666 | 37.7607595887132 | -122.408948104977 | (37.7607595887132, -122.408948104977) | |||
173772 | 173772 | 237648 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 679 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6003716.06035 | 2104294.93952 | 37.758203257705105 | -122.430182280206 | (37.7582032577051, -122.430182280206) | |||
174358 | 174358 | 236845 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1422 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5996850.39463 | 2106492.95375 | 37.763847190616204 | -122.454085349179 | (37.7638471906162, -122.454085349179) | |||
174991 | 174991 | 218052 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5991877.38041 | 2095690.7080400002 | 37.733900606415 | -122.470498553874 | (37.733900606415, -122.470498553874) | |||
179767 | 179767 | 214240 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999212.99159 | 2095749.24183 | 37.7344827582634 | -122.44514141784799 | (37.7344827582634, -122.445141417848) | |||
180984 | 180984 | 235862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 639 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6009873.31979 | 2105087.20622 | 37.7607254612239 | -122.408943608358 | (37.7607254612239, -122.408943608358) | |||
180998 | 180998 | 212581 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5996847.55389 | 2094438.3899599998 | 37.7307481750846 | -122.45322487153601 | (37.7307481750846, -122.453224871536) |
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");