Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 183433 | 183433 | 206043 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994997.50397 | 2091203.21567 | 37.721758956587294 | -122.459386538764 | (37.7217589565873, -122.459386538764) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 152995 | 152995 | 225179 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007756.33933 | 2106453.2465 | 37.764357479442 | -122.41636207364799 | (37.764357479442, -122.416362073648) | |||
| 168817 | 168817 | 206042 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994983.67365 | 2091204.0797700002 | 37.7217605339977 | -122.45943440879101 | (37.7217605339977, -122.459434408791) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | |||
| 178979 | 178979 | 206041 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994962.333219999 | 2091204.5266599997 | 37.7217605340024 | -122.459508208932 | (37.7217605340024, -122.459508208932) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 146819 | 146819 | 225192 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007260.94104 | 2103859.736 | 37.757208430341294 | -122.41789166399299 | (37.7572084303413, -122.417891663993) | |||
| 147255 | 147255 | 225182 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007750.95097 | 2106539.82911 | 37.764594912141206 | -122.416386843697 | (37.7645949121412, -122.416386843697) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 165711 | 165711 | 225191 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007257.73573 | 2103878.07853 | 37.7572586143179 | -122.41790404944099 | (37.7572586143179, -122.417904049441) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 84096 | 84096 | 225197 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | |||
| 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) | |||
| 162917 | 162917 | 206039 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996261.11762 | 2091797.78089 | 37.723464064001895 | -122.455061523695 | (37.7234640640019, -122.455061523695) | |||
| 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) | |||
| 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) | |||
| 171827 | 171827 | 225158 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007618.37358 | 2102060.04095 | 37.7522869875715 | -122.416528039931 | (37.7522869875715, -122.416528039931) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");