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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38646 | 38646 | 201508 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018593.65925 | 2094901.94124 | 37.7332433998449 | -122.378076502435 | (37.7332433998449, -122.378076502435) | |||
| 70787 | 70787 | 201506 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018588.36983 | 2094906.5368 | 37.7332557268509 | -122.378095108499 | (37.7332557268509, -122.378095108499) | |||
| 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) | ||
| 153857 | 153857 | 201507 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018590.61876 | 2094904.2906900002 | 37.733249683412296 | -122.37808717738599 | (37.7332496834123, -122.378087177386) | |||
| 166097 | 166097 | 201509 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018596.778580001 | 2094899.20439 | 37.73323605689679 | -122.378065528029 | (37.7332360568968, -122.378065528029) | |||
| 181426 | 181426 | 201513 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018634.55292 | 2094871.3359599998 | 37.7331616173072 | -122.377932996723 | (37.7331616173072, -122.377932996723) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 66694 | 66694 | 225148 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1199 Capp St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6007231.69522 | 2100624.49408 | 37.7483235475968 | -122.417763493512 | (37.7483235475968, -122.417763493512) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 54105 | 54105 | 206046 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 82 Ventura Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994334.26497 | 2101814.09479 | 37.750855650885605 | -122.462448420067 | (37.7508556508856, -122.462448420067) | |||
| 59914 | 59914 | 206025 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991157.5258599995 | 2106131.34791 | 37.76252624212071 | -122.473748679463 | (37.7625262421207, -122.473748679463) | |||
| 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) | ||||
| 67868 | 67868 | 206024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991156.52884 | 2106111.8053099997 | 37.7624725256075 | -122.473750702041 | (37.7624725256075, -122.473750702041) | |||
| 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) | ||||
| 70063 | 70063 | 225186 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 252 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007150.88723 | 2105850.08612 | 37.762667276482894 | -122.418413397566 | (37.7626672764829, -122.418413397566) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 147063 | 147063 | 189996 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012291.07861 | 2105130.95435 | 37.7609807203027 | -122.400584686038 | (37.7609807203027, -122.400584686038) | |||
| 150193 | 150193 | 206044 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 275 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991926.36894 | 2090353.75557 | 37.7192494901497 | -122.46994073500099 | (37.7192494901497, -122.469940735001) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 52220 | 52220 | 225202 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005906.49686 | 2099871.3036700003 | 37.7461807941146 | -122.422292496403 | (37.7461807941146, -122.422292496403) | |||
| 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) | |||
| 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) | |
| 131163 | 131163 | 225201 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005907.02025 | 2099862.53576 | 37.7461567489521 | -122.422290063739 | (37.7461567489521, -122.422290063739) | |||
| 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) | |||
| 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) | |||
| 150087 | 150087 | 225171 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006678.67564 | 2099088.45084 | 37.7440747833339 | -122.419566860849 | (37.7440747833339, -122.419566860849) | |||
| 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) | |||
| 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) | |||
| 163945 | 163945 | 206035 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700x Monterey Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 5996866.22235 | 2094722.0274099999 | 37.7315280455795 | -122.453180800271 | (37.7315280455795, -122.453180800271) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 47236 | 47236 | 225176 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1020 Alabama St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6009156.40291 | 2103118.80305 | 37.7552804871291 | -122.411284056222 | (37.7552804871291, -122.411284056222) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 63388 | 63388 | 225185 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007746.072980001 | 2106673.2030700003 | 37.764960851679 | -122.41641316324 | (37.764960851679, -122.41641316324) | |||
| 76939 | 76939 | 225183 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007749.18821 | 2106563.04323 | 37.7646585535855 | -122.416394585035 | (37.7646585535855, -122.416394585035) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | |||
| 166068 | 166068 | 225181 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.17494 | 2106512.16868 | 37.7645190318645 | -122.41638065094801 | (37.7645190318645, -122.416380650948) | |||
| 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) | |||
| 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) | |||
| 183184 | 183184 | 225180 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007753.3624 | 2106482.72591 | 37.7644382556423 | -122.416374458236 | (37.7644382556423, -122.416374458236) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 45461 | 45461 | 189994 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1150x Tennessee St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 6015560.24014 | 2103579.83014 | 37.756903445945795 | -122.389169674966 | (37.7569034459458, -122.389169674966) | |||
| 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) |
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");