Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31 sorted by PlantDate

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
7036 16366 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 1306X Montgomery St 9 Median : Cutout 11 Tree 1 DPW 2     8 8   6011454.042780001 2119896.37482 37.8014764015683 -122.40451904281299 (37.8014764015683, -122.404519042813)
23598 179958 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
24481 117708 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4001 Clement St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
25124 241190 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2858 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010222.306919999 2101664.86224 37.7513480117 -122.407495323966 (37.7513480117, -122.407495323966)
26722 136742 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
27219 215426 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
27397 241185 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3781 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
27769 215436 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 670 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5996989.65534 2095298.72051 37.7331185802561 -122.452795679095 (37.7331185802561, -122.452795679095)
27899 136747 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2859 Filbert St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5999233.55999 2118349.36625 37.796538199022606 -122.446695870812 (37.7965381990226, -122.446695870812)
28207 179962 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 299 Lathrop Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6012155.6977 2086855.9290099998 37.710793783685006 -122.39976966465599 (37.710793783685, -122.399769664656)
28350 215435 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 271 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5999640.40097 2095213.2119999998 37.7330353327146 -122.443625232838 (37.7330353327146, -122.443625232838)
28815 182351 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1501 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985257.4301 2104935.3862 37.758898980602005 -122.49406651392 (37.758898980602, -122.49406651392)
29244 215411 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1939 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982)
29979 241228 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 128 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
30518 179954 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 40 Tomaso Ct 1 : 4 Tree 1 Private 1     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553)
31251 241193 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.40798714698299 (37.7607268479899, -122.407987146983)
32139 215423 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
33234 215420 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
34328 241212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
34372 241223 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009004.56515 2106399.07167 37.7642788409211 -122.41204096432699 (37.7642788409211, -122.412040964327)
34503 215417 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12     5994025.97554 2088461.57938 37.7141751725286 -122.46254606394699 (37.7141751725286, -122.462546063947)
34945 113776 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1710 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546)
35031 241196 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010370.46966 2100029.8165599997 37.7468668275408 -122.406867732983 (37.7468668275408, -122.406867732983)
35762 241219 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
35806 136746 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.44391313370501 (37.7972879782152, -122.443913133705)
37345 197979 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
37469 241216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 6 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6000321.631 2101619.05614 37.7506630907493 -122.44172961845301 (37.7506630907493, -122.441729618453)
37691 136745 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000044.84961 2118592.59728 37.797252356970205 -122.44390612438801 (37.7972523569702, -122.443906124388)
39377 241220 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009102.18096 2106403.8524599997 37.7642974442959 -122.41170367540899 (37.7642974442959, -122.411703675409)
39697 241201 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
40655 197995 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435)
41547 215416 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12     5994027.68196 2088444.22736 37.7141276262766 -122.462538908049 (37.7141276262766, -122.462538908049)
41866 181367 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4019 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982046.1498 2105540.3564 37.76037163028771 -122.505217265817 (37.7603716302877, -122.505217265817)
42049 197980 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012727.8948800005 2104659.33214 37.759710101458204 -122.399040815374 (37.7597101014582, -122.399040815374)
42196 183595 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2639 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089)
42264 246217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 725 Buena Vista Ave West 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726)
42490 241188 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 419 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697)
44646 119965 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 518 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.48783573328801 (37.7794354929176, -122.487835733288)
44751 197981 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
46627 182665 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 0ft   5985884.1902 2102331.3321 37.7517856167847 -122.491707219971 (37.7517856167847, -122.491707219971)
47759 241195 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.3192300005 2105113.8429400004 37.7608140561404 -122.407990924146 (37.7608140561404, -122.407990924146)
48830 215419 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 1x Minerva St 36 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5996348.606369999 2088999.95907 37.7157869222005 -122.454557070559 (37.7157869222005, -122.454557070559)
48849 198000 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 828x Jamestown Ave 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   6014844.30096 2089001.4675099999 37.7168345316683 -122.390626989449 (37.7168345316683, -122.390626989449)
49851 197983 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1809 19th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012297.3164 2105130.82765 37.760980720296295 -122.400563103211 (37.7609807202963, -122.400563103211)
50744 197985 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 669 Mississippi St 2 : 4 Tree 1 Private 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
50962 179971 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 160 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
51116 179953 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 240 Peabody St 1 : 4 Tree 1 Private 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
51602 197989 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 28 15th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501)
51881 197988 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 82 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576)
53611 109316 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1516 BROADWAY 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
55123 198002 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 13 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   6014610.54339 2089241.6149400002 37.717480958049 -122.39145176041 (37.717480958049, -122.39145176041)
55615 182655 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985877.3992 2102330.3619999997 37.7517825562574 -122.49173063243201 (37.7517825562574, -122.491730632432)
55655 198001 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 1 Median : Cutout 11 Tree 1 DPW 2     9 Width 5ft   6014795.93259 2089063.22643 37.7170014260431 -122.390798490171 (37.7170014260431, -122.390798490171)
56645 247209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001860.515269999 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832)
56686 241210 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009103.79641 2106355.71742 37.764165367153204 -122.41169468665899 (37.7641653671532, -122.411694686659)
57252 199656 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1395 Donner Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.39011571883199 (37.7220928214053, -122.390115718832)
58250 215427 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993797.5326 2092869.7349099999 37.726265747145604 -122.463655385788 (37.7262657471456, -122.463655385788)
59497 215415 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 484 Faxon Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5994798.18805 2091784.9127099998 37.7233446951982 -122.460117638125 (37.7233446951982, -122.460117638125)
59569 115612 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
59765 241209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6009128.3617 2106356.68814 37.76416941052621 -122.411609790669 (37.7641694105262, -122.411609790669)
59883 179956 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   5998852.5351599995 2088480.84158 37.7145048379104 -122.44586505733999 (37.7145048379104, -122.44586505734)
60020 241221 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)
60023 241192 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3630 20th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6006049.00576 2104357.91631 37.7585080370469 -122.42211840383499 (37.7585080370469, -122.422118403835)
64095 179955 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
64723 215414 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5997954.5929 2094069.3346400002 37.7297982247933 -122.449371101191 (37.7297982247933, -122.449371101191)
65029 241191 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3630 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006057.8545699995 2104359.21039 37.7585120893797 -122.42208789256901 (37.7585120893797, -122.422087892569)
65216 136751 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1142 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6007453.51921 2119553.70533 37.8003111329029 -122.41833837521999 (37.8003111329029, -122.41833837522)
66969 241217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6003092.5802 2100398.11558 37.7474681682247 -122.432060274186 (37.7474681682247, -122.432060274186)
66988 179969 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 623 Goettingen St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
67671 197984 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1177 De Haro St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   6012264.79545 2102939.83963 37.754962935614294 -122.40052167053999 (37.7549629356143, -122.40052167054)
68564 241227 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 104 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003479.820730001 2097757.7557200002 37.7402402980644 -122.430532852122 (37.7402402980644, -122.430532852122)
69860 241226 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 102 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6003452.26052 2097778.5444 37.740295817689294 -122.43062962727 (37.7402958176893, -122.43062962727)
70744 179963 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
71330 179970 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 307 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
72724 247212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6001824.5154099995 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838)
73993 241200 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328)
74241 241197 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010385.48006 2100017.65971 37.7468342873856 -122.406814971529 (37.7468342873856, -122.406814971529)
76250 215428 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845)
80952 109314 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1516 BROADWAY 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
81156 109317 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1516 BROADWAY 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
83290 11584 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 4001 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 3X3   5982142.686634201 2105549.2773534 37.7604018044904 -122.504884056543 (37.7604018044904, -122.504884056543)
87668 103568 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 223 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   5997125.5 2106655.6 37.76430954658429 -122.45314559026801 (37.7643095465843, -122.453145590268)
96207 108286 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1 HENRY ADAMS ST 11 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
98438 117606 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 420 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
100434 108225 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
105965 108221 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
106980 108282 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1 HENRY ADAMS ST 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     10 3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
107827 115617 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
109031 136743 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   6000050.877859999 2118557.23395 37.7971556025074 -122.44388272313 (37.7971556025074, -122.44388272313)
109559 98644 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2391 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6008222.0 2104509.0 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143)
110007 115616 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
110112 115632 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 55x 15TH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6012114.0 2107494.0 37.7674592382642 -122.40136319642001 (37.7674592382642, -122.40136319642)
112993 99104 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3644 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006000.9 2104423.0 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469)
113940 107411 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3634 20th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
116911 109315 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1516 BROADWAY 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
118122 108224 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118194 108227 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
120475 108220 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
122229 123216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 654 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993193.61084 2111027.91211 37.7760886204879 -122.46706267834298 (37.7760886204879, -122.467062678343)
128240 215433 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)

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