Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
| 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) | |||
| 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) | |||
| 187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
| 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) | |||
| 44790 | 44790 | 244846 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6006641.954969999 | 2103569.5656 | 37.75637683445171 | -122.42001177073901 | (37.7563768344517, -122.420011770739) | |||
| 52123 | 52123 | 244847 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 6006653.79898 | 2103383.59728 | 37.7558668756582 | -122.41995761356002 | (37.7558668756582, -122.41995761356) | |||
| 134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 185076 | 185076 | 244824 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 773 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6005057.02214 | 2103838.7107 | 37.757026420139 | -122.42551217995701 | (37.757026420139, -122.425512179957) | |||
| 25234 | 25234 | 244842 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6006681.50629 | 2103383.71332 | 37.755868755243704 | -122.419861800707 | (37.7558687552437, -122.419861800707) | |||
| 27734 | 27734 | 181258 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | |||
| 29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
| 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) | |||
| 33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
| 35882 | 35882 | 181250 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | |||
| 40752 | 40752 | 181255 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011058.3910300005 | 2087059.24952 | 37.71129082818 | -122.403576524557 | (37.71129082818, -122.403576524557) | |||
| 42000 | 42000 | 181235 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6011766.34512 | 2087531.33968 | 37.7126266136928 | -122.401162793634 | (37.7126266136928, -122.401162793634) | |||
| 42138 | 42138 | 181261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010896.06222 | 2086791.14453 | 37.710545596879705 | -122.40411872042299 | (37.7105455968797, -122.404118720423) | |||
| 42329 | 42329 | 181252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011104.47177 | 2087135.7976799998 | 37.711503587981205 | -122.403422638862 | (37.7115035879812, -122.403422638862) | |||
| 44652 | 44652 | 181259 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010937.034659999 | 2086861.99587 | 37.710742429686206 | -122.40398209272499 | (37.7107424296862, -122.403982092725) | |||
| 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) | |||
| 45408 | 45408 | 244813 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 45 Hoff St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 6ft | 6006570.0042 | 2106423.3785 | 37.7642086856934 | -122.42046316294599 | (37.7642086856934, -122.420463162946) | |||
| 48660 | 48660 | 243926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 6006689.91006 | 2103386.78803 | 37.7558776711221 | -122.41983295584299 | (37.7558776711221, -122.419832955843) | |||
| 48782 | 48782 | 181251 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011120.84177 | 2087163.22682 | 37.7115798172183 | -122.40336798793999 | (37.7115798172183, -122.40336798794) | |||
| 57972 | 57972 | 181260 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010918.05044 | 2086828.8185599998 | 37.7106502707697 | -122.40404537351601 | (37.7106502707697, -122.404045373516) | |||
| 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) | |||
| 60011 | 60011 | 181246 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011206.95507 | 2087284.9541099998 | 37.711918865232 | -122.403078912559 | (37.711918865232, -122.403078912559) | |||
| 60293 | 60293 | 244814 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 45 Hoff St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006569.6779 | 2106452.55606 | 37.7642887820295 | -122.420466362743 | (37.7642887820295, -122.420466362743) | |||
| 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) | |||
| 64107 | 64107 | 244844 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006630.92083 | 2103720.4372 | 37.7567904713264 | -122.420060637198 | (37.7567904713264, -122.420060637198) | |||
| 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) | |||
| 76881 | 76881 | 243925 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006679.07286 | 2103590.73607 | 37.7564370548525 | -122.41988490606501 | (37.7564370548525, -122.419884906065) | |||
| 135845 | 135845 | 243924 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006678.4863599995 | 2103600.0339099998 | 37.7564625515326 | -122.419887594147 | (37.7564625515326, -122.419887594147) | |||
| 136431 | 136431 | 181236 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011740.78696 | 2087511.07022 | 37.712569531933 | -122.401249707721 | (37.712569531933, -122.401249707721) | |||
| 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) | |||
| 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) | |||
| 148566 | 148566 | 181253 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011090.2657 | 2087112.4680700002 | 37.7114387360727 | -122.403470098762 | (37.7114387360727, -122.403470098762) | |||
| 148908 | 148908 | 118014 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.779984662684704 | -122.49754547051 | (37.7799846626847, -122.49754547051) | |||
| 150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
| 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) | |||
| 159888 | 159888 | 181249 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011154.37999 | 2087216.41128 | 37.7117277242201 | -122.40325580920602 | (37.7117277242201, -122.403255809206) | |||
| 167542 | 167542 | 181237 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011709.60443 | 2087494.2224299998 | 37.712521531527294 | -122.40135630166 | (37.7125215315273, -122.40135630166) | |||
| 174910 | 174910 | 181219 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 519 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6002044.02941 | 2090439.9964599998 | 37.720065958565 | -122.434974017336 | (37.720065958565, -122.434974017336) | |||
| 175756 | 175756 | 181248 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011168.55226 | 2087238.084 | 37.7117880246642 | -122.403208349279 | (37.7117880246642, -122.403208349279) | |||
| 183212 | 183212 | 181247 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.40313356348899 | (37.7118653915605, -122.403133563489) | |||
| 1512 | 1512 | 243955 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.3814199995 | 2109908.18867 | 37.773804548164705 | -122.419028109365 | (37.7738045481647, -122.419028109365) | |
| 1514 | 1514 | 243952 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.41915431212601 | (37.7741761624211, -122.419154312126) | |
| 1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
| 1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
| 1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
| 1519 | 1519 | 243949 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.017419999 | 2110160.92453 | 37.7744951573695 | -122.41925139124399 | (37.7744951573695, -122.419251391244) | |
| 1521 | 1521 | 243954 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.773917457170796 | -122.41905723302 | (37.7739174571708, -122.41905723302) | |
| 1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
| 23753 | 23753 | 199483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.38972250619801 | (37.7716855044225, -122.389722506198) | |||
| 23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
| 27009 | 27009 | 199444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.769024297155205 | -122.389144413879 | (37.7690242971552, -122.389144413879) | |||
| 27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
| 28387 | 28387 | 199462 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015592.103080001 | 2107492.64638 | 37.7676489630463 | -122.389332708559 | (37.7676489630463, -122.389332708559) | |||
| 28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
| 30691 | 30691 | 244835 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006729.90929 | 2107524.20157 | 37.7672402967355 | -122.41998822018101 | (37.7672402967355, -122.419988220181) | |||
| 31881 | 31881 | 199455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | |||
| 32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
| 32681 | 32681 | 181225 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | |||
| 33501 | 33501 | 199465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015601.020959999 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | |||
| 33585 | 33585 | 137505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.41848851434601 | (37.8043982179661, -122.418488514346) | |||
| 33786 | 33786 | 199476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015490.48538 | 2109320.84762 | 37.772663168207 | -122.389811906894 | (37.772663168207, -122.389811906894) | |||
| 35626 | 35626 | 199488 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015518.167640001 | 2108801.30732 | 37.7712381600557 | -122.38967985676099 | (37.7712381600557, -122.389679856761) | |||
| 36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
| 38378 | 38378 | 203183 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015658.44629 | 2106386.7571400004 | 37.7646161091615 | -122.38902601186001 | (37.7646161091615, -122.38902601186) | |||
| 39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
| 40393 | 40393 | 244837 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6006731.37022 | 2107461.01908 | 37.7670668948411 | -122.41997868286998 | (37.7670668948411, -122.41997868287) | |||
| 40665 | 40665 | 244841 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006736.38106 | 2107369.27612 | 37.766815272626296 | -122.41995484006901 | (37.7668152726263, -122.419954840069) | |||
| 43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
| 44421 | 44421 | 199463 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015595.21944 | 2107438.50948 | 37.7675004876899 | -122.38931814851999 | (37.7675004876899, -122.38931814852) | |||
| 44505 | 44505 | 181226 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012120.3534699995 | 2087937.9432299999 | 37.713762809074 | -122.39996775739901 | (37.713762809074, -122.399967757399) | |||
| 45072 | 45072 | 181223 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012185.06666 | 2088017.9901400001 | 37.7139862096601 | -122.399749700601 | (37.7139862096601, -122.399749700601) | |||
| 45676 | 45676 | 181228 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6012082.02881 | 2087884.13753 | 37.7136129325747 | -122.400096445907 | (37.7136129325747, -122.400096445907) | |||
| 52239 | 52239 | 199453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015629.79574 | 2108466.51232 | 37.7703250756792 | -122.389270345061 | (37.7703250756792, -122.389270345061) | |||
| 52425 | 52425 | 247649 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001576.55462 | 2108299.96127 | 37.7690786539981 | -122.437868461073 | (37.7690786539981, -122.437868461073) | |||
| 54749 | 54749 | 137504 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.41848985342399 | (37.8044056238841, -122.418489853424) | |||
| 54820 | 54820 | 199491 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6010160.462780001 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | |||
| 56235 | 56235 | 199464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015598.48485 | 2107402.1848299997 | 37.7674009291493 | -122.389304316962 | (37.7674009291493, -122.389304316962) | |||
| 57434 | 57434 | 199481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015507.548169999 | 2109003.40137 | 37.77179247697679 | -122.389730708003 | (37.7717924769768, -122.389730708003) | |||
| 59290 | 59290 | 199446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6015650.90558 | 2108071.91419 | 37.7692427658814 | -122.38916976848199 | (37.7692427658814, -122.389169768482) | |||
| 60522 | 60522 | 247645 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001626.8491400005 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | |||
| 60563 | 60563 | 181224 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012163.826230001 | 2087990.6147200002 | 37.713909858116104 | -122.39982119490601 | (37.7139098581161, -122.399821194906) | |||
| 60777 | 60777 | 181229 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012059.81705 | 2087859.8714700001 | 37.713545064337296 | -122.400171515023 | (37.7135450643373, -122.400171515023) | |||
| 61712 | 61712 | 203182 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690803998 | (37.7647506171774, -122.38903690804) | |||
| 62268 | 62268 | 181231 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012012.90847 | 2087803.8646200001 | 37.713388665025 | -122.40032971745 | (37.713388665025, -122.40032971745) | |||
| 63273 | 63273 | 199485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015513.12326 | 2108880.27223 | 37.7714547006117 | -122.389702821822 | (37.7714547006117, -122.389702821822) | |||
| 64963 | 64963 | 199457 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015609.11002 | 2108848.45381 | 37.7713726563476 | -122.389368573515 | (37.7713726563476, -122.389368573515) | |||
| 65089 | 65089 | 199459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015601.45578 | 2108929.3451900003 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | |||
| 65873 | 65873 | 199487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.38968887873399 | (37.7713483755645, -122.389688878734) | |||
| 66564 | 66564 | 199468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015459.06425 | 2109878.23066 | 37.77419187628129 | -122.38995953961799 | (37.7741918762813, -122.389959539618) |
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");