Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
| 1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
| 5624 | 5624 | 23856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003669.3238 | 2113580.0643 | 37.7836952941839 | -122.4310065985 | (37.7836952941839, -122.4310065985) | |||
| 5634 | 5634 | 23786 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 8X8 | 6003813.7072 | 2112544.6294 | 37.780860428691895 | -122.43043318397301 | (37.7808604286919, -122.430433183973) | |||
| 5919 | 5919 | 28639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300 Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003713.3264 | 2113228.0439 | 37.7827312275464 | -122.43082923608401 | (37.7827312275464, -122.430829236084) | |||
| 6248 | 6248 | 23822 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6003768.3296 | 2112880.8363 | 37.7817809984294 | -122.430614164895 | (37.7817809984294, -122.430614164895) | |||
| 7299 | 7299 | 23726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 6 | 6003954.9966 | 2111561.7912 | 37.778169801288904 | -122.42987426911101 | (37.7781698012889, -122.429874269111) | |||
| 7490 | 7490 | 23861 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6003632.8842 | 2113765.0125 | 37.784201050677794 | -122.43114587096201 | (37.7842010506778, -122.431145870962) | |||
| 8386 | 8386 | 23762 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003876.9608 | 2112076.071 | 37.7795774666707 | -122.430180921789 | (37.7795774666707, -122.430180921789) | |||
| 8710 | 8710 | 23858 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003660.3858 | 2113644.0055 | 37.7838703542221 | -122.43104208573999 | (37.7838703542221, -122.43104208574) | |||
| 8968 | 8968 | 23829 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003737.3903 | 2113105.6618 | 37.782396560281 | -122.430737249093 | (37.782396560281, -122.430737249093) | |||
| 10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
| 10756 | 10756 | 110237 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Winston Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6x18 | 5989487.1744800005 | 2093569.3277200002 | 37.7279373404144 | -122.47860704469 | (37.7279373404144, -122.47860704469) | |||
| 13421 | 13421 | 6561 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6016932.91962 | 2097582.94738 | 37.740513241395604 | -122.384004813584 | (37.7405132413956, -122.384004813584) | |||
| 13446 | 13446 | 6607 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016551.319490001 | 2097860.71449 | 37.741254829556105 | -122.38534360193898 | (37.7412548295561, -122.385343601939) | ||
| 13615 | 13615 | 6529 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017368.28124 | 2097249.13872 | 37.7396207290066 | -122.382476267371 | (37.7396207290066, -122.382476267371) | |||
| 13624 | 13624 | 6521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017462.61912 | 2097188.96881 | 37.739460725233606 | -122.38214589961599 | (37.7394607252336, -122.382145899616) | |||
| 13896 | 13896 | 6519 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017483.589869999 | 2097174.66185 | 37.739422599379104 | -122.38207239623699 | (37.7394225993791, -122.382072396237) | |||
| 13967 | 13967 | 6617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016412.3999 | 2097961.86068 | 37.741524869881104 | -122.38583098952101 | (37.7415248698811, -122.385830989521) | |||
| 14278 | 14278 | 6523 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017441.22819 | 2097205.1052900003 | 37.739503851329495 | -122.382220983128 | (37.7395038513295, -122.382220983128) | |||
| 14296 | 14296 | 6512 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017582.68074 | 2097100.7392400003 | 37.7392250947568 | -122.381724640105 | (37.7392250947568, -122.381724640105) | |||
| 14456 | 14456 | 6537 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017269.15486 | 2097321.24148 | 37.7398132324937 | -122.38282402351999 | (37.7398132324937, -122.38282402352) | |||
| 14481 | 14481 | 6524 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6017425.7364 | 2097207.6932200002 | 37.7395101016101 | -122.382274727523 | (37.7395101016101, -122.382274727523) | |||
| 14571 | 14571 | 6615 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016429.61259 | 2097949.5600400004 | 37.7414920473285 | -122.385770616219 | (37.7414920473285, -122.385770616219) | |||
| 14619 | 14619 | 6528 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017381.090340001 | 2097249.5639299997 | 37.739622604108796 | -122.382432008146 | (37.7396226041088, -122.382432008146) | |||
| 14699 | 14699 | 6616 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016425.355719999 | 2097963.9541599997 | 37.741531335091295 | -122.385786338186 | (37.7415313350913, -122.385786338186) | |||
| 14858 | 14858 | 6530 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017366.22044 | 2097260.33377 | 37.7396513545281 | -122.38248417152799 | (37.7396513545281, -122.382484171528) | |||
| 15027 | 15027 | 6531 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017348.91467 | 2097263.64113 | 37.7396594798919 | -122.38254423812599 | (37.7396594798919, -122.382544238126) | |||
| 15109 | 15109 | 6526 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017409.27613 | 2097218.95029 | 37.7395401020909 | -122.382332423519 | (37.7395401020909, -122.382332423519) | ||
| 15150 | 15150 | 6612 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6016472.61883 | 2097917.5413 | 37.7414065100921 | -122.385619683024 | (37.7414065100921, -122.385619683024) | |||
| 15309 | 15309 | 6525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017423.67126 | 2097218.66072 | 37.7395401020993 | -122.382282630765 | (37.7395401020993, -122.382282630765) | ||
| 15501 | 15501 | 6536 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017286.0724599995 | 2097321.35634 | 37.739814482555204 | -122.382765536994 | (37.7398144825552, -122.382765536994) | |||
| 15734 | 15734 | 6522 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017447.32839 | 2097190.1869 | 37.7394632253474 | -122.382198853519 | (37.7394632253474, -122.382198853519) | |||
| 15818 | 15818 | 6516 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017508.57687 | 2097144.1126599999 | 37.7393400973684 | -122.38198387686899 | (37.7393400973684, -122.381983876869) | |||
| 15982 | 15982 | 6527 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 15 | 6017405.21421 | 2097232.9171599997 | 37.7395782279507 | -122.382347439479 | (37.7395782279507, -122.382347439479) | |||
| 16031 | 16031 | 6586 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X Evans Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 15 | 6017026.1395 | 2097501.4027299997 | 37.740294489412 | -122.38367681643 | (37.740294489412, -122.38367681643) | |||
| 16058 | 16058 | 6562 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6016920.77309 | 2097581.3708900004 | 37.7405082411515 | -122.384046702218 | (37.7405082411515, -122.384046702218) | |||
| 16076 | 16076 | 6613 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016450.58483 | 2097934.2856900003 | 37.741451267574206 | -122.385697036412 | (37.7414512675742, -122.385697036412) | |||
| 16465 | 16465 | 6535 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017290.8428 | 2097308.51335 | 37.739779481837296 | -122.382748149519 | (37.7397794818373, -122.382748149519) | |||
| 16655 | 16655 | 6515 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15 | 6017527.69247 | 2097139.8588 | 37.7393294727638 | -122.38191748711999 | (37.7393294727638, -122.38191748712) | |||
| 16774 | 16774 | 6564 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016897.83831 | 2097600.27015 | 37.740558866707794 | -122.384127318327 | (37.7405588667078, -122.384127318327) | |||
| 16850 | 16850 | 6563 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 4 | 6016917.30927 | 2097594.07629 | 37.7405429361116 | -122.384059563412 | (37.7405429361116, -122.384059563412) | |||
| 18484 | 18484 | 12450 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 28151 | 28151 | 140415 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100x WEBSTER ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6003782.7679 | 2112770.1424 | 37.7814778785376 | -122.430556314217 | (37.7814778785376, -122.430556314217) | |||
| 66037 | 66037 | 121471 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102X King St | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.779753015830394 | -122.38979944679701 | (37.7797530158304, -122.389799446797) | |||
| 80509 | 80509 | 110645 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 81080 | 81080 | 6509 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017579.3120099995 | 2097108.75601 | 37.739246921189 | -122.38173684520201 | (37.739246921189, -122.381736845202) | |||
| 81615 | 81615 | 6533 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017399.15501 | 2097229.47901 | 37.7395684527942 | -122.382368150642 | (37.7395684527942, -122.382368150642) | |||
| 82803 | 82803 | 102580 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 84036 | 84036 | 27864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 84807 | 84807 | 6518 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017386.15401 | 2097259.19601 | 37.739649331573794 | -122.38241516995899 | (37.7396493315738, -122.382415169959) | |||
| 84810 | 84810 | 12452 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 86558 | 86558 | 6582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 87354 | 87354 | 6619 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 88290 | 88290 | 6520 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017343.43601 | 2097287.05501 | 37.739723467052 | -122.382564809911 | (37.739723467052, -122.382564809911) | |||
| 89385 | 89385 | 27863 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90241 | 90241 | 27861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90513 | 90513 | 102577 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 92233 | 92233 | 111089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10x HIGUERA AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777485 | 5988057.0 | 2090190.0 | 37.7185754269376 | -122.483303520979 | (37.7185754269376, -122.483303520979) | |
| 92877 | 92877 | 110644 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 94947 | 94947 | 27865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 96408 | 96408 | 6618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 98042 | 98042 | 110643 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 98126 | 98126 | 6534 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017423.300009999 | 2097212.76401 | 37.7395238904111 | -122.38228350426901 | (37.7395238904111, -122.382283504269) | |||
| 98816 | 98816 | 102575 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 102665 | 102665 | 102582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 103293 | 103293 | 102578 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 103806 | 103806 | 6583 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 104060 | 104060 | 12451 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 104698 | 104698 | 27952 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 106432 | 106432 | 23862 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003700.6561807 | 2113512.2535027 | 37.7835108780695 | -122.430893359317 | (37.7835108780695, -122.430893359317) | |||
| 106689 | 106689 | 6584 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 106951 | 106951 | 27956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 107848 | 107848 | 6514 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017471.58901 | 2097190.47601 | 37.7394653591044 | -122.38211499016899 | (37.7394653591044, -122.382114990169) | |||
| 108807 | 108807 | 27718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 09/11/2000 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 109774 | 109774 | 6517 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017408.44101 | 2097236.90801 | 37.7395893642582 | -122.382336560068 | (37.7395893642582, -122.382336560068) | |||
| 110146 | 110146 | 27862 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 112385 | 112385 | 23793 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8X8 | 6003842.3480155 | 2112491.7749097 | 37.7807169257712 | -122.43033032933701 | (37.7807169257712, -122.430330329337) | |||
| 114418 | 114418 | 27957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 114644 | 114644 | 6532 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017378.72501 | 2097246.19501 | 37.739613223073796 | -122.38243995218599 | (37.7396132230738, -122.382439952186) | |||
| 114785 | 114785 | 110640 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 116119 | 116119 | 110641 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 116609 | 116609 | 6609 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | ||
| 116954 | 116954 | 6614 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 118377 | 118377 | 110639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 118582 | 118582 | 6581 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 118625 | 118625 | 6606 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 118940 | 118940 | 23755 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 8X8 | 6003937.3073429 | 2111811.4900601003 | 37.7788544107823 | -122.42995327885001 | (37.7788544107823, -122.42995327885) | |||
| 120593 | 120593 | 102581 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 121576 | 121576 | 102579 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 122168 | 122168 | 12453 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 125964 | 125964 | 110638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 127553 | 127553 | 12454 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127742 | 127742 | 12455 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 128153 | 128153 | 110637 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | ||||
| 128222 | 128222 | 27953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 128446 | 128446 | 27860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 140645 | 140645 | 27955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 145142 | 145142 | 27954 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 145206 | 145206 | 102576 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) |
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");