Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by qAddress

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
6092 46303 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
7478 46291 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
10371 46304 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
11759 46302 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
13945 46285 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
161630 136974 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Avila St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001080.18174 2119739.07113 37.800459273745105 -122.440405888327 (37.8004592737451, -122.440405888327)
30837 123696 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5995493.19231 2113537.8911 37.7831128208781 -122.45928967118799 (37.7831128208781, -122.459289671188)
155708 123695 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Clement St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5995508.22475 2113538.45627 37.7831152369297 -122.459237706338 (37.7831152369297, -122.459237706338)
159564 242778 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 McCoppin St 1 : 4 Tree 1 Private 1     4 Width 9ft   6006595.78841 2109152.55753 37.7717038182152 -122.420567728011 (37.7717038182152, -122.420567728011)
35801 215481 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994138.58821 2097841.54459 37.739936758872204 -122.462836916405 (37.7399367588722, -122.462836916405)
180262 215482 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5994118.54253 2097814.9092900003 37.7398624703831 -122.462904293614 (37.7398624703831, -122.462904293614)
38520 141758 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003941.7467 2113359.8855 37.7831061707931 -122.430048406845 (37.7831061707931, -122.430048406845)
39318 141761 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6003925.4266 2113468.4989 37.7834034717338 -122.430112618538 (37.7834034717338, -122.430112618538)
46868 141760 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6003934.4308 2113424.6033 37.783283455356795 -122.430078335144 (37.7832834553568, -122.430078335144)
53705 141759 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6003937.2446 2113390.8375 37.7831909022721 -122.43006619100001 (37.7831909022721, -122.430066191)
59836 141755 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003953.8461 2113272.9385 37.7828681212931 -122.430000343557 (37.7828681212931, -122.430000343557)
155018 141757 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6003947.6557 2113327.5266 37.7830176559931 -122.430025655042 (37.7830176559931, -122.430025655042)
161755 141754 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6003957.9028 2113249.5012 37.7828039980646 -122.429984636672 (37.7828039980646, -122.429984636672)
167840 141762 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6003923.1755 2113496.0743 37.7834790593899 -122.430122374293 (37.7834790593899, -122.430122374293)
170446 141756 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 HOLLIS ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003949.9068 2113305.5788 37.7829575203066 -122.43001630101801 (37.7829575203066, -122.430016301018)
164000 242590 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 10 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6000566.185219999 2102752.01252 37.75378784634879 -122.440965200093 (37.7537878463488, -122.440965200093)
11883 17495 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6002027.05349 2091378.7208900002 37.722642521627996 -122.43509980193001 (37.722642521628, -122.43509980193)
12993 19985 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100 STAIRWAY46 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40            
56999 198593 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013352.21579 2107122.2943 37.766507623566106 -122.397054279536 (37.7665076235661, -122.397054279536)
58597 198595 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013296.53525 2107120.49149 37.7664995737224 -122.397246743447 (37.7664995737224, -122.397246743447)
150160 198597 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013173.331180001 2107113.60808 37.766473813538106 -122.397672404268 (37.7664738135381, -122.397672404268)
181007 198596 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013207.26395 2107117.3176700003 37.7664858887413 -122.397555296343 (37.7664858887413, -122.397555296343)
181037 198594 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013331.88607 2107121.5339099998 37.766504403987796 -122.39712454356001 (37.7665044039878, -122.39712454356)
11239 17609 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004106.27078 2090068.65464 37.7191632136975 -122.42781910286999 (37.7191632136975, -122.42781910287)
12237 17610 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004083.7901099995 2090083.69021 37.7192032263241 -122.427897880781 (37.7192032263241, -122.427897880781)
12681 17608 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/26/1999 12:00:00 AM 40 6x9   6004130.9636 2090056.2016 37.7191304172171 -122.427732862395 (37.7191304172171, -122.427732862395)
14305 85794 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1001 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6010934.7813 2111463.5411 37.778292821216 -122.405721608986 (37.778292821216, -122.405721608986)
84787 17611 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3X3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
118411 17613 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
142590 17612 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
109476 19301 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100X Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   5995247.10654 2111496.409 37.7774933045144 -122.459993084378 (37.7774933045144, -122.459993084378)
120654 102761 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 100X Russ St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711)
22362 244426 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6005680.8792 2109772.4112 37.773354183173396 -122.423776541571 (37.7733541831734, -122.423776541571)
25504 244422 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005691.1562 2109690.8797 37.773130897486205 -122.423735193743 (37.7731308974862, -122.423735193743)
34532 244424 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005686.3603 2109729.9326 37.7732378565997 -122.42375456071301 (37.7732378565997, -122.423754560713)
62865 244423 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005687.7306 2109711.4339 37.7731871409862 -122.423748505092 (37.7731871409862, -122.423748505092)
68449 244328 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005669.917 2109835.444 37.7735266371926 -122.423818944241 (37.7735266371926, -122.423818944241)
69750 244330 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005665.121 2109878.6077 37.7736448835433 -122.42383860414199 (37.7736448835433, -122.423838604142)
76593 244327 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005673.3426 2109802.5573 37.773436531636 -122.42380475570499 (37.773436531636, -122.423804755705)
136512 244331 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005661.6953 2109906.0133 37.7737199393103 -122.423852403284 (37.7737199393103, -122.423852403284)
149269 244421 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005693.2117 2109673.0661 37.773082101669296 -122.423726816669 (37.7730821016693, -122.423726816669)
152904 244425 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005682.2494 2109755.2828 37.7733072300695 -122.423770583723 (37.7733072300695, -122.423770583723)
157190 244329 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005667.8615 2109858.0536 37.773588601656996 -122.423827662517 (37.773588601657, -122.423827662517)
121063 16605 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 101 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2014 12:00:00 AM 18 3X3 Permit Number 773154 6002878.7558281 2107677.2386141997 37.7674427729111 -122.433319725194 (37.7674427729111, -122.433319725194)
10917 17498 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 2X2   6002093.54294 2091384.31052 37.72266164479 -122.43487036238501 (37.72266164479, -122.434870362385)
11596 17497 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 2X2   6002079.41309 2091392.13948 37.7226823390961 -122.43491976573401 (37.7226823390961, -122.434919765734)
12309 17496 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/23/2003 12:00:00 AM 3 2X2   6002048.59392 2091411.2062099997 37.7227329421421 -122.43502766371401 (37.7227329421421, -122.435027663714)
120689 112514 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1014 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5992342.97239 2113476.2606 37.7827619817135 -122.47018356398998 (37.7827619817135, -122.47018356399)
10375 17615 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1018 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x3   6004156.70512 2090037.9094200002 37.7190816469907 -122.427642581247 (37.7190816469907, -122.427642581247)
102960 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 46 101X Laguna St 1 Front Yard : Yard 7 Tree 1 Private 1           6005198.60314 2109385.58511 37.772264815602 -122.42541726943199 (37.772264815602, -122.425417269432)
1192 119753 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1196 119750 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1202 119754 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1204 119749 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1213 119747 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1223 119752 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1227 119736 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1233 119757 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
28574 244375 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005617.5038 2109823.1115 37.773489816144796 -122.423999372272 (37.7734898161448, -122.423999372272)
45981 244376 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005617.5038 2109799.1317 37.7734239734056 -122.423997666684 (37.7734239734056, -122.423997666684)
56950 244345 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005607.2268 2109894.3659 37.773684883292105 -122.424039990106 (37.7736848832921, -122.424039990106)
66611 244468 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005635.3174 2109670.3256 37.7730713086411 -122.423926885709 (37.7730713086411, -122.423926885709)
68766 244467 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005631.8918 2109690.1946 37.7731256707262 -122.423940148458 (37.7731256707262, -122.423940148458)
73396 244466 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005631.2066 2109707.3231 37.7731726627699 -122.423943736898 (37.7731726627699, -122.423943736898)
129691 244344 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005605.8565 2109917.6606 37.773748767543104 -122.424046387097 (37.7737487675431, -122.424046387097)
155187 244456 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005624.3552 2109760.7639 37.773319011501705 -122.42397123777799 (37.7733190115017, -122.423971237778)
161664 244455 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005622.2998 2109777.2072 37.7733640447919 -122.423979517231 (37.7733640447919, -122.423979517231)
174364 244465 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005629.1512 2109732.6732 37.773242151986 -122.423952649806 (37.773242151986, -122.423952649806)
176821 244373 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005612.0227 2109867.6455 37.7736117862994 -122.424021499783 (37.7736117862994, -122.424021499783)
187415 244374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005614.0781 2109847.0914 37.7735554657504 -122.42401292788901 (37.7735554657504, -122.424012927889)
30655 180517 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6004131.62894 2090104.3716099998 37.719262719168896 -122.42773399285299 (37.7192627191689, -122.427733992853)
149925 180515 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6004177.13289 2090077.86698 37.7191925171931 -122.427574815527 (37.7191925171931, -122.427574815527)
173144 180516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6004155.91588 2090090.6053799998 37.7192262939354 -122.427649061763 (37.7192262939354, -122.427649061763)
54259 180512 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004254.69534 2090025.2040000001 37.71905230300529 -122.427302962162 (37.7190523030053, -122.427302962162)
65179 180513 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004235.638830001 2090036.93621 37.719083439333204 -122.427369668478 (37.7190834393332, -122.427369668478)
168800 180514 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 4ft   6004210.581680001 2090053.8218900003 37.7191283865346 -122.427457483699 (37.7191283865346, -122.427457483699)
91459 119712 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 5 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
101446 119713 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 6 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
103389 119708 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 1 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
108290 119716 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 9 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
110953 119719 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 12 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
122353 119718 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 11 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
124457 119717 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 10 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128093 119709 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 2 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128531 119710 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 3 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
141876 119711 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 4 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
145232 119714 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 102x Octavia St Frontage East 7 Median : Cutout 11 Tree 1 DPW 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
12487 17616 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1030 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6004194.38835 2090014.0443400003 37.719018250172 -122.42751062553499 (37.719018250172, -122.427510625535)
19037 7013 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1031 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/1997 12:00:00 AM 8 3X3   6002426.7807 2110189.6116 37.774315477420295 -122.435062751747 (37.7743154774203, -122.435062751747)
8472 46875 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1031 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2002 12:00:00 AM 10 3x4 Permit Number 44938 6009178.55411 2118013.02984 37.7961777714378 -122.412260097639 (37.7961777714378, -122.412260097639)
96794 137038 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1034 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009796.46818 2116817.7113799998 37.792930371678096 -122.41003755358801 (37.7929303716781, -122.410037553588)
158256 137041 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1034 Sacramento St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.41037782017901 (37.7928873337267, -122.410377820179)
166414 137039 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1034 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009772.70737 2116813.88249 37.7929185267084 -122.410119497111 (37.7929185267084, -122.410119497111)

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