Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17470 | 17470 | 29703 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005875.752859999 | 2100395.2692 | 37.7476177497694 | -122.42243602910901 | (37.7476177497694, -122.422436029109) | |||
| 17658 | 17658 | 29711 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005892.92513 | 2100118.18846 | 37.7468579179619 | -122.422356964326 | (37.7468579179619, -122.422356964326) | |||
| 18341 | 18341 | 29708 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005897.61494 | 2100055.38982 | 37.746685751754605 | -122.422336286217 | (37.7466857517546, -122.422336286217) | |||
| 19536 | 19536 | 29706 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005915.3087 | 2099718.0441099997 | 37.745760475271204 | -122.422251139273 | (37.7457604752712, -122.422251139273) | |||
| 19578 | 19578 | 29700 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005880.5001300005 | 2100335.27269 | 37.747453280849 | -122.422415350984 | (37.747453280849, -122.422415350984) | |||
| 20337 | 20337 | 29707 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005916.90216 | 2099727.1189900003 | 37.74578548271 | -122.422246273943 | (37.74578548271, -122.422246273943) | |||
| 21879 | 21879 | 29710 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005894.4456400005 | 2100106.5973900002 | 37.7468261772965 | -122.422350883111 | (37.7468261772965, -122.422350883111) | |||
| 21912 | 21912 | 29701 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005878.92208 | 2100344.0622799997 | 37.7474773260372 | -122.42242143222201 | (37.7474773260372, -122.422421432222) | |||
| 22275 | 22275 | 29704 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005876.958869999 | 2100402.60074 | 37.7476379485377 | -122.422432379649 | (37.7476379485377, -122.422432379649) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 52213 | 52213 | 190002 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012104.02513 | 2104748.44893 | 37.759920011313206 | -122.401204746997 | (37.7599200113132, -122.401204746997) | ||||
| 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) | ||||
| 61054 | 61054 | 247121 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2301 Castro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6002764.34837 | 2098855.27399 | 37.743213271472705 | -122.433085061551 | (37.7432132714727, -122.433085061551) | ||||
| 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) | ||||
| 134896 | 134896 | 120285 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 151 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988326.80885 | 2115016.043 | 37.7867567842415 | -122.484190580999 | (37.7867567842415, -122.484190580999) | ||||
| 137477 | 137477 | 189995 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1301 Minnesota St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015392.22277 | 2102247.2850900004 | 37.753235244428204 | -122.389657680355 | (37.7532352444282, -122.389657680355) | ||||
| 148331 | 148331 | 190003 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1750 22nd St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6012781.6725699995 | 2103797.8962 | 37.7573477838951 | -122.398794366977 | (37.7573477838951, -122.398794366977) | ||||
| 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) | ||||
| 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) | ||
| 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) | |
| 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) | ||||
| 158705 | 158705 | 190031 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1301 Minnesota St | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015368.80756 | 2102249.49615 | 37.753240017127 | -122.389738810018 | (37.753240017127, -122.389738810018) | ||||
| 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) | ||||
| 171539 | 171539 | 190001 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012095.84153 | 2104748.83564 | 37.759920616576 | -122.401233077439 | (37.759920616576, -122.401233077439) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 19207 | 19207 | 546 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2884 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009527.2979999995 | 2102212.4790000003 | 37.752812718682996 | -122.409937408543 | (37.752812718683, -122.409937408543) | |||
| 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) | ||
| 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) | |
| 17378 | 17378 | 29984 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1622X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005923.58357 | 2099590.01571 | 37.7454094051301 | -122.422213431617 | (37.7454094051301, -122.422213431617) | ||
| 17649 | 17649 | 30005 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 795X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005615.08127 | 2098546.14287 | 37.7425257613504 | -122.423205996259 | (37.7425257613504, -122.423205996259) | ||
| 19998 | 19998 | 30014 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005753.20487 | 2098967.8779700003 | 37.7436915444264 | -122.422758369527 | (37.7436915444264, -122.422758369527) | ||
| 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) | ||
| 21577 | 21577 | 30015 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005757.33905 | 2098980.75435 | 37.7437271333024 | -122.422744989392 | (37.7437271333024, -122.422744989392) | ||
| 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) | |||
| 90022 | 90022 | 73786 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1996 12:00:00 AM | 6 | 3x3 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) | |
| 137612 | 137612 | 116891 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2798X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999182.98236 | 2118335.47511 | 37.796497168372795 | -122.446869879744 | (37.7964971683728, -122.446869879744) | |||
| 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) | |||
| 10585 | 10585 | 27651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2700 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982420.6256 | 2096461.5972 | 37.73546591249 | -122.503249937577 | (37.73546591249, -122.503249937577) | ||
| 10607 | 10607 | 27653 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2900X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981776.6997 | 2096484.8387 | 37.7354918543068 | -122.505477915571 | (37.7354918543068, -122.505477915571) | ||
| 11897 | 11897 | 27649 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982997.5613 | 2096369.9984 | 37.7352483041994 | -122.501248513045 | (37.7352483041994, -122.501248513045) | ||
| 12298 | 12298 | 27647 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 5983545.7870000005 | 2096052.8205 | 37.7344095981993 | -122.499329695326 | (37.7344095981993, -122.499329695326) | |||
| 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) | |||
| 78812 | 78812 | 27652 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2830 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982048.7143342 | 2096528.9941474 | 37.7356290969828 | -122.50454074467 | (37.7356290969828, -122.50454074467) | ||
| 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) | ||
| 97575 | 97575 | 27646 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2260 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5983743.832098301 | 2096000.4658733997 | 37.7342774634165 | -122.498641133162 | (37.7342774634165, -122.498641133162) | ||
| 106072 | 106072 | 27650 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2650 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982609.4890242005 | 2096515.7957863999 | 37.735625827225796 | -122.502600986809 | (37.7356258272258, -122.502600986809) | ||
| 143088 | 143088 | 27648 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2400 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5983342.3231549 | 2096264.1854035999 | 37.7349780102042 | -122.50004874464199 | (37.7349780102042, -122.500048744642) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 45626 | 45626 | 186972 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5982510.8573 | 2096452.0272 | 37.7354449395599 | -122.50293726958999 | (37.7354449395599, -122.50293726959) | |||
| 147217 | 147217 | 186971 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5983094.6287 | 2096334.4526 | 37.7351564048044 | -122.50091029299801 | (37.7351564048044, -122.500910292998) | |||
| 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) | |||
| 31524 | 31524 | 175845 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 98 Newton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000912.9484 | 2087984.8955700002 | 37.7132605143345 | -122.43870794134399 | (37.7132605143345, -122.438707941344) | |||
| 54322 | 54322 | 206026 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5994921.599769999 | 2093400.11628 | 37.727786752547296 | -122.45980797188601 | (37.7277867525473, -122.459807971886) | |||
| 57805 | 57805 | 206027 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5994921.23721 | 2093409.63408 | 37.7278128652723 | -122.459809914392 | (37.7278128652723, -122.459809914392) | |||
| 45328 | 45328 | 225157 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010022.83769 | 2099819.01097 | 37.7462685436666 | -122.408054953167 | (37.7462685436666, -122.408054953167) | |||
| 148722 | 148722 | 225150 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 21 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007236.93234 | 2099402.00378 | 37.744967159016596 | -122.417658748554 | (37.7449671590166, -122.417658748554) | |||
| 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) | |||
| 157715 | 157715 | 225155 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010008.90641 | 2099846.42229 | 37.7463430291237 | -122.40810505891199 | (37.7463430291237, -122.408105058912) | |||
| 172815 | 172815 | 225154 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6010002.80385 | 2099859.8218 | 37.7463794795488 | -122.40812710578999 | (37.7463794795488, -122.40812710579) | |||
| 183926 | 183926 | 225156 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010015.03813 | 2099834.46528 | 37.746310541115896 | -122.408083012937 | (37.7463105411159, -122.408083012937) | |||
| 601 | 601 | 225172 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2002 12:00:00 AM | 9 | Width 3ft | Permit Number 46150 | 6006535.621280001 | 2098220.1400900004 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | |
| 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) | |||
| 25803 | 25803 | 225170 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009137.3737 | 2096981.67824 | 37.7384282324737 | -122.410916429557 | (37.7384282324737, -122.410916429557) | |||
| 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) | |||
| 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) | |||
| 27590 | 27590 | 225203 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005899.22105 | 2100030.8366400003 | 37.746618424914296 | -122.422328988218 | (37.7466184249143, -122.422328988218) | |||
| 29299 | 29299 | 225151 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 14 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007510.1037 | 2099736.8177900002 | 37.7459018513879 | -122.416737884151 | (37.7459018513879, -122.416737884151) | |||
| 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) | |||
| 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) | |||
| 34889 | 34889 | 175846 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 210 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012734.12087 | 2087510.3732 | 37.7126229867466 | -122.397816364158 | (37.7126229867466, -122.397816364158) | |||
| 35962 | 35962 | 225200 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1622x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005924.11488 | 2099598.76228 | 37.74543345119329 | -122.42221221572599 | (37.7454334511933, -122.422212215726) | |||
| 37075 | 37075 | 225178 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 858 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007945.63288 | 2102930.5151400003 | 37.754695511392605 | -122.41545794294301 | (37.7546955113926, -122.415457942943) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 44503 | 44503 | 225169 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 225 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008644.12934 | 2097539.28369 | 37.7399316246566 | -122.412661242936 | (37.7399316246566, -122.412661242936) | |||
| 45931 | 45931 | 190000 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 770 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6012104.84568 | 2104756.14819 | 37.7599411975544 | -122.401202450128 | (37.7599411975544, -122.401202450128) |
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");