Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189135 | 189135 | 195300 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6013572.66775 | 2116629.13955 | 37.7926235212146 | -122.396958390217 | (37.7926235212146, -122.396958390217) | |||
| 189118 | 189118 | 133769 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2410 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001287.40015 | 2116702.6121799997 | 37.79213375041721 | -122.439471043978 | (37.7921337504172, -122.439471043978) | |||
| 189105 | 189105 | 235453 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 443 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006172.18998 | 2107045.3171200003 | 37.7658939558577 | -122.421883272498 | (37.7658939558577, -122.421883272498) | |||
| 189102 | 189102 | 238781 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3050 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007897.85689 | 2103290.78904 | 37.7556820560028 | -122.415648672958 | (37.7556820560028, -122.415648672958) | |||
| 189074 | 189074 | 184106 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5987259.8119 | 2104360.815 | 37.757438327672205 | -122.487099234581 | (37.7574383276722, -122.487099234581) | |||
| 189069 | 189069 | 195235 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017260.82922 | 2097339.16357 | 37.7398619829554 | -122.382854057268 | (37.7398619829554, -122.382854057268) | ||||
| 189039 | 189039 | 117389 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006295.544430001 | 2117317.5523599996 | 37.7941059690696 | -122.42218647533998 | (37.7941059690696, -122.42218647534) | |||
| 189035 | 189035 | 195706 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014489.99692 | 2110956.01492 | 37.777097439219204 | -122.39338718236601 | (37.7770974392192, -122.393387182366) | |||
| 189031 | 189031 | 134365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006003.89735 | 2113165.73066 | 37.782689643164396 | -122.422900390454 | (37.7826896431644, -122.422900390454) | |||
| 189021 | 189021 | 182962 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2050 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5989686.5492 | 2098375.4265 | 37.741145229321496 | -122.47826907299999 | (37.7411452293215, -122.478269073) | |||
| 188989 | 188989 | 110597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6009274.88021 | 2115156.652 | 37.7883402580439 | -122.411724859841 | (37.7883402580439, -122.411724859841) | |||
| 188970 | 188970 | 134111 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2716 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001138.54268 | 2117794.6215 | 37.7951236499858 | -122.44006443013599 | (37.7951236499858, -122.440064430136) | |||
| 188935 | 188935 | 133649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003131.50337 | 2120909.28227 | 37.8037889533516 | -122.433391166484 | (37.8037889533516, -122.433391166484) | |||
| 188934 | 188934 | 110474 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 745 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 6x9 | 6004444.60179 | 2111147.58704 | 37.77706021269321 | -122.42815102017799 | (37.7770602126932, -122.428151020178) | |||
| 188932 | 188932 | 246287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2312 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002715.3396 | 2106368.9627 | 37.763841293949206 | -122.433791440708 | (37.7638412939492, -122.433791440708) | |||
| 188931 | 188931 | 195333 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 109 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014551.003930001 | 2116991.43348 | 37.793672705393 | -122.393598652577 | (37.793672705393, -122.393598652577) | |||
| 188925 | 188925 | 238649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003254.383880001 | 2096371.53066 | 37.736421268524296 | -122.431213399685 | (37.7364212685243, -122.431213399685) | |||
| 188886 | 188886 | 133471 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996792.4764 | 2114679.48373 | 37.7863219446349 | -122.45487721212601 | (37.7863219446349, -122.454877212126) | |||
| 188869 | 188869 | 178549 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008341.68171 | 2086226.9900599997 | 37.7088534882771 | -122.412907384688 | (37.7088534882771, -122.412907384688) | |||
| 188837 | 188837 | 211917 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 175 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993542.1892099995 | 2096437.97139 | 37.7360485283247 | -122.464797098516 | (37.7360485283247, -122.464797098516) | |||
| 188828 | 188828 | 134570 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6007837.8897 | 2111537.36864 | 37.7783218653083 | -122.416440161792 | (37.7783218653083, -122.416440161792) | |||
| 188827 | 188827 | 133432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3441 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998326.4929599995 | 2115837.90969 | 37.78959055311179 | -122.449653439748 | (37.7895905531118, -122.449653439748) | |||
| 188823 | 188823 | 134494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 40 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008299.31675 | 2112014.9634 | 37.7796591643693 | -122.414877720157 | (37.7796591643693, -122.414877720157) | |||
| 188808 | 188808 | 238600 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 237 Murray St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6005691.958380001 | 2095367.93673 | 37.733803458053295 | -122.42271436928002 | (37.7338034580533, -122.42271436928) | |||
| 188769 | 188769 | 133345 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2425 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6001362.13344 | 2118652.49783 | 37.797491879699294 | -122.439352295671 | (37.7974918796993, -122.439352295671) | |||
| 188766 | 188766 | 195505 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 310 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016088.055509999 | 2114960.80384 | 37.7881823478758 | -122.38813849699801 | (37.7881823478758, -122.388138496998) | |||
| 188752 | 188752 | 234743 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 213 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6002025.5801800005 | 2107323.81598 | 37.76642392273929 | -122.436245443785 | (37.7664239227393, -122.436245443785) | |||
| 188749 | 188749 | 195752 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6013854.46452 | 2110347.99192 | 37.7753926151225 | -122.395543095641 | (37.7753926151225, -122.395543095641) | |||
| 188744 | 188744 | 201233 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1005 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009633.9629 | 2112852.2166 | 37.7820329664559 | -122.410319714188 | (37.7820329664559, -122.410319714188) | |||
| 188739 | 188739 | 135400 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 409 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013205.1806 | 2117586.1059 | 37.795230662116204 | -122.39829709133998 | (37.7952306621162, -122.39829709134) | |||
| 188693 | 188693 | 235525 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008688.10324 | 2100617.89317 | 37.748387274459795 | -122.41272678733499 | (37.7483872744598, -122.412726787335) | |||
| 188691 | 188691 | 60492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1982 12:00:00 AM | 16 | Permit Number 20090 | 6005025.8027 | 2113323.9775 | 37.783068912088 | -122.42629545390699 | (37.783068912088, -122.426295453907) | ||
| 188683 | 188683 | 195062 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1176 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010220.876209999 | 2109998.84251 | 37.7742311523704 | -122.4080879583 | (37.7742311523704, -122.4080879583) | |||
| 188679 | 188679 | 195297 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6013537.78913 | 2116581.28992 | 37.792490195823 | -122.39707571577401 | (37.792490195823, -122.397075715774) | |||
| 188619 | 188619 | 211936 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 55 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5994719.6585800005 | 2100681.91633 | 37.7477691605281 | -122.461033650677 | (37.7477691605281, -122.461033650677) | |||
| 188579 | 188579 | 211979 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5994076.7802 | 2098163.7348 | 37.74081785256279 | -122.46307399209101 | (37.7408178525628, -122.463073992091) | |||
| 188572 | 188572 | 134679 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1140 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008456.11082 | 2115942.6628799997 | 37.790452487636706 | -122.414613322157 | (37.7904524876367, -122.414613322157) | |||
| 188542 | 188542 | 235326 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005964.930369999 | 2100592.21666 | 37.7481635528115 | -122.422141647734 | (37.7481635528115, -122.422141647734) | |||
| 188537 | 188537 | 133826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000850.9197 | 2115943.2881 | 37.790023993954705 | -122.44092677206001 | (37.7900239939547, -122.44092677206) | |||
| 188536 | 188536 | 134753 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 899 Beach St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006145.35234 | 2121749.49572 | 37.806266486670005 | -122.42302131061199 | (37.80626648667, -122.423021310612) | |||
| 188527 | 188527 | 235410 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 906 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008565.51652 | 2103168.60565 | 37.755384076426296 | -122.41333104631201 | (37.7553840764263, -122.413331046312) | |||
| 188521 | 188521 | 250295 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 6008359.254290001 | 2112041.46764 | 37.7797353063774 | -122.41467224575199 | (37.7797353063774, -122.414672245752) | |||
| 188517 | 188517 | 123655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4327 Cornwall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994139.46706 | 2114167.5688 | 37.7847638226809 | -122.464018698388 | (37.7847638226809, -122.464018698388) | |||
| 188513 | 188513 | 195243 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1638 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014980.6206 | 2096956.55885 | 37.7386851822676 | -122.39071139803801 | (37.7386851822676, -122.390711398038) | |||
| 188503 | 188503 | 106738 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006290.51922 | 2117597.30119 | 37.7948738057383 | -122.42222374772301 | (37.7948738057383, -122.422223747723) | |
| 188502 | 188502 | 134728 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005744.36819 | 2119775.16172 | 37.8008228372578 | -122.42426847872801 | (37.8008228372578, -122.424268478728) | |||
| 188497 | 188497 | 142028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 656 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004634.2969 | 2111243.3055 | 37.77733376308 | -122.42750162616301 | (37.77733376308, -122.427501626163) | |||
| 188496 | 188496 | 133943 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000713.96816 | 2116942.6904 | 37.7927602910006 | -122.44147235657499 | (37.7927602910006, -122.441472356575) | |||
| 188490 | 188490 | 134437 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007232.29219 | 2112385.20525 | 37.780615745351795 | -122.418595290833 | (37.7806157453518, -122.418595290833) | |||
| 188469 | 188469 | 123596 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994578.99171 | 2114276.7307700003 | 37.785088872597896 | -122.462506019888 | (37.7850888725979, -122.462506019888) | |||
| 188468 | 188468 | 139506 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1384 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001156.9846 | 2111108.7635 | 37.7767670534701 | -122.439521104039 | (37.7767670534701, -122.439521104039) | |||
| 188466 | 188466 | 195757 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6013768.34755 | 2110264.7977 | 37.77515939213121 | -122.395835165769 | (37.7751593921312, -122.395835165769) | |||
| 188462 | 188462 | 135018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012602.08363 | 2120098.20385 | 37.802094667483004 | -122.400560466418 | (37.802094667483, -122.400560466418) | ||||
| 188460 | 188460 | 235347 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1855 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005068.90941 | 2107202.78038 | 37.7662640304969 | -122.425710502043 | (37.7662640304969, -122.425710502043) | |||
| 188441 | 188441 | 134059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2434 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001955.51186 | 2117390.7546200003 | 37.7940612116103 | -122.43720866535601 | (37.7940612116103, -122.437208665356) | |||
| 188439 | 188439 | 48708 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 6 | Permit Number 45976 | 6014000.73763 | 2115276.8947099997 | 37.7889343906698 | -122.39538246774599 | (37.7889343906698, -122.395382467746) | ||
| 188433 | 188433 | 249420 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 711 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006894.14828 | 2113241.60882 | 37.782948178465205 | -122.41982588086701 | (37.7829481784652, -122.419825880867) | |||
| 188424 | 188424 | 195347 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6014737.26002 | 2116708.17803 | 37.7929052994811 | -122.392934358433 | (37.7929052994811, -122.392934358433) | |||
| 188404 | 188404 | 134417 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 597 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006675.7769 | 2112372.96087 | 37.780550778339894 | -122.420519677268 | (37.7805507783399, -122.420519677268) | |||
| 188396 | 188396 | 195490 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 310 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6015985.8832 | 2115355.88011 | 37.789261475896794 | -122.38851958652701 | (37.7892614758968, -122.388519586527) | |||
| 188392 | 188392 | 195306 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 91 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013790.71906 | 2116829.0721400003 | 37.793184624411104 | -122.396217937924 | (37.7931846244111, -122.396217937924) | |||
| 188343 | 188343 | 113059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776016 | 6000289.21565 | 2117461.28412 | 37.7941600057183 | -122.44297927319599 | (37.7941600057183, -122.442979273196) | |
| 188332 | 188332 | 143031 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6010830.5748 | 2120664.6828 | 37.8035511239121 | -122.406730709589 | (37.8035511239121, -122.406730709589) | |||
| 188291 | 188291 | 133940 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2505 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000706.73824 | 2117002.51543 | 37.792924142985605 | -122.44150166728001 | (37.7929241429856, -122.44150166728) | |||
| 188282 | 188282 | 44019 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007852.239130001 | 2112732.3547 | 37.7816038169983 | -122.416475189498 | (37.7816038169983, -122.416475189498) | ||
| 188259 | 188259 | 234631 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 975 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003166.40159 | 2102538.68828 | 37.7533498621256 | -122.431957831516 | (37.7533498621256, -122.431957831516) | |||
| 188240 | 188240 | 178599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5989481.37307 | 2093611.3212099997 | 37.7280523070507 | -122.47863016983999 | (37.7280523070507, -122.47863016984) | |||
| 188238 | 188238 | 133759 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2824 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6001038.43738 | 2115936.87549 | 37.790017064690105 | -122.440277518196 | (37.7900170646901, -122.440277518196) | |||
| 188230 | 188230 | 133738 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2617 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002277.412690001 | 2116056.54848 | 37.790416119048096 | -122.43599934161199 | (37.7904161190481, -122.435999341612) | |||
| 188224 | 188224 | 195538 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 380 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6016072.38953 | 2114298.16396 | 37.7863620211284 | -122.38814643712799 | (37.7863620211284, -122.388146437128) | |||
| 188205 | 188205 | 195055 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 403 06th St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 3ft | 6011430.17139 | 2111003.8876099996 | 37.7770584095405 | -122.403975506976 | (37.7770584095405, -122.403975506976) | |||
| 188197 | 188197 | 133814 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2546 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001951.70377 | 2116716.37879 | 37.792209333931 | -122.43717353424299 | (37.792209333931, -122.437173534243) | |||
| 188156 | 188156 | 250298 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008400.93583 | 2112028.98514 | 37.7797033741539 | -122.414527167109 | (37.7797033741539, -122.414527167109) | |||
| 188138 | 188138 | 134319 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004910.4795699995 | 2117808.86881 | 37.795376778568894 | -122.427013958752 | (37.7953767785689, -122.427013958752) | |||
| 188104 | 188104 | 50580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | 8 | Permit Number 56162 | 6006391.85485 | 2121486.039 | 37.805557008807504 | -122.422149515895 | (37.8055570088075, -122.422149515895) | ||
| 188087 | 188087 | 195225 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 551 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011054.22274 | 2097313.24893 | 37.739445953869705 | -122.40431219245 | (37.7394459538697, -122.40431219245) | ||||
| 188079 | 188079 | 234616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1186 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003172.8159 | 2101394.93062 | 37.75020973710679 | -122.43185398858299 | (37.7502097371068, -122.431853988583) | |||
| 188050 | 188050 | 250293 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008341.16975 | 2112039.72315 | 37.7797295003499 | -122.414734684778 | (37.7797295003499, -122.414734684778) | |||
| 188035 | 188035 | 134371 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Eddy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005874.62768 | 2113150.12264 | 37.78263949246121 | -122.42334649914301 | (37.7826394924612, -122.423346499143) | |||
| 188034 | 188034 | 134690 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1569 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006768.57768 | 2116002.6407 | 37.7905222183828 | -122.420456348779 | (37.7905222183828, -122.420456348779) | |||
| 188028 | 188028 | 135260 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1180 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012606.41867 | 2120135.8313700003 | 37.802198225318996 | -122.400548109713 | (37.802198225319, -122.400548109713) | |||
| 188011 | 188011 | 195185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Hampshire St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010026.48712 | 2106231.88589 | 37.763877070583895 | -122.40849461556002 | (37.7638770705839, -122.40849461556) | |||
| 187964 | 187964 | 133493 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Spruce St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5997075.25575 | 2115566.36113 | 37.7887732905973 | -122.453962946945 | (37.7887732905973, -122.453962946945) | |||
| 187955 | 187955 | 143500 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 733 KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6011289.038 | 2117387.5536 | 37.794578563613 | -122.40491329723801 | (37.794578563613, -122.404913297238) | |||
| 187947 | 187947 | 133516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 108 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998503.9446 | 2116089.74031 | 37.790292163713296 | -122.449057627204 | (37.7902921637133, -122.449057627204) | |||
| 187941 | 187941 | 195429 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 317 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014151.9342 | 2115420.53494 | 37.7893372014998 | -122.39486940809401 | (37.7893372014998, -122.394869408094) | |||
| 187932 | 187932 | 195281 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 553 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012731.0409699995 | 2115817.67923 | 37.790348558383606 | -122.399813463413 | (37.7903485583836, -122.399813463413) | |||
| 187919 | 187919 | 178626 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Bowdoin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008923.85295 | 2093085.88757 | 37.7277192539284 | -122.41137953815901 | (37.7277192539284, -122.411379538159) | |||
| 187891 | 187891 | 195647 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6015801.74593 | 2112212.7124400004 | 37.780620842709105 | -122.388937150751 | (37.7806208427091, -122.388937150751) | |||
| 187889 | 187889 | 195753 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6013837.03955 | 2110333.35585 | 37.7753514585363 | -122.395602347468 | (37.7753514585363, -122.395602347468) | |||
| 187864 | 187864 | 133984 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000654.87832 | 2117209.79763 | 37.793490330959 | -122.441695987399 | (37.793490330959, -122.441695987399) | |||
| 187860 | 187860 | 135064 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010496.20464 | 2122220.2308799997 | 37.8078035593512 | -122.407997582726 | (37.8078035593512, -122.407997582726) | |||
| 187857 | 187857 | 234601 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 918 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003093.19553 | 2102884.93917 | 37.754296434554604 | -122.43223571931601 | (37.7542964345546, -122.432235719316) | |||
| 187847 | 187847 | 143284 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 MARKET ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010177.3971 | 2113480.1971 | 37.7837876999943 | -122.408483982104 | (37.7837876999943, -122.408483982104) | |||
| 187830 | 187830 | 234590 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005387.2262699995 | 2095944.3664799999 | 37.73536900776279 | -122.42380889369 | (37.7353690077628, -122.42380889369) | |||
| 187789 | 187789 | 246290 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2369 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002547.0881 | 2106084.994 | 37.7630520360397 | -122.43435306729799 | (37.7630520360397, -122.434353067298) | |||
| 187785 | 187785 | 195835 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 248 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010715.06912 | 2111755.91876 | 37.779083332960894 | -122.40650228627199 | (37.7790833329609, -122.406502286272) | |||
| 187771 | 187771 | 133973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 11 Normandie Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000914.9606099995 | 2117315.00289 | 37.793794012227295 | -122.440803635093 | (37.7937940122273, -122.440803635093) | |||
| 187766 | 187766 | 135580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013926.74928 | 2118157.44588 | 37.7968395942205 | -122.395840385449 | (37.7968395942205, -122.395840385449) | |||
| 187734 | 187734 | 119588 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6945 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5985990.827880001 | 2113870.4748 | 37.7834750995118 | -122.49218802684099 | (37.7834750995118, -122.492188026841) |
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");