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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24138 | 24138 | 225161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2957 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009038.45977 | 2101249.93986 | 37.7501423922716 | -122.411559907065 | (37.7501423922716, -122.411559907065) | |||
| 79507 | 79507 | 27654 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2968 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981673.036337901 | 2096540.7284095 | 37.7356392111548 | -122.50584045491001 | (37.7356392111548, -122.50584045491) | ||
| 72634 | 72634 | 225193 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2973 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009010.89225 | 2102726.9922700003 | 37.7541965009837 | -122.41175959345 | (37.7541965009837, -122.41175959345) | |||
| 44500 | 44500 | 225198 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007149.23047 | 2103831.77129 | 37.757125358151704 | -122.41827602071501 | (37.7571253581517, -122.418276020715) | |||
| 76779 | 76779 | 225196 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.41815982112699 | (37.7571300930895, -122.418159821127) | |||
| 84096 | 84096 | 225197 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | |||
| 146563 | 146563 | 225195 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007206.11976 | 2103835.7790900003 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | |||
| 152776 | 152776 | 225194 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007219.63733 | 2103836.19178 | 37.757141458734395 | -122.418032839538 | (37.7571414587344, -122.418032839538) | |||
| 157709 | 157709 | 225159 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3189 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007127.86585 | 2103790.91823 | 37.75701198242339 | -122.41834701140301 | (37.7570119824234, -122.418347011403) | |||
| 75852 | 75852 | 225160 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3191 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007035.27064 | 2103785.32086 | 37.756991400544294 | -122.418666844507 | (37.7569914005443, -122.418666844507) | |||
| 17622 | 17622 | 638 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007578.42744 | 2102058.8333799997 | 37.752281425265295 | -122.41666609486401 | (37.7522814252653, -122.416666094864) | ||
| 21501 | 21501 | 639 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007596.74853 | 2102059.47083 | 37.7522842059666 | -122.416602782609 | (37.7522842059666, -122.416602782609) | ||
| 171827 | 171827 | 225158 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007618.37358 | 2102060.04095 | 37.7522869875715 | -122.416528039931 | (37.7522869875715, -122.416528039931) | |||
| 180166 | 180166 | 225199 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3290 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008287.23317 | 2104481.08405 | 37.7589722149231 | -122.41438629998899 | (37.7589722149231, -122.414386299989) | |||
| 21753 | 21753 | 7651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3309 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008514.76673 | 2099315.4507400002 | 37.7448013267216 | -122.413234094881 | (37.7448013267216, -122.413234094881) | |||
| 40866 | 40866 | 225175 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3309 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008515.82219 | 2099330.37365 | 37.7448423609829 | -122.41323150034901 | (37.7448423609829, -122.413231500349) | |||
| 181963 | 181963 | 104417 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 12 | Permit Number 770730 | 6001763.35391 | 2121819.4095799997 | 37.8062102070855 | -122.438190954371 | (37.8062102070855, -122.438190954371) | ||
| 187574 | 187574 | 31676 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770730 | 6001735.33868 | 2121814.4309799997 | 37.806194943810894 | -122.438287548749 | (37.8061949438109, -122.438287548749) | |||
| 42322 | 42322 | 225209 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003378.3537099995 | 2104496.9744599997 | 37.7587388642274 | -122.431364637772 | (37.7587388642274, -122.431364637772) | |||
| 71331 | 71331 | 225208 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003395.5499 | 2104500.55449 | 37.758749668692495 | -122.431305421031 | (37.7587496686925, -122.431305421031) | |||
| 31570 | 31570 | 225166 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Hoffman Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000619.1665199995 | 2101783.32951 | 37.7511310943237 | -122.440712500502 | (37.7511310943237, -122.440712500502) | |||
| 176930 | 176930 | 225167 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Hoffman Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000621.34497 | 2101755.16217 | 37.7510538776544 | -122.44070294699699 | (37.7510538776544, -122.440702946997) | |||
| 132078 | 132078 | 225152 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 339 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006495.85243 | 2097173.79313 | 37.738807262551205 | -122.42006317417801 | (37.7388072625512, -122.420063174178) | |||
| 60112 | 60112 | 225210 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6004615.0966300005 | 2105985.22525 | 37.7628952609247 | -122.427193419352 | (37.7628952609247, -122.427193419352) | |||
| 155078 | 155078 | 32061 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35437 | 6004606.11173 | 2105983.62755 | 37.762890365909 | -122.4272243812 | (37.762890365909, -122.4272243812) | |
| 150545 | 150545 | 225149 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008818.14298 | 2097106.89478 | 37.7387541440918 | -122.41202902491999 | (37.7387541440918, -122.41202902492) | |||
| 152589 | 152589 | 32693 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3732 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37102 | 6004859.3884 | 2102538.49197 | 37.7534451551954 | -122.42610311279199 | (37.7534451551954, -122.426103112792) | ||
| 49752 | 49752 | 225207 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3816 24th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6004299.338409999 | 2101924.10637 | 37.7517265264651 | -122.427996107428 | (37.7517265264651, -122.427996107428) | |||
| 176416 | 176416 | 225206 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3816 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004315.95235 | 2101927.5657 | 37.751736964897106 | -122.427938900685 | (37.7517369648971, -122.427938900685) | |||
| 109054 | 109054 | 225205 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3993 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003915.45765 | 2101274.6592 | 37.749921570934895 | -122.429277312204 | (37.7499215709349, -122.429277312204) | |||
| 154165 | 154165 | 246301 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3998 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6002344.4551 | 2105927.1578 | 37.7626071523851 | -122.435042615882 | (37.7626071523851, -122.435042615882) | |||
| 27402 | 27402 | 201678 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010253.38486 | 2109790.37511 | 37.7736605694093 | -122.407960800466 | (37.7736605694093, -122.407960800466) | ||||
| 63791 | 63791 | 201677 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010264.4203699995 | 2109791.71635 | 37.7736648699818 | -122.407922721364 | (37.7736648699818, -122.407922721364) | ||||
| 69677 | 69677 | 201679 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010240.772059999 | 2109788.80533 | 37.7736555529973 | -122.40800431955799 | (37.7736555529973, -122.408004319558) | ||||
| 70258 | 70258 | 201675 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010282.589459999 | 2109782.99387 | 37.7736419372697 | -122.40785925619801 | (37.7736419372697, -122.407859256198) | ||||
| 72268 | 72268 | 201680 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010229.21797 | 2109787.73605 | 37.7736519701026 | -122.40804421168998 | (37.7736519701026, -122.40804421169) | ||||
| 89297 | 89297 | 201672 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010270.770690001 | 2109756.0907799997 | 37.773567405955 | -122.407898241816 | (37.773567405955, -122.407898241816) | ||||
| 134762 | 134762 | 201676 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010275.73936 | 2109794.09532 | 37.7736720357783 | -122.40788373484301 | (37.7736720357783, -122.407883734843) | ||||
| 151815 | 151815 | 201673 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010274.35746 | 2109764.89142 | 37.773591771276706 | -122.4078864553 | (37.7735917712767, -122.4078864553) | ||||
| 159709 | 159709 | 201681 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6010219.21458 | 2109785.59098 | 37.7736455201492 | -122.408078663801 | (37.7736455201492, -122.408078663801) | ||||
| 166477 | 166477 | 201674 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010278.21151 | 2109773.9479799997 | 37.773616854257604 | -122.407873762259 | (37.7736168542576, -122.407873762259) | ||||
| 183572 | 183572 | 201671 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010268.2107 | 2109746.2247 | 37.7735401726656 | -122.407906401378 | (37.7735401726656, -122.407906401378) | ||||
| 57727 | 57727 | 117702 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5983001.87469 | 2113075.50324 | 37.781117159673705 | -122.50246961447901 | (37.7811171596737, -122.502469614479) | |||
| 182738 | 182738 | 117701 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983015.82317 | 2113078.8166099996 | 37.7811270768141 | -122.502421605789 | (37.7811270768141, -122.502421605789) | |||
| 150411 | 150411 | 225204 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 423 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003555.12848 | 2103300.5441900003 | 37.7554637680609 | -122.430667894334 | (37.7554637680609, -122.430667894334) | |||
| 131158 | 131158 | 225165 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001787.26659 | 2100614.3133 | 37.7479877056879 | -122.436589428169 | (37.7479877056879, -122.436589428169) | |||
| 49897 | 49897 | 225168 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4400 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000595.27715 | 2101716.78753 | 37.750947025601 | -122.44079033950399 | (37.750947025601, -122.440790339504) | |||
| 55039 | 55039 | 225145 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 450 Florida St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6009179.2133599995 | 2106266.6276700003 | 37.76392497748579 | -122.41142754574899 | (37.7639249774858, -122.411427545749) | ||||
| 27211 | 27211 | 190009 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.6424 | 2104780.97852 | 37.7600593109036 | -122.39810604475099 | (37.7600593109036, -122.398106044751) | |||
| 154762 | 154762 | 190008 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013001.004319999 | 2104770.77292 | 37.7600313087249 | -122.39810407704901 | (37.7600313087249, -122.398104077049) | |||
| 178754 | 178754 | 190010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.60503 | 2104793.1604 | 37.7600927575897 | -122.398107028633 | (37.7600927575897, -122.398107028633) | |||
| 174222 | 174222 | 190012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 6ft | 6012453.688019999 | 2108575.49646 | 37.770447730615295 | -122.400264221637 | (37.7704477306153, -122.400264221637) | |||
| 26101 | 26101 | 225190 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007254.11935 | 2103898.21255 | 37.7573136941774 | -122.41791798353998 | (37.7573136941774, -122.41791798354) | |||
| 39929 | 39929 | 225188 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007247.90987 | 2103966.5437 | 37.757500966319604 | -122.417944302192 | (37.7575009663196, -122.417944302192) | |||
| 106572 | 106572 | 225189 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007250.88683 | 2103937.06131 | 37.757420182006605 | -122.41793191673901 | (37.7574201820066, -122.417931916739) | |||
| 146819 | 146819 | 225192 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007260.94104 | 2103859.736 | 37.757208430341294 | -122.41789166399299 | (37.7572084303413, -122.417891663993) | |||
| 165711 | 165711 | 225191 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007257.73573 | 2103878.07853 | 37.7572586143179 | -122.41790404944099 | (37.7572586143179, -122.417904049441) | |||
| 176830 | 176830 | 225187 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007244.27543 | 2104007.62921 | 37.7576135731224 | -122.417959784028 | (37.7576135731224, -122.417959784028) | |||
| 32476 | 32476 | 126017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009644.05128 | 2115053.2571900003 | 37.788077063340204 | -122.410440279012 | (37.7880770633402, -122.410440279012) | |||
| 34064 | 34064 | 126015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009674.03362 | 2115055.86699 | 37.788085909974605 | -122.410336729273 | (37.7880859099746, -122.410336729273) | |||
| 131352 | 131352 | 126018 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009631.44446 | 2115049.8898 | 37.788067110556604 | -122.41048365871 | (37.7880671105566, -122.41048365871) | |||
| 181010 | 181010 | 126016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009654.60353 | 2115055.05542 | 37.7880825923961 | -122.410403896944 | (37.7880825923961, -122.410403896944) | |||
| 17666 | 17666 | 16203 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998659.38581 | 2094694.1828400001 | 37.731554201452106 | -122.446979509806 | (37.7315542014521, -122.446979509806) | ||
| 20510 | 20510 | 16215 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998684.93347 | 2094693.5890400002 | 37.7315540305774 | -122.446891144221 | (37.7315540305774, -122.446891144221) | ||
| 149755 | 149755 | 206029 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5998304.86283 | 2094699.93665 | 37.731549739012706 | -122.448205573546 | (37.7315497390127, -122.448205573546) | |||
| 158983 | 158983 | 206028 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5998324.94212 | 2094699.61096 | 37.7315499926202 | -122.448136132397 | (37.7315499926202, -122.448136132397) | |||
| 173541 | 173541 | 206030 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 5998284.310380001 | 2094699.8261099998 | 37.7315482605292 | -122.44827661909201 | (37.7315482605292, -122.448276619092) | |||
| 37175 | 37175 | 126019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 542 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6009096.37686 | 2114637.77725 | 37.7869055381056 | -122.412305766101 | (37.7869055381056, -122.412305766101) | |||
| 34786 | 34786 | 126022 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009023.96612 | 2114628.9203 | 37.786877155513004 | -122.412555665234 | (37.786877155513, -122.412555665234) | |||
| 181029 | 181029 | 126020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009058.631990001 | 2114632.0881 | 37.786887798972295 | -122.412435952882 | (37.7868877989723, -122.412435952882) | |||
| 188481 | 188481 | 126021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009038.2153900005 | 2114627.76765 | 37.7868747902962 | -122.412506284359 | (37.7868747902962, -122.412506284359) | |||
| 16169 | 16169 | 100329 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013411.2884599995 | 2111661.36797 | 37.7789741867392 | -122.39716827132 | (37.7789741867392, -122.39716827132) | |
| 16787 | 16787 | 100332 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013356.21451 | 2111717.71239 | 37.779125829518705 | -122.397362747904 | (37.7791258295187, -122.397362747904) | |
| 22913 | 22913 | 100331 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6013371.56305 | 2111703.84537 | 37.779088608380206 | -122.397308677969 | (37.7790886083802, -122.397308677969) | |||
| 43790 | 43790 | 100327 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6013441.178619999 | 2111631.13985 | 37.7788928511631 | -122.39706274847299 | (37.7788928511631, -122.397062748473) | |||
| 57603 | 57603 | 100328 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6013422.40904 | 2111650.3481099997 | 37.778944547796705 | -122.397129027591 | (37.7789445477967, -122.397129027591) | |||
| 167510 | 167510 | 100330 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6013394.216680001 | 2111677.27832 | 37.7790169225246 | -122.39722844584601 | (37.7790169225246, -122.397228445846) | |||
| 188409 | 188409 | 126023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 560 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009008.4198 | 2114630.0994700002 | 37.7868795207321 | -122.412609535497 | (37.7868795207321, -122.412609535497) | |||
| 159626 | 159626 | 206047 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 575 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997894.62452 | 2097851.39191 | 37.7401794193521 | -122.449850874237 | (37.7401794193521, -122.449850874237) | |||
| 18826 | 18826 | 16271 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997920.42958 | 2094705.3029200002 | 37.731542488687204 | -122.449535014353 | (37.7315424886872, -122.449535014353) | ||
| 19777 | 19777 | 16245 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997958.54401 | 2094705.63588 | 37.7315455832604 | -122.44940326996401 | (37.7315455832604, -122.449403269964) | ||
| 21427 | 21427 | 16246 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997938.93286 | 2094706.04445 | 37.731545583255 | -122.44947109863001 | (37.731545583255, -122.44947109863) | ||
| 61557 | 61557 | 206031 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601x Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5997540.974909999 | 2094710.58133 | 37.731535267123 | -122.450847236737 | (37.731535267123, -122.450847236737) | |||
| 188264 | 188264 | 206032 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5997524.38886 | 2094711.3028099998 | 37.7315362986421 | -122.450904629644 | (37.7315362986421, -122.450904629644) | |||
| 62061 | 62061 | 206040 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994946.74244 | 2091203.9910900001 | 37.7217581669755 | -122.45956206304899 | (37.7217581669755, -122.459562063049) | |||
| 168817 | 168817 | 206042 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994983.67365 | 2091204.0797700002 | 37.7217605339977 | -122.45943440879101 | (37.7217605339977, -122.459434408791) | |||
| 178979 | 178979 | 206041 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994962.333219999 | 2091204.5266599997 | 37.7217605340024 | -122.459508208932 | (37.7217605340024, -122.459508208932) | |||
| 183433 | 183433 | 206043 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994997.50397 | 2091203.21567 | 37.721758956587294 | -122.459386538764 | (37.7217589565873, -122.459386538764) | |||
| 172254 | 172254 | 190033 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6013606.61157 | 2104092.53416 | 37.7582027253025 | -122.39596202861901 | (37.7582027253025, -122.395962028619) | |||
| 181433 | 181433 | 190032 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013600.610230001 | 2104091.57262 | 37.7581997512359 | -122.395982716627 | (37.7581997512359, -122.395982716627) | |||
| 20789 | 20789 | 29999 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 681X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005890.72277 | 2099411.68829 | 37.7449179049514 | -122.422314391296 | (37.7449179049514, -122.422314391296) | ||
| 27326 | 27326 | 190005 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012982.63799 | 2103818.56401 | 37.757415728567295 | -122.398100794529 | (37.7574157285673, -122.398100794529) | ||||
| 45520 | 45520 | 190006 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012982.38984 | 2103806.3309400002 | 37.7573821254062 | -122.398100794542 | (37.7573821254062, -122.398100794542) | ||||
| 158218 | 158218 | 190007 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012984.44615 | 2103792.30277 | 37.7573437216454 | -122.398092698838 | (37.7573437216454, -122.398092698838) | ||||
| 34445 | 34445 | 189999 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Carolina St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6012378.8382 | 2104615.7006200003 | 37.759570841431604 | -122.400244972539 | (37.7595708414316, -122.400244972539) | |||
| 17832 | 17832 | 16310 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997364.820830001 | 2094712.7517799998 | 37.7315311410332 | -122.45145638890499 | (37.7315311410332, -122.451456388905) | ||
| 19514 | 19514 | 16309 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997384.824659999 | 2094713.0859599998 | 37.7315332040811 | -122.45138725623801 | (37.7315332040811, -122.451387256238) | ||
| 22067 | 22067 | 16311 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 3 | 5 | 5997346.34886 | 2094713.5127 | 37.7315321725506 | -122.45152030461901 | (37.7315321725506, -122.451520304619) | ||
| 63471 | 63471 | 206034 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700x Monterey Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 4ft | 5996882.83192 | 2094722.4323900002 | 37.731530109506295 | -122.453123407313 | (37.7315301095063, -122.453123407313) | |||
| 71306 | 71306 | 206033 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700x Monterey Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 4ft | 5996901.71225 | 2094723.16535 | 37.7315332040984 | -122.453058187605 | (37.7315332040984, -122.453058187605) |
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");