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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 40599 | 40599 | 190014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 8ft | 6012452.605140001 | 2108628.1137900003 | 37.770592145536 | -122.400271663513 | (37.770592145536, -122.400271663513) | |||
| 160931 | 160931 | 126014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2322 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5999611.42315 | 2120546.01877 | 37.8025911966964 | -122.445546423945 | (37.8025911966964, -122.445546423945) | |||
| 177844 | 177844 | 190013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 8ft | 6012319.46536 | 2108768.17498 | 37.7709692969125 | -122.40074203953002 | (37.7709692969125, -122.40074203953) | |||
| 23690 | 23690 | 126012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5999234.571959999 | 2117780.83993 | 37.7949772349663 | -122.446651443424 | (37.7949772349663, -122.446651443424) | |||
| 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) | |||
| 166960 | 166960 | 126011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 5999243.15513 | 2117721.3039700002 | 37.7948142553315 | -122.446617458939 | (37.7948142553315, -122.446617458939) | |||
| 171439 | 171439 | 126013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5999233.22196 | 2117805.48778 | 37.795044834292895 | -122.44665788886499 | (37.7950448342929, -122.446657888865) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 60204 | 60204 | 189997 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6012307.781769999 | 2105132.0490099997 | 37.760984657528894 | -122.40052699363501 | (37.7609846575289, -122.400526993635) | |||
| 130881 | 130881 | 225147 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1706 Dolores St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6005278.315280001 | 2098374.8158 | 37.7420363251164 | -122.424358251742 | (37.7420363251164, -122.424358251742) | |||
| 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) | |||
| 148481 | 148481 | 225146 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1706 Dolores St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005275.161069999 | 2098395.65522 | 37.7420933673216 | -122.424370639893 | (37.7420933673216, -122.424370639893) | |||
| 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) | |||
| 156182 | 156182 | 189998 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1950 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011839.98262 | 2105629.53813 | 37.7623245520575 | -122.402179893599 | (37.7623245520575, -122.402179893599) | |||
| 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) | |||
| 25509 | 25509 | 190026 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015544.83514 | 2108320.68008 | 37.769919941866895 | -122.389554039808 | (37.7699199418669, -122.389554039808) | |||
| 27419 | 27419 | 190015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015573.49943 | 2107841.28907 | 37.768605228364 | -122.38942140686899 | (37.768605228364, -122.389421406869) | |||
| 42492 | 42492 | 247161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2399 Market St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 5ft | 6002372.95372 | 2105936.54637 | 37.7626345492748 | -122.43494472103998 | (37.7626345492748, -122.43494472104) | |||
| 44856 | 44856 | 190023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015540.26875 | 2108442.1367599997 | 37.770253182080396 | -122.38957831879499 | (37.7702531820804, -122.389578318795) | |||
| 49236 | 49236 | 190022 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015535.32333 | 2108481.6321099997 | 37.770361353431895 | -122.389598183934 | (37.7703613534319, -122.389598183934) | |||
| 49887 | 49887 | 190019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015583.6961 | 2107674.48805 | 37.7681477945165 | -122.389374487455 | (37.7681477945165, -122.389374487455) | |||
| 66360 | 66360 | 190027 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015553.64576 | 2108193.7384099998 | 37.7695718763733 | -122.389514697159 | (37.7695718763733, -122.389514697159) | |||
| 68768 | 68768 | 190029 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015559.81581 | 2108067.16285 | 37.7692246696975 | -122.38948451411999 | (37.7692246696975, -122.38948451412) | |||
| 71985 | 71985 | 190021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015535.23888 | 2108524.8420599997 | 37.7704799937881 | -122.389601494338 | (37.7704799937881, -122.389601494338) | |||
| 130988 | 130988 | 190030 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015562.57352 | 2108029.9349599998 | 37.7691226029579 | -122.389472375051 | (37.7691226029579, -122.389472375051) | |||
| 132041 | 132041 | 190025 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015543.83866 | 2108366.1327 | 37.7700446895441 | -122.389560661497 | (37.7700446895441, -122.389560661497) | |||
| 153266 | 153266 | 190024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015540.58409 | 2108410.35977 | 37.7701659469215 | -122.389575008383 | (37.7701659469215, -122.389575008383) | |||
| 160516 | 160516 | 190020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015584.43667 | 2107642.2623 | 37.768059350697996 | -122.38936967519699 | (37.768059350698, -122.389369675197) | |||
| 163882 | 163882 | 190016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015575.880530001 | 2107804.1814599996 | 37.7685034709891 | -122.38941057906099 | (37.7685034709891, -122.389410579061) | |||
| 172905 | 172905 | 190028 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015555.80017 | 2108152.70829 | 37.7694593361018 | -122.389504379223 | (37.7694593361018, -122.389504379223) | |||
| 181059 | 181059 | 190017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015580.20075 | 2107759.76126 | 37.7683817423455 | -122.389392533258 | (37.7683817423455, -122.389392533258) | |||
| 182780 | 182780 | 190018 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015579.842180001 | 2107724.78714 | 37.7682856911689 | -122.38939133086399 | (37.7682856911689, -122.389391330864) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38579 | 38579 | 190011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1599 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6014210.748430001 | 2095415.1555299999 | 37.7344100624646 | -122.39326543937 | (37.7344100624646, -122.39326543937) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 149483 | 149483 | 225211 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 83 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6006284.028469999 | 2099592.34977 | 37.74543613838021 | -122.42096723475402 | (37.7454361383802, -122.420967234754) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 49570 | 49570 | 225173 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 98 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006194.79816 | 2097580.2396 | 37.7399063069243 | -122.42113293303998 | (37.7399063069243, -122.42113293304) | |||
| 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) | |||
| 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) | |||
| 50903 | 50903 | 225174 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1000 Jarboe Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6009367.84971 | 2096849.47647 | 37.738078156068894 | -122.410110221514 | (37.7380781560689, -122.410110221514) | |||
| 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) | |||
| 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) | |||
| 57244 | 57244 | 126010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 85 Toledo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001465.00623 | 2119940.72568 | 37.801034867711 | -122.43908870440599 | (37.801034867711, -122.439088704406) | |||
| 58330 | 58330 | 206036 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996259.37903 | 2091732.03952 | 37.7232834540474 | -122.455062785437 | (37.7232834540474, -122.455062785437) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 65401 | 65401 | 190004 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1745 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 6012733.96255 | 2104688.60274 | 37.7597908102085 | -122.399021884672 | (37.7597908102085, -122.399021884672) | |||
| 67172 | 67172 | 175847 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 210 Tocoloma Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012727.81245 | 2087493.92668 | 37.7125774765391 | -122.397837015259 | (37.7125774765391, -122.397837015259) | |||
| 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) | |||
| 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) | |||
| 70642 | 70642 | 206037 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996260.563569999 | 2091771.26312 | 37.72339122070879 | -122.45506152367201 | (37.7233912207088, -122.455061523672) | |||
| 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) | |||
| 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) | |||
| 73909 | 73909 | 225153 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 105 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010058.65262 | 2099813.08608 | 37.7462542804284 | -122.407930691168 | (37.7462542804284, -122.407930691168) | |||
| 74897 | 74897 | 206045 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 260 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992364.28925 | 2095097.86508 | 37.732300949933 | -122.468772052499 | (37.732300949933, -122.468772052499) |
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");