Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
25274 | 25274 | 203174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205628999 | (37.7622739427176, -122.39342205629) | |||
27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
28270 | 28270 | 217447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.00419 | 2091109.04775 | 37.721484434931796 | -122.460338956771 | (37.7214844349318, -122.460338956771) | |||
31642 | 31642 | 217485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 616 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998040.52965 | 2095018.98025 | 37.7324106420337 | -122.449142396404 | (37.7324106420337, -122.449142396404) | |||
32803 | 32803 | 243929 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6001410.85086 | 2099557.6127299997 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | |||
33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | |||
33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
37483 | 37483 | 217487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999757.91748 | 2093744.86936 | 37.729010308071 | -122.44311353116501 | (37.729010308071, -122.443113531165) | |||
38493 | 38493 | 181278 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003332.53306 | 2094181.6518 | 37.730412786411904 | -122.430786976247 | (37.7304127864119, -122.430786976247) | |||
39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
41733 | 41733 | 203194 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012994.12431 | 2096000.54159 | 37.7359497449792 | -122.3975127773 | (37.7359497449792, -122.3975127773) | ||||
43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
44370 | 44370 | 137500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.78495423950061 | -122.451922604659 | (37.7849542395006, -122.451922604659) | |||
44785 | 44785 | 243930 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1351 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6001401.88208 | 2099729.52286 | 37.7455363732181 | -122.437858706116 | (37.7455363732181, -122.437858706116) | |||
47898 | 47898 | 248076 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Holladay Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6010319.424219999 | 2098700.6468 | 37.7432143605434 | -122.40695057673099 | (37.7432143605434, -122.406950576731) | |||
51670 | 51670 | 181284 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 75 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6006132.8407 | 2093885.45886 | 37.7297577652023 | -122.421084877777 | (37.7297577652023, -122.421084877777) | ||||
51719 | 51719 | 203192 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2701 Phelps St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6011784.79678 | 2093250.5774700001 | 37.728331506992895 | -122.40150072019699 | (37.7283315069929, -122.401500720197) | |||
54238 | 54238 | 181285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 55 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6006176.18741 | 2094039.87064 | 37.7301841895453 | -122.420945981966 | (37.7301841895453, -122.420945981966) | ||||
55931 | 55931 | 181279 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 164 Otsego Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000580.61226 | 2092352.75488 | 37.725234756259105 | -122.440169631943 | (37.7252347562591, -122.440169631943) | ||||
59707 | 59707 | 243931 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6001427.70796 | 2099722.90348 | 37.7455196665071 | -122.437768930406 | (37.7455196665071, -122.437768930406) | |||
61157 | 61157 | 243933 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001410.80109 | 2099722.64145 | 37.7455179856652 | -122.437827372845 | (37.7455179856652, -122.437827372845) | |||
62711 | 62711 | 203188 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2212 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 6012161.98551 | 2101908.2137 | 37.752124581703896 | -122.400804745651 | (37.7521245817039, -122.400804745651) | |||
67120 | 67120 | 217465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 270 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991973.319019999 | 2090312.5132 | 37.719138962561395 | -122.469775446797 | (37.7191389625614, -122.469775446797) | |||
67886 | 67886 | 181273 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 5993253.89248 | 2087254.87445 | 37.710817354905295 | -122.465127066954 | (37.7108173549053, -122.465127066954) | |||
70487 | 70487 | 217481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999774.01899 | 2095479.90508 | 37.7337752292392 | -122.443182429144 | (37.7337752292392, -122.443182429144) | |||
72671 | 72671 | 217483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 487 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998873.28001 | 2094951.91453 | 37.7322740898789 | -122.44625857187599 | (37.7322740898789, -122.446258571876) | |||
76143 | 76143 | 217453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 296 Montana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994116.14589 | 2089356.42812 | 37.7166374065639 | -122.462299264809 | (37.7166374065639, -122.462299264809) | |||
116440 | 116440 | 187523 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012557.25141 | 2087947.38565 | 37.713813084777605 | -122.39845832991199 | (37.7138130847776, -122.398458329912) | ||||
130191 | 130191 | 217445 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5994721.42442 | 2091190.6109200001 | 37.721708469553 | -122.46033995415199 | (37.721708469553, -122.460339954152) | |||
130520 | 130520 | 181272 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4061 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5991602.94551 | 2088924.16966 | 37.7153054953149 | -122.47095459108299 | (37.7153054953149, -122.470954591083) | |||
137010 | 137010 | 244855 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 899 Hampshire St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010216.96114 | 2104085.25819 | 37.7579935807494 | -122.407684453192 | (37.7579935807494, -122.407684453192) | |||
137624 | 137624 | 217466 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 380 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5992234.1227 | 2090402.1103 | 37.7194000456453 | -122.46888047296801 | (37.7194000456453, -122.468880472968) | |||
137678 | 137678 | 244821 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005757.946719999 | 2100569.56041 | 37.748089667204205 | -122.422855781374 | (37.7480896672042, -122.422855781374) | |||
137725 | 137725 | 217829 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991671.86156 | 2094594.4240599999 | 37.7308786001697 | -122.471129246615 | (37.7308786001697, -122.471129246615) | ||||
137787 | 137787 | 217451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5994521.5845800005 | 2089667.4223099998 | 37.7175146601568 | -122.460920402674 | (37.7175146601568, -122.460920402674) | ||||
138237 | 138237 | 217446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.49228 | 2091159.88936 | 37.7216240618899 | -122.46034095147101 | (37.7216240618899, -122.460340951471) | |||
146688 | 146688 | 244823 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005752.797 | 2100569.1543099997 | 37.74808826157621 | -122.422873560084 | (37.7480882615762, -122.422873560084) | |||
147181 | 147181 | 243932 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001413.8789800005 | 2099722.88395 | 37.745518826532 | -122.43781674736799 | (37.745518826532, -122.437816747368) | |||
147977 | 147977 | 181274 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | |||
149948 | 149948 | 181283 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 221 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6004356.32803 | 2092093.79207 | 37.72473793927671 | -122.427098916803 | (37.7247379392767, -122.427098916803) | ||||
150487 | 150487 | 217444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Holloway Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994706.40918 | 2091208.56862 | 37.721756913341295 | -122.46039315802601 | (37.7217569133413, -122.460393158026) | |||
151854 | 151854 | 217482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 19 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999956.53878 | 2095464.0242299999 | 37.7337420298675 | -122.442550265996 | (37.7337420298675, -122.442550265996) | |||
153688 | 153688 | 217480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5999643.16837 | 2095215.32408 | 37.7330412898258 | -122.44361581691099 | (37.7330412898258, -122.443615816911) | |||
155650 | 155650 | 181265 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6009530.324580001 | 2087672.9738099999 | 37.7128905152502 | -122.40890120353201 | (37.7128905152502, -122.408901203532) | |||
156217 | 156217 | 181280 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6004524.91871 | 2092988.1896099998 | 37.727203289497794 | -122.42657977773999 | (37.7272032894978, -122.42657977774) | |||
156331 | 156331 | 202029 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1331 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6013954.19623 | 2091006.8516900002 | 37.7222914964254 | -122.39384396154199 | (37.7222914964254, -122.393843961542) | |||
156998 | 156998 | 181281 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6004496.25142 | 2093004.99255 | 37.727247805938795 | -122.426680076425 | (37.7272478059388, -122.426680076425) | |||
158497 | 158497 | 181270 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6011335.815769999 | 2088522.23161 | 37.715323375648296 | -122.40272048866899 | (37.7153233756483, -122.402720488669) | |||
159602 | 159602 | 244820 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005758.41375 | 2100573.51884 | 37.748100562499204 | -122.422854447683 | (37.7481005624992, -122.422854447683) | |||
165317 | 165317 | 217452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5994521.8342699995 | 2089659.5838400002 | 37.7174931519523 | -122.46091897182801 | (37.7174931519523, -122.460918971828) | ||||
168723 | 168723 | 217830 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991664.0561 | 2094598.0007200001 | 37.730887969306 | -122.471156491586 | (37.730887969306, -122.471156491586) | ||||
169617 | 169617 | 244822 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005751.99744 | 2100574.03456 | 37.7481016165112 | -122.42287667172899 | (37.7481016165112, -122.422876671729) | |||
170710 | 170710 | 247119 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6002742.76916 | 2098847.9819 | 37.7431920249995 | -122.43315915579201 | (37.7431920249995, -122.433159155792) | ||||
171385 | 171385 | 244815 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 451 Florida St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 9ft | 6009251.4171400005 | 2106274.41145 | 37.7639503995181 | -122.411178363391 | (37.7639503995181, -122.411178363391) | |||
173440 | 173440 | 247055 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 500 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6002656.51125 | 2099493.5306599997 | 37.7449596577675 | -122.433503535865 | (37.7449596577675, -122.433503535865) | ||||
175090 | 175090 | 187522 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012564.1625 | 2087957.56317 | 37.713841415230604 | -122.398435156171 | (37.7138414152306, -122.398435156171) | ||||
175583 | 175583 | 217479 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 158 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6001063.19964 | 2095410.8280900002 | 37.7336589855795 | -122.43872040954099 | (37.7336589855795, -122.438720409541) | |||
176643 | 176643 | 181263 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6009475.51838 | 2087694.07697 | 37.7129453900797 | -122.40909212061199 | (37.7129453900797, -122.409092120612) | |||
181853 | 181853 | 201499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6018416.79538 | 2095102.4725900001 | 37.7337842710237 | -122.37870189547701 | (37.7337842710237, -122.378701895477) | ||||
182881 | 182881 | 187524 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012544.21435 | 2087950.6846900003 | 37.7138214169992 | -122.398503622458 | (37.7138214169992, -122.398503622458) | ||||
183191 | 183191 | 181262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009462.97914 | 2087698.55594 | 37.7129569859491 | -122.409135776392 | (37.7129569859491, -122.409135776392) | |||
184860 | 184860 | 181218 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 765 Delano Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998962.78764 | 2090178.0255900002 | 37.719171212271796 | -122.445605954547 | (37.7191712122718, -122.445605954547) | |||
188775 | 188775 | 246732 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Ripley St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6008546.25114 | 2099104.34804 | 37.7442234529633 | -122.41311030320101 | (37.7442234529633, -122.413110303201) | |||
188996 | 188996 | 181266 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6009541.56007 | 2087669.1100400002 | 37.712880535479 | -122.40886209741001 | (37.712880535479, -122.40886209741) |
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");