trees
1,985 rows where qSpecies_id = 83 sorted by PlantDate
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16436 | 142218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 CENTRAL AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999746.1848 | 2109905.9886 | 37.773384146155 | -122.44431500945 | (37.773384146155, -122.44431500945) | 15 | 5 | 11 | 29492 | 16 | |||
16463 | 106806 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | 11 | 6 | 1 | 54 | 31 | ||||
16514 | 136241 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006661.22108 | 2116996.66069 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | 13 | 9 | 10 | 28858 | 32 | |||
17139 | 261451 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 295 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006893 | 2095807 | 37.7350767190782 | -122.41859312449 | (37.7350767190782, -122.41859312449) | 2 | 7 | 7 | 28859 | 2 | ||||
17262 | 258984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 784344 | 6010137 | 2099925 | 37.7465659576292 | -122.407667663761 | (37.7465659576292, -122.407667663761) | 2 | 7 | 7 | 28859 | 2 | |||
17469 | 239268 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 43 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006498.06002 | 2108217.35728 | 37.769130472909 | -122.420839370946 | (37.769130472909, -122.420839370946) | 8 | 4 | 7 | 28853 | 19 | |||
17729 | 197162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | 10 | 3 | 8 | 58 | 1 | |||
17844 | 239290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009903.27648 | 2104148.96892 | 37.7581509513321 | -122.408773807391 | (37.7581509513321, -122.408773807391) | 2 | 4 | 7 | 28859 | 19 | |||
17871 | 244081 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 43 | Width 0ft | 5998790.9441 | 2109040.9235 | 37.7709543519473 | -122.447557026238 | (37.7709543519473, -122.447557026238) | 15 | 5 | 11 | 29492 | 9 | ||
18403 | 238853 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007982.71274 | 2096562.40282 | 37.7372121799922 | -122.414879032248 | (37.7372121799922, -122.414879032248) | 2 | 7 | 7 | 28859 | 2 | |||
18559 | 70412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | 9 | 7 | 7 | 309 | 5 | |||
18577 | 147771 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 275 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993980.24137 | 2113705.13134 | 37.7834849172426 | -122.464535973179 | (37.7834849172426, -122.464535973179) | 11 | 6 | 2 | 54 | 11 | |||
18940 | 137981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1940 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002965.4976 | 2115097.1921 | 37.7878210367847 | -122.433550025903 | (37.7878210367847, -122.433550025903) | 13 | 9 | 11 | 29490 | 27 | |||
19096 | 73459 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6010582.51713 | 2106716.25151 | 37.7652381522352 | -122.406605601283 | (37.7652381522352, -122.406605601283) | 8 | 4 | 8 | 28853 | 19 | |||
19125 | 72279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | 11 | 6 | 2 | 55 | 26 | |||
19495 | 102487 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | 15 | 5 | 11 | 29492 | 16 | |||
19522 | 75060 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010594.46043 | 2106517.2504 | 37.7646924085388 | -122.406550267789 | (37.7646924085388, -122.406550267789) | 8 | 4 | 8 | 28853 | 19 | |||
19617 | 78383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | 10 | 3 | 8 | 58 | 1 | |||
20112 | 213955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | 9 | 8 | 6 | 28861 | 24 | |||
20240 | 239310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005491.56971 | 2101034.94567 | 37.7493524745442 | -122.42380999086 | (37.7493524745442, -122.42380999086) | 2 | 4 | 5 | 28859 | 19 | |||
20465 | 193326 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.37458 | 2102621.55349 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | 10 | 3 | 8 | 28856 | 29 | |||
20523 | 139996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 450 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005498.173 | 2111711.6583 | 37.77866856873 | -122.424546518451 | (37.77866856873, -122.424546518451) | 7 | 9 | 11 | 28852 | 41 | |||
20596 | 197113 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.400407248893 | (37.7547087979762, -122.400407248893) | 10 | 3 | 8 | 28856 | 29 | |||
20652 | 239344 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 221 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010109.73807 | 2099963.72008 | 37.746670748365 | -122.407764662809 | (37.746670748365, -122.407764662809) | 2 | 7 | 7 | 28859 | 2 | |||
20864 | 240184 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3371 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004431.11432 | 2106566.00014 | 37.7644795237217 | -122.427871135859 | (37.7644795237217, -122.427871135859) | 8 | 4 | 5 | 28862 | 3 | |||
20922 | 181803 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1915 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986942.1793 | 2099588.0871 | 37.7443151796952 | -122.487847067129 | (37.7443151796952, -122.487847067129) | 1 | 8 | 3 | 29491 | 35 | |||
21171 | 197125 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | 10 | 3 | 8 | 58 | 1 | |||
21384 | 239247 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | 2 | 4 | 7 | 28859 | 19 | |||
21391 | 16673 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002873.2969 | 2106860.82122 | 37.7652007800214 | -122.433280262977 | (37.7652007800214, -122.433280262977) | 15 | 5 | 5 | 28862 | 3 | |||
21589 | 136245 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | 13 | 9 | 10 | 28858 | 21 | |||
21693 | 197124 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 12 | : | Tree | Private 2 | 3 | Width 4ft | 6013733.0286 | 2100130.55294 | 37.7473310072149 | -122.395247287949 | (37.7473310072149, -122.395247287949) | 10 | 3 | 8 | 58 | 1 | |||
21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
21724 | 239356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.424877716331 | (37.7429522432585, -122.424877716331) | 2 | 7 | 5 | 63 | 22 | |||
21798 | 140393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002743.2077 | 2113356.8165 | 37.7830297920416 | -122.434194640623 | (37.7830297920416, -122.434194640623) | 15 | 9 | 11 | 29490 | 41 | |||
21845 | 179297 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004358.25207 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | 9 | 7 | 6 | 28861 | 5 | |||
21903 | 138448 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003221.0376 | 2114171.7858 | 37.7852946007927 | -122.432599778439 | (37.7852946007927, -122.432599778439) | 13 | 9 | 11 | 29490 | 13 | |||
21998 | 110495 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003598.79471 | 2092490.01573 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | 9 | 7 | 6 | 28861 | 5 | |||
22297 | 123102 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992511.21682 | 2112680.96666 | 37.7805880471465 | -122.469543602377 | (37.7805880471465, -122.469543602377) | 11 | 6 | 2 | 54 | 11 | |||
22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
22548 | 10416 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.445280397708 | (37.7701488573322, -122.445280397708) | 15 | 5 | 11 | 29492 | 9 | |||
22596 | 213938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992850.99558 | 2098086.47375 | 37.7405350265634 | -122.467306643206 | (37.7405350265634, -122.467306643206) | 1 | 8 | 4 | 59 | 40 | |||
23046 | 136230 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | 13 | 9 | 1 | 57 | 17 | |||
23079 | 240160 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | 15 | 5 | 11 | 29492 | 12 | |||
23216 | 136209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3501 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997993.27095 | 2115789.6423 | 37.7894389544021 | -122.450802865961 | (37.7894389544021, -122.450802865961) | 11 | 6 | 1 | 54 | 31 | |||
23672 | 247568 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 322 Alemany Blvd | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.7340714901943 | -122.412356334971 | (37.7340714901943, -122.412356334971) | 10 | 7 | 7 | 28859 | 2 | |||
23953 | 213964 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | 9 | 8 | 6 | 28861 | 24 | |||
24392 | 138122 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003040.5439 | 2114556.186 | 37.7863398290166 | -122.433251707831 | (37.7863398290166, -122.433251707831) | 13 | 9 | 11 | 29490 | 27 | |||
24628 | 239259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 455 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005530.597 | 2101040.15381 | 37.749368977999 | -122.423675403717 | (37.749368977999, -122.423675403717) | 2 | 4 | 5 | 28859 | 19 | |||
24907 | 136189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002539.896 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | 13 | 9 | 1 | 57 | 17 | |||
24941 | 239241 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | 10 | 4 | 8 | 28859 | 19 | |||
25528 | 239279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006490.03164 | 2104559.30004 | 37.7590858550479 | -122.420607431291 | (37.7590858550479, -122.420607431291) | 2 | 4 | 7 | 28859 | 19 | |||
25557 | 197109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | 10 | 3 | 8 | 28856 | 29 | ||||
26224 | 111868 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
26281 | 213989 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.470083438513 | (37.7399257259925, -122.470083438513) | 1 | 8 | 4 | 59 | 40 | |||
26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
26708 | 240143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.7630981164972 | -122.449494935145 | (37.7630981164972, -122.449494935145) | 15 | 5 | 11 | 29492 | 9 | |||
26875 | 240157 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 563 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998602.31996 | 2105951.33852 | 37.7624603514868 | -122.447986997796 | (37.7624603514868, -122.447986997796) | 15 | 5 | 11 | 29492 | 9 | |||
27068 | 240206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003903.54766 | 2097252.33034 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | 2 | 7 | 5 | 63 | 7 | |||
27070 | 179328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | 9 | 7 | 6 | 28861 | 5 | |||
27479 | 136226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | 13 | 9 | 1 | 57 | 17 | |||
27515 | 139278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 725 FULTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004349.2802 | 2111499.4808 | 37.7780210326226 | -122.428505855992 | (37.7780210326226, -122.428505855992) | 7 | 9 | 11 | 28852 | 10 | |||
27533 | 138455 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.7872071991092 | -122.433596947338 | (37.7872071991092, -122.433596947338) | 13 | 9 | 11 | 29490 | 27 | |||
27648 | 21211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
27834 | 138037 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | 13 | 9 | 11 | 29490 | 27 | |||
28051 | 240145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.449469012203 | (37.7629937870534, -122.449469012203) | 15 | 5 | 11 | 29492 | 9 | |||
28070 | 120249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.7863104293457 | -122.484043303996 | (37.7863104293457, -122.484043303996) | 11 | 6 | 1 | 55 | 33 | |||
28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
28368 | 255602 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 317 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006745 | 2104248 | 37.7582454635603 | -122.419703539884 | (37.7582454635603, -122.419703539884) | 2 | 4 | 7 | 28859 | 19 | ||||
28462 | 7316 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002972.25432 | 2115230.97031 | 37.7881887410682 | -122.433536213059 | (37.7881887410682, -122.433536213059) | 13 | 9 | 1 | 29490 | 27 | |||
28482 | 142842 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.7893467921177 | -122.420526537815 | (37.7893467921177, -122.420526537815) | 13 | 9 | 10 | 28858 | 21 | |||
28645 | 111869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
28724 | 197143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012876.39378 | 2089220.96781 | 37.7173278619583 | -122.397444511578 | (37.7173278619583, -122.397444511578) | 10 | 3 | 8 | 58 | 1 | |||
29410 | 138128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 FILLMORE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003016.992 | 2114720.1259 | 37.7867886303047 | -122.433344910367 | (37.7867886303047, -122.433344910367) | 13 | 9 | 11 | 29490 | 27 | |||
29411 | 124324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996182.48161 | 2113700.35533 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | 11 | 6 | 1 | 54 | 31 | |||
29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
29648 | 239342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 249 Mullen Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010242.33819 | 2100031.51649 | 37.7468643247282 | -122.40731092156 | (37.7468643247282, -122.40731092156) | 2 | 7 | 7 | 28859 | 2 | |||
29821 | 138936 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 611 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004391.0086 | 2110998.5233 | 37.7766478878909 | -122.428325789109 | (37.7766478878909, -122.428325789109) | 7 | 9 | 11 | 28852 | 10 | |||
29832 | 197131 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 17 | : | Tree | Private 2 | 5 | Width 3ft | 6015885.54456 | 2097735.33833 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | 10 | 3 | 8 | 58 | 1 | |||
30443 | 136227 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | 13 | 9 | 1 | 57 | 17 | |||
30750 | 239283 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2750 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009688.59129 | 2105501.22435 | 37.7618519115522 | -122.409611726409 | (37.7618519115522, -122.409611726409) | 8 | 4 | 8 | 28859 | 19 | |||
30941 | 136212 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997026.47763 | 2115953.79939 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | 11 | 6 | 1 | 54 | 31 | |||
31021 | 244040 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 540 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997548.4099 | 2108554.3655 | 37.7695473010692 | -122.451819858751 | (37.7695473010692, -122.451819858751) | 15 | 5 | 11 | 29492 | 9 | |||
31675 | 197094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014478.47867 | 2102089.91001 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | 10 | 3 | 8 | 28856 | 29 | |||
31837 | 240162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 497 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998550.13742 | 2106327.4431 | 37.7634900572362 | -122.448194560431 | (37.7634900572362, -122.448194560431) | 15 | 5 | 11 | 29492 | 9 | |||
32033 | 138074 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1900 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6002997.6045 | 2114890.8811 | 37.7872563808289 | -122.43342419332 | (37.7872563808289, -122.43342419332) | 13 | 9 | 11 | 29490 | 27 | |||
32131 | 239306 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006646.90418 | 2105336.48484 | 37.7612286633914 | -122.420120046409 | (37.7612286633914, -122.420120046409) | 2 | 4 | 7 | 28859 | 19 | |||
32287 | 240137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 466 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003486.65901 | 2100127.76337 | 37.7467481782042 | -122.430678286872 | (37.7467481782042, -122.430678286872) | 2 | 7 | 5 | 63 | 22 | |||
32346 | 179313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006918.39852 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | 9 | 3 | 7 | 309 | 5 | |||
32765 | 213953 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994770.43192 | 2090973.10157 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | 9 | 8 | 6 | 28861 | 24 | |||
33109 | 239244 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010301.83503 | 2101602.35091 | 37.7511808205419 | -122.407215899201 | (37.7511808205419, -122.407215899201) | 2 | 4 | 7 | 28859 | 19 | |||
33350 | 136264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011327.59811 | 2121029.05024 | 37.8045793836809 | -122.405036399426 | (37.8045793836809, -122.405036399426) | 3 | 1 | 10 | 28860 | 6 | |||
33517 | 179311 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | 9 | 3 | 7 | 309 | 28 | |||
33520 | 239298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1475 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | 2 | 4 | 7 | 28859 | 19 | |||
33527 | 136257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | 5 | 1 | 1 | 308 | 32 | |||
33554 | 197092 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | 10 | 3 | 8 | 28856 | 29 | |||
33930 | 213991 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | 1 | 8 | 4 | 59 | 40 | |||
34236 | 213918 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996378.46422 | 2106655.73366 | 37.7642670705822 | -122.455729371032 | (37.7642670705822, -122.455729371032) | 15 | 5 | 11 | 29492 | 12 | |||
34480 | 197115 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1231 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.401444683423 | (37.7541312380906, -122.401444683423) | 10 | 3 | 8 | 28856 | 29 | |||
34959 | 138058 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1908 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002987.8129 | 2114950.6613 | 37.7874199665492 | -122.43346234377 | (37.7874199665492, -122.43346234377) | 13 | 9 | 11 | 29490 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );