Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");