Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
| 1023 | 1023 | 24311 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6006902.669840001 | 2121389.92308 | 37.8053218972443 | -122.420374939461 | (37.8053218972443, -122.420374939461) | ||||
| 2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 3500 | 3500 | 13943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.780196698058894 | -122.412628072717 | (37.7801966980589, -122.412628072717) | |||
| 3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 5274 | 5274 | 58105 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1977 12:00:00 AM | 5 | Permit Number 17081 | 6006591.68402 | 2113670.96002 | 37.7841100278879 | -122.42090277676701 | (37.7841100278879, -122.420902776767) | ||
| 5301 | 5301 | 45635 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 7 | Permit Number 44342 | 6006530.053069999 | 2113426.6825900003 | 37.7834358277545 | -122.421098647281 | (37.7834358277545, -122.421098647281) | ||
| 5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
| 5428 | 5428 | 24310 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6006900.22287 | 2121405.53505 | 37.80536462583971 | -122.420384516339 | (37.8053646258397, -122.420384516339) | ||||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 6222 | 6222 | 27831 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013146.80764 | 2119335.33451 | 37.8000303753641 | -122.39862188328699 | (37.8000303753641, -122.398621883287) | |||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 6802 | 6802 | 94826 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 14 | Permit Number 53924 | 6002581.43638 | 2118129.72292 | 37.7961257879313 | -122.435095781947 | (37.7961257879313, -122.435095781947) | ||
| 6950 | 6950 | 29570 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 928 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6006592.43621 | 2113707.60063 | 37.7842106764279 | -122.42090277673701 | (37.7842106764279, -122.420902776737) | ||||
| 7124 | 7124 | 27832 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013158.11098 | 2119319.87365 | 37.799988553278105 | -122.39858168361799 | (37.7999885532781, -122.398581683618) | |||
| 7456 | 7456 | 111007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 600X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2015 12:00:00 AM | 3 | Permit Number 776001 | 6007258.06948 | 2121954.7995599997 | 37.8068929247227 | -122.41918512469299 | (37.8068929247227, -122.419185124693) | ||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
| 8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 8997 | 8997 | 27829 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013118.439809999 | 2119374.83982 | 37.800137266990596 | -122.39872282141 | (37.8001372669906, -122.39872282141) | |||
| 9595 | 9595 | 35817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 9783 | 9783 | 57570 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 10 | Permit Number 779323 | 6002543.91093059 | 2107348.98528352 | 37.766522467805295 | -122.434454434548 | (37.7665224678053, -122.434454434548) | ||
| 10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 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) | ||||
| 10491 | 10491 | 1075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6000135.00359 | 2089836.3366200002 | 37.7182998663217 | -122.44152955615299 | (37.7182998663217, -122.441529556153) | ||||
| 10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 11923 | 11923 | 87592 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3039 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990542.943940001 | 2094954.8149599999 | 37.731802780363104 | -122.475058356779 | (37.7318027803631, -122.475058356779) | ||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 12686 | 12686 | 35818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 13260 | 13260 | 60572 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1002 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | Permit Number 20185 | 5998848.38048099 | 2106535.44717902 | 37.7640782295423 | -122.44717800789302 | (37.7640782295423, -122.447178007893) | |||
| 13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13646 | 13646 | 50156 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 215 REVISED Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 13881 | 13881 | 35819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 13916 | 13916 | 51328 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014381.59156 | 2114580.64848 | 37.787043834057 | -122.394015994643 | (37.787043834057, -122.394015994643) | ||
| 14051 | 14051 | 51330 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014367.75684 | 2114595.25107 | 37.787083160494795 | -122.39406488271099 | (37.7870831604948, -122.394064882711) | ||
| 14325 | 14325 | 51335 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014469.07486 | 2114489.67669 | 37.786798908177296 | -122.393706949821 | (37.7867989081773, -122.393706949821) | ||
| 14468 | 14468 | 51333 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014483.95418 | 2114476.81185 | 37.7867644110965 | -122.393654569705 | (37.7867644110965, -122.393654569705) | ||
| 14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 15216 | 15216 | 51332 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014455.003 | 2114505.03769 | 37.7868403039865 | -122.393756711124 | (37.7868403039865, -122.393756711124) | ||
| 15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15375 | 15375 | 28533 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 225 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6010671.46792 | 2111896.6043700003 | 37.7794671834059 | -122.40666303828999 | (37.7794671834059, -122.40666303829) | ||||
| 15498 | 15498 | 35820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15910 | 15910 | 51329 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014352.4442300005 | 2114611.6421 | 37.787127315414295 | -122.39411900929701 | (37.7871273154143, -122.394119009297) | ||
| 16055 | 16055 | 51331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014339.098619999 | 2114625.4808400003 | 37.7871645716384 | -122.394166151749 | (37.7871645716384, -122.394166151749) | ||
| 16116 | 16116 | 51327 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014502.81835 | 2114461.3538900004 | 37.786723015300296 | -122.393588221341 | (37.7867230153003, -122.393588221341) | ||
| 16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16329 | 16329 | 51336 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014396.4352 | 2114566.02547 | 37.7870045076019 | -122.39396361453501 | (37.7870045076019, -122.393963614535) | ||
| 16342 | 16342 | 13654 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1989 12:00:00 AM | 25 | 6012250.572430001 | 2115370.08775 | 37.7890927810573 | -122.401444392055 | (37.7890927810573, -122.401444392055) | |||
| 16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 16729 | 16729 | 39527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 6 | Permit Number 40969 | 6012771.09866 | 2106608.38258 | 37.765064170309 | -122.399028197904 | (37.765064170309, -122.399028197904) | |
| 16776 | 16776 | 28527 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 275 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6010877.47547 | 2111683.2187 | 37.7788927999036 | -122.405935331161 | (37.7788927999036, -122.405935331161) | ||||
| 17511 | 17511 | 23000 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 741 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 8 | 6006275.77922 | 2105260.31314 | 37.7609985961381 | -122.421398202488 | (37.7609985961381, -122.421398202488) | |||
| 17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 18001 | 18001 | 27903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015937.152000001 | 2112771.705 | 37.78216321542121 | -122.388507741674 | (37.7821632154212, -122.388507741674) | |||
| 18362 | 18362 | 57232 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 91 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | Permit Number 14519 | 6002939.30874382 | 2107370.92325937 | 37.766605140706794 | -122.43308839292601 | (37.7666051407068, -122.433088392926) | |||
| 18737 | 18737 | 34217 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | Permit Number 38032 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | |||
| 19127 | 19127 | 49220 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 19178 | 19178 | 119707 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 47 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | |||||
| 19646 | 19646 | 28217 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | ||||
| 19678 | 19678 | 34828 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | Permit Number 38458 | 5990549.21563661 | 2104310.17201234 | 37.757490528410294 | -122.4757195858 | (37.7574905284103, -122.4757195858) | |||
| 20654 | 20654 | 49903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 20866 | 20866 | 28204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | ||||
| 20868 | 20868 | 114568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 621 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 6010507.2 | 2116333.9 | 37.79164175144621 | -122.407544247145 | (37.7916417514462, -122.407544247145) | ||||
| 22259 | 22259 | 32095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779125 | 6003421.63406 | 2105677.3546700003 | 37.761982358207796 | -122.431299212108 | (37.7619823582078, -122.431299212108) | |
| 22289 | 22289 | 68675 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 225 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32584 | 5992727.99284 | 2113946.56215 | 37.784075552459605 | -122.468885802919 | (37.7840755524596, -122.468885802919) | |
| 23009 | 23009 | 20248 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1837 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 6002502.1889 | 2114589.3013 | 37.786400200224705 | -122.435116645364 | (37.7864002002247, -122.435116645364) | ||||
| 23076 | 23076 | 24000 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5992329.4255 | 2097111.1167 | 37.7378268194972 | -122.469039048495 | (37.7378268194972, -122.469039048495) | ||||
| 23184 | 23184 | 23371 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1407 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/1989 12:00:00 AM | 10 | 6006265.90478 | 2115346.54354 | 37.788692398380206 | -122.422148937624 | (37.7886923983802, -122.422148937624) | |||
| 23193 | 23193 | 22935 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 7 | 6006080.52288 | 2107591.71484 | 37.7673890643751 | -122.422239154029 | (37.7673890643751, -122.422239154029) | |||
| 23423 | 23423 | 195472 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014582.56054 | 2117381.49578 | 37.7947454787808 | -122.39351677468099 | (37.7947454787808, -122.393516774681) | ||||
| 23817 | 23817 | 30338 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2560 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1991 12:00:00 AM | 10 | Permit Number 29878 | 6000745.93353 | 2117076.9989400003 | 37.7931308881211 | -122.441371396891 | (37.7931308881211, -122.441371396891) | ||
| 24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
| 24037 | 24037 | 59123 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 754 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18428 | 5992916.29566 | 2110324.90997 | 37.774142355037796 | -122.467970831082 | (37.7741423550378, -122.467970831082) | ||
| 24940 | 24940 | 49241 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 9 | Permit Number 46300 | 6013661.1988 | 2115034.63396 | 37.7882503087406 | -122.396540245956 | (37.7882503087406, -122.396540245956) | ||
| 25269 | 25269 | 135059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010565.46035 | 2122201.4821900004 | 37.807755957339396 | -122.40775658241999 | (37.8077559573394, -122.40775658242) | ||||
| 25488 | 25488 | 39821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2101 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | 3 | Permit Number 41148 | 5981982.6078 | 2100745.8281 | 37.7472034694978 | -122.505081701882 | (37.7472034694978, -122.505081701882) | ||
| 25928 | 25928 | 44015 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007928.56068 | 2112738.8102700002 | 37.7816258342147 | -122.416211609894 | (37.7816258342147, -122.416211609894) | ||
| 25973 | 25973 | 62639 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1986 12:00:00 AM | 12 | Permit Number 22954 | 6009048.2583 | 2121456.376 | 37.805625032343706 | -122.412954529521 | (37.8056250323437, -122.412954529521) | ||
| 26106 | 26106 | 50517 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 13 | Permit Number 47155 | 5994696.74474 | 2110951.43377 | 37.775965278975896 | -122.461857428152 | (37.7759652789759, -122.461857428152) | |
| 26111 | 26111 | 58715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 668 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1979 12:00:00 AM | 13 | Permit Number 17949 | 6004656.79868 | 2110899.54508 | 37.7763911539517 | -122.427399290368 | (37.7763911539517, -122.427399290368) | ||
| 26183 | 26183 | 195467 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014580.603680001 | 2117309.91593 | 37.7945488285163 | -122.393518533752 | (37.7945488285163, -122.393518533752) | ||||
| 26200 | 26200 | 195226 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 551 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6011058.60969 | 2097355.1094400003 | 37.739561139028 | -122.40429996976299 | (37.739561139028, -122.404299969763) |
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");