Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25124 | 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) | |||
27769 | 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) | |||
28350 | 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) | |||
29244 | 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 | 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 | 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 | 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) | |||
34945 | 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) | |||
37469 | 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 | 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) | |||
41547 | 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 | 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) | |||
42196 | 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) | |||
42490 | 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 | 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) | |||
46627 | 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) | |||
51116 | 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) | |||
51881 | 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) | |||
57252 | 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) | |||
59883 | 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) | |||
65029 | 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 | 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 | 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) | |||
68564 | 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 | 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 | 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) | |||
80952 | 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) | ||||
87668 | 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) | |||
87848 | 87848 | 100205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091.0 | 2104064.0 | 37.757533730328205 | -122.43232751517901 | (37.7575337303282, -122.432327515179) | |
109559 | 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) | |||
112993 | 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) | ||||
122229 | 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) | |||
130161 | 130161 | 215412 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | |||
135321 | 135321 | 215425 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993828.92178 | 2092931.25645 | 37.7264364789445 | -122.463551338741 | (37.7264364789445, -122.463551338741) | |||
148653 | 148653 | 215421 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2085 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993516.19097 | 2101401.9668400004 | 37.74967690946279 | -122.46524744032101 | (37.7496769094628, -122.465247440321) | |||
149959 | 149959 | 197978 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1100 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6013947.00765 | 2106209.45605 | 37.764034263084504 | -122.394933045925 | (37.7640342630845, -122.394933045925) | |||
151347 | 151347 | 136741 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000055.17715 | 2118534.1134099998 | 37.797092364871794 | -122.44386618458701 | (37.7970923648718, -122.443866184587) | |||
152480 | 152480 | 241225 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4049 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001920.58101 | 2105839.72544 | 37.7623430070574 | -122.43650238277901 | (37.7623430070574, -122.436502382779) | |||
153492 | 153492 | 136750 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6007528.1043 | 2119564.5184299997 | 37.8003450211571 | -122.41808104771299 | (37.8003450211571, -122.418081047713) | |||
158454 | 158454 | 250756 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Lake St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5986048.1037 | 2114785.2005 | 37.7859900201618 | -122.492057248563 | (37.7859900201618, -122.492057248563) | |||
159390 | 159390 | 246465 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 220 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005035.80445 | 2099919.28541 | 37.746263388739706 | -122.425306657892 | (37.7462633887397, -122.425306657892) | |||
159970 | 159970 | 124330 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995934.0004900005 | 2113471.95009 | 37.782957097905395 | -122.457759890544 | (37.7829570979054, -122.457759890544) | |||
160919 | 160919 | 241224 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 44 Museum Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000710.17183 | 2106760.2697 | 37.764801739133205 | -122.44075476054701 | (37.7648017391332, -122.440754760547) | |||
162786 | 162786 | 143059 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.40702659346701 | (37.8026814253217, -122.407026593467) | |||
162849 | 162849 | 241205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008219.00846 | 2104543.8944099997 | 37.7591408449879 | -122.414626698671 | (37.7591408449879, -122.414626698671) | |||
162886 | 162886 | 197999 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 828 Jamestown Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6014890.34253 | 2088931.57147 | 37.7166451650195 | -122.39046296391399 | (37.7166451650195, -122.390462963914) | |||
168702 | 168702 | 241202 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005836.15299 | 2096624.2788099998 | 37.7372612281114 | -122.42230507703 | (37.7372612281114, -122.42230507703) | |||
170472 | 170472 | 241215 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008984.20306 | 2106349.91543 | 37.7641427267158 | -122.412107917041 | (37.7641427267158, -122.412107917041) | |||
171952 | 171952 | 241182 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009519.86871 | 2101254.76714 | 37.7501826387226 | -122.409895500292 | (37.7501826387226, -122.409895500292) | |||
173562 | 173562 | 241186 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006573.70754 | 2106363.42565 | 37.764044277946205 | -122.42044609832399 | (37.7640442779462, -122.420446098324) | |||
173632 | 173632 | 241206 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2387 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008217.68506 | 2104568.2265 | 37.759207580982 | -122.414632997525 | (37.759207580982, -122.414632997525) | |||
174371 | 174371 | 179957 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011927.1671400005 | 2087557.3453099998 | 37.7127069906044 | -122.40060876447599 | (37.7127069906044, -122.400608764476) | |||
175277 | 175277 | 241199 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | |||
178574 | 178574 | 241189 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 415 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007440.26209 | 2107242.97401 | 37.7665081073951 | -122.41751127324 | (37.7665081073951, -122.41751127324) | |||
182516 | 182516 | 215434 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993586.39661 | 2092891.1654599998 | 37.7263124219742 | -122.464386821508 | (37.7263124219742, -122.464386821508) | |||
186537 | 186537 | 182441 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1529 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5985572.6922 | 2104787.172 | 37.7585104674539 | -122.492965288536 | (37.7585104674539, -122.492965288536) | |||
186902 | 186902 | 197986 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 498 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014051.93568 | 2104880.86729 | 37.7603920825505 | -122.394477092339 | (37.7603920825505, -122.394477092339) | |||
188676 | 188676 | 241203 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008221.76709 | 2104500.66986 | 37.759022315257894 | -122.414614099173 | (37.7590223152579, -122.414614099173) | |||
23598 | 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 | 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) | |||
26722 | 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 | 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 | 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) | |||
28815 | 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) | |||
33234 | 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) | |||
34503 | 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) | ||||
39697 | 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) | |||
50744 | 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 | 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) | |||
55615 | 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) | |||
64095 | 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) | |||
66988 | 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) | |||
71330 | 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) | |||
73993 | 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 | 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) | |||
116911 | 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) | ||||
128240 | 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) | |||
132120 | 132120 | 241214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009008.65245 | 2106350.93983 | 37.764146911276704 | -122.41202342575899 | (37.7641469112767, -122.412023425759) | |||
135775 | 135775 | 179965 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 86 Arago St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999606.18552 | 2093002.3803299998 | 37.726962952855104 | -122.443584762453 | (37.7269629528551, -122.443584762453) | ||||
135983 | 135983 | 241218 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6003089.92025 | 2100398.1705 | 37.7474681682179 | -122.43206947603399 | (37.7474681682179, -122.432069476034) | |||
136649 | 136649 | 141332 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1324 HAYES ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6001489.2623 | 2110460.5875 | 37.7750062304087 | -122.43832521117099 | (37.7750062304087, -122.438325211171) | |||
157611 | 157611 | 136748 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.80559494132721 | -122.43493757052299 | (37.8055949413272, -122.434937570523) | |||
157670 | 157670 | 241194 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010150.13435 | 2105098.1288099997 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | |||
158174 | 158174 | 241187 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006570.58835 | 2106391.73918 | 37.7641218444722 | -122.420458896575 | (37.7641218444722, -122.420458896575) | |||
160016 | 160016 | 241207 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007609.4952 | 2103000.12596 | 37.754867747762795 | -122.41662533218701 | (37.7548677477628, -122.416625332187) | |||
160717 | 160717 | 197991 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3419 Jennings St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013294.96544 | 2089742.68292 | 37.7187836844998 | -122.396034235213 | (37.7187836844998, -122.396034235213) | ||||
164851 | 164851 | 247521 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1101 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000007.86979 | 2108477.01107 | 37.7694754609529 | -122.443307149811 | (37.7694754609529, -122.443307149811) | ||||
166118 | 166118 | 215413 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 423 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5997941.5079 | 2094069.28168 | 37.7297973308762 | -122.44941633348999 | (37.7297973308762, -122.44941633349) | |||
178056 | 178056 | 136744 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.44389766175101 | (37.7972226334754, -122.443897661751) | |||
181600 | 181600 | 241204 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008220.32471 | 2104519.20022 | 37.759073114347295 | -122.414620398932 | (37.7590731143473, -122.414620398932) | |||
187402 | 187402 | 179964 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002952.82685 | 2087126.8782400002 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | |||
189124 | 189124 | 179961 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012198.832140001 | 2086842.9214 | 37.7107604718955 | -122.399619668515 | (37.7107604718955, -122.399619668515) | |||
35762 | 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 | 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) | |||
39377 | 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) | |||
47759 | 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) | |||
53611 | 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) | ||||
58250 | 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) | |||
60023 | 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) | |||
64723 | 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) |
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");