Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188962 | 188962 | 182197 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | |||
| 188102 | 188102 | 234372 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.74871742098671 | -122.424406263843 | (37.7487174209867, -122.424406263843) | |||
| 187874 | 187874 | 194313 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | |||
| 187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
| 186747 | 186747 | 194316 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 7ft | 6014969.23068 | 2116866.2603700003 | 37.793352239169295 | -122.392142782374 | (37.7933522391693, -122.392142782374) | |||
| 186566 | 186566 | 132093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.39950394556699 | (37.8014252975988, -122.399503945567) | |||
| 186407 | 186407 | 194386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | ||||
| 186247 | 186247 | 118708 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | |||
| 186098 | 186098 | 96686 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985884.08947 | 2113350.81045 | 37.7820420106561 | -122.49251901199499 | (37.7820420106561, -122.492519011995) | ||
| 185868 | 185868 | 132133 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 6013516.34459 | 2118862.0699 | 37.7987514845508 | -122.39730992891 | (37.7987514845508, -122.39730992891) | |||
| 185824 | 185824 | 234392 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1379 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6005257.78896 | 2100266.47383 | 37.7472292273428 | -122.424563754022 | (37.7472292273428, -122.424563754022) | |||
| 184903 | 184903 | 201683 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010259.3376400005 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | ||||
| 183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
| 183774 | 183774 | 132118 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6014172.89911 | 2117759.32578 | 37.795760140682894 | -122.394960745056 | (37.7957601406829, -122.394960745056) | |||
| 183458 | 183458 | 194358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6016102.75205 | 2114084.3299 | 37.7857765633769 | -122.388026462162 | (37.7857765633769, -122.388026462162) | |||
| 183295 | 183295 | 194277 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | Width 7ft | 6012002.23785 | 2102241.02504 | 37.7530294975215 | -122.401380567153 | (37.7530294975215, -122.401380567153) | |||
| 182808 | 182808 | 194353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6016057.99648 | 2113605.1395799997 | 37.7844583353237 | -122.388147851742 | (37.7844583353237, -122.388147851742) | |||
| 182641 | 182641 | 233932 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004814.58298 | 2107439.6885599997 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | ||||
| 182585 | 182585 | 194343 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016001.634319999 | 2112937.23784 | 37.7826213045779 | -122.38829621649799 | (37.7826213045779, -122.388296216498) | |||
| 182470 | 182470 | 132107 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011604.73213 | 2121437.1460700002 | 37.805715402812204 | -122.40410608402901 | (37.8057154028122, -122.404106084029) | |||
| 182459 | 182459 | 246404 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004606.9445 | 2108108.5245 | 37.7687248704296 | -122.427372879895 | (37.7687248704296, -122.427372879895) | |||
| 182456 | 182456 | 234394 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6003187.2989 | 2100371.4904099996 | 37.7474004312881 | -122.431730842629 | (37.7474004312881, -122.431730842629) | ||||
| 182278 | 182278 | 210908 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1351 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994231.8356099995 | 2106400.1375599997 | 37.7634418445856 | -122.463135347428 | (37.7634418445856, -122.463135347428) | |||
| 182277 | 182277 | 194342 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6016043.56926 | 2112825.74631 | 37.7823174973895 | -122.38814335514999 | (37.7823174973895, -122.38814335515) | |||
| 182110 | 182110 | 194322 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014773.3420400005 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | |||
| 182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
| 181994 | 181994 | 132108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011532.668269999 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | |||
| 181978 | 181978 | 246356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003986.7122 | 2107511.3108 | 37.7670499684983 | -122.429475620431 | (37.7670499684983, -122.429475620431) | |||
| 181931 | 181931 | 247638 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.40975139021499 | (37.7373232876386, -122.409751390215) | ||||
| 181927 | 181927 | 201684 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6010233.57215 | 2109769.89905 | 37.773603237626 | -122.408027891695 | (37.773603237626, -122.408027891695) | ||||
| 181869 | 181869 | 234340 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 3ft | 6004869.08955 | 2105489.95301 | 37.7615497213531 | -122.42627968206499 | (37.7615497213531, -122.426279682065) | |||
| 181517 | 181517 | 194279 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | ||||
| 181231 | 181231 | 234403 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006066.151819999 | 2108969.9418900004 | 37.771172536524794 | -122.42238679931101 | (37.7711725365248, -122.422386799311) | |||
| 180226 | 180226 | 186180 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984958.094 | 2103565.49 | 37.755120105782204 | -122.49500073187099 | (37.7551201057822, -122.495000731871) | |||
| 179975 | 179975 | 234373 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 9ft | 6004999.25531 | 2105001.6441599997 | 37.76021629747461 | -122.42579473344401 | (37.7602162974746, -122.425794733444) | |||
| 179789 | 179789 | 234357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004986.096919999 | 2104380.3629099997 | 37.758509662101204 | -122.425796019476 | (37.7585096621012, -122.425796019476) | ||||
| 179308 | 179308 | 124647 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Arguello Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5995536.8608800005 | 2115835.19472 | 37.789423108579996 | -122.459305014392 | (37.78942310858, -122.459305014392) | ||||
| 179136 | 179136 | 124657 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 30 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 7ft | 5995444.46973 | 2115398.79213 | 37.7882195529326 | -122.459593054716 | (37.7882195529326, -122.459593054716) | |||
| 178718 | 178718 | 194367 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 6016138.88729 | 2114959.31506 | 37.7881810762396 | -122.38796252216999 | (37.7881810762396, -122.38796252217) | |||
| 178250 | 178250 | 246357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003963.462 | 2107490.3857 | 37.7669911968193 | -122.429554546796 | (37.7669911968193, -122.429554546796) | |||
| 177827 | 177827 | 234351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004966.99113 | 2104720.1905900002 | 37.759441669116796 | -122.425886285347 | (37.7594416691168, -122.425886285347) | ||||
| 177459 | 177459 | 132104 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | |||
| 177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
| 176923 | 176923 | 132084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012274.61558 | 2120706.35336 | 37.8037462301721 | -122.401736440606 | (37.8037462301721, -122.401736440606) | |||
| 176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
| 176298 | 176298 | 247642 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 632 Banks St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.41307547425501 | (37.7354426820387, -122.413075474255) | |||
| 176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
| 176009 | 176009 | 234379 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 246 Bemis St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6003018.34772 | 2096316.7253 | 37.736257406663704 | -122.432025563025 | (37.7362574066637, -122.432025563025) | ||||
| 175193 | 175193 | 182680 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985854.1638 | 2103629.5919999997 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | |||
| 174857 | 174857 | 234391 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005241.74432 | 2098978.16752 | 37.743690926593295 | -122.424527610268 | (37.7436909265933, -122.424527610268) | |||
| 174328 | 174328 | 234327 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6005045.03345 | 2103276.5066400003 | 37.755482062073604 | -122.425513631455 | (37.7554820620736, -122.425513631455) | ||||
| 174148 | 174148 | 234400 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4 Corwin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 3ft | 6001132.8816599995 | 2103964.26051 | 37.7571486461001 | -122.439092314277 | (37.7571486461001, -122.439092314277) | |||
| 174052 | 174052 | 194319 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.793601355862705 | -122.392257538577 | (37.7936013558627, -122.392257538577) | |||
| 173668 | 173668 | 194302 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | 6014474.29881 | 2117301.48742 | 37.7945197786065 | -122.393885774627 | (37.7945197786065, -122.393885774627) | |||
| 173622 | 173622 | 234381 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Eugenia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.41992640079599 | (37.74136892295, -122.419926400796) | ||||
| 173586 | 173586 | 194339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 6015964.49017 | 2112481.16819 | 37.781366981449295 | -122.388392878343 | (37.7813669814493, -122.388392878343) | |||
| 173116 | 173116 | 194373 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016083.2484800005 | 2115225.4963700003 | 37.7889088670017 | -122.38817360834 | (37.7889088670017, -122.38817360834) | |||
| 172817 | 172817 | 245965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6005023.4835 | 2108512.8969 | 37.7698587289196 | -122.425960891085 | (37.7698587289196, -122.425960891085) | |||
| 172221 | 172221 | 245963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | |||
| 171992 | 171992 | 218157 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1396 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | 5993196.82548 | 2097677.0995099996 | 37.7394309459859 | -122.46608116671001 | (37.7394309459859, -122.46608116671) | ||||
| 171635 | 171635 | 234401 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3899 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 6003740.055819999 | 2104771.47672 | 37.75951307439 | -122.430133288745 | (37.75951307439, -122.430133288745) | |||
| 171600 | 171600 | 248622 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 142x McCoppin St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6005746.1935 | 2109104.2775 | 37.7715233357229 | -122.423503100629 | (37.7715233357229, -122.423503100629) | |||
| 171516 | 171516 | 194323 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 7ft | 6014746.37404 | 2117187.8708099998 | 37.7942229303951 | -122.39293639989201 | (37.7942229303951, -122.392936399892) | |||
| 170719 | 170719 | 194307 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 6015377.01126 | 2116388.0666 | 37.792061862225204 | -122.39069838843399 | (37.7920618622252, -122.390698388434) | |||
| 170613 | 170613 | 194296 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1799 Revere Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 6014052.02799 | 2095141.7859200002 | 37.733650626363 | -122.393795063609 | (37.733650626363, -122.393795063609) | ||||
| 170480 | 170480 | 245964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005048.2837 | 2108538.5237 | 37.7699304954931 | -122.42587693213301 | (37.7699304954931, -122.425876932133) | |||
| 170290 | 170290 | 194382 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6015730.53426 | 2115716.1031299997 | 37.7902364120368 | -122.389428237241 | (37.7902364120368, -122.389428237241) | |||
| 170283 | 170283 | 234385 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 384 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004737.93375 | 2109866.7423400003 | 37.773559918201606 | -122.427045042888 | (37.7735599182016, -122.427045042888) | |||
| 170253 | 170253 | 178084 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.39781106804199 | (37.7126358803078, -122.397811068042) | |||
| 170250 | 170250 | 233938 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004845.02149 | 2106914.0966 | 37.7654587199743 | -122.426464330874 | (37.7654587199743, -122.426464330874) | ||||
| 168851 | 168851 | 194325 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 88 King St | 1 | : 4 | Tree 1 | Private 1 | 31 | Width 8ft | 6015700.5691599995 | 2111985.57661 | 37.779991570003205 | -122.38927130734601 | (37.7799915700032, -122.389271307346) | |||
| 168748 | 168748 | 132110 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | |||
| 168474 | 168474 | 132105 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012001.46692 | 2121074.30881 | 37.8047412994387 | -122.402707584299 | (37.8047412994387, -122.402707584299) | |||
| 168401 | 168401 | 194350 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016048.53605 | 2113426.10211 | 37.7839662146185 | -122.388168082915 | (37.7839662146185, -122.388168082915) | |||
| 168179 | 168179 | 119407 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 375 32nd Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 9ft | 5985884.85714 | 2113320.57304 | 37.78195903231371 | -122.49251412874399 | (37.7819590323137, -122.492514128744) | |||
| 167096 | 167096 | 234328 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | ||||
| 166867 | 166867 | 132106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.40386352159099 | (37.8055435810345, -122.403863521591) | |||
| 166815 | 166815 | 194285 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6014471.94536 | 2095201.4069599998 | 37.7338376601657 | -122.39234744377701 | (37.7338376601657, -122.392347443777) | ||||
| 166452 | 166452 | 210925 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 43 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 10ft | 5999799.64358 | 2095482.9145400003 | 37.7337849536105 | -122.443094053648 | (37.7337849536105, -122.443094053648) | |||
| 165757 | 165757 | 234350 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004963.57632 | 2104757.16703 | 37.759543004714 | -122.425900727537 | (37.759543004714, -122.425900727537) | ||||
| 164993 | 164993 | 118208 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 578 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | |||
| 164848 | 164848 | 234326 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005043.60607 | 2103360.12702 | 37.755711583428294 | -122.425524518639 | (37.7557115834283, -122.425524518639) | ||||
| 164800 | 164800 | 233942 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004917.83694 | 2105642.84744 | 37.7619722884988 | -122.426121969753 | (37.7619722884988, -122.426121969753) | ||||
| 164799 | 164799 | 194376 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016101.40226 | 2115318.33028 | 37.789164773592205 | -122.38811727930201 | (37.7891647735922, -122.388117279302) | |||
| 164381 | 164381 | 218156 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1396 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5993216.16649 | 2097685.94396 | 37.7394563464375 | -122.46601493705799 | (37.7394563464375, -122.466014937058) | ||||
| 164266 | 164266 | 132076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012766.891340001 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | |||
| 164116 | 164116 | 194276 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2347 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | 6010780.52383 | 2105047.83738 | 37.7606681393399 | -122.405803207256 | (37.7606681393399, -122.405803207256) | ||||
| 164090 | 164090 | 194328 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 6015816.38649 | 2112097.21372 | 37.7803045205874 | -122.388878435804 | (37.7803045205874, -122.388878435804) | |||
| 164059 | 164059 | 178087 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003003.324659999 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | |||
| 163745 | 163745 | 234334 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 3ft | 6004862.85296 | 2105604.25637 | 37.7618632187373 | -122.426309390288 | (37.7618632187373, -122.426309390288) | |||
| 163649 | 163649 | 132127 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.79511912011571 | -122.39455279549401 | (37.7951191201157, -122.394552795494) | |||
| 163407 | 163407 | 187499 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854947999 | (37.7093979531098, -122.42400854948) | ||||
| 163388 | 163388 | 233927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 389 Webster St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | |||
| 163255 | 163255 | 132126 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | |||
| 163198 | 163198 | 234393 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561001 | (37.7442097715744, -122.42885628561) | |||
| 163173 | 163173 | 120801 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4400 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 5ft | 5989725.4481 | 2109944.4345400003 | 37.7729128936687 | -122.478980576929 | (37.7729128936687, -122.478980576929) | |||
| 163146 | 163146 | 194345 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016011.38638 | 2113034.09815 | 37.7828878015789 | -122.388269240457 | (37.7828878015789, -122.388269240457) | |||
| 162909 | 162909 | 194305 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014543.5989 | 2117243.74376 | 37.7943650790379 | -122.393641942341 | (37.7943650790379, -122.393641942341) | |||
| 162688 | 162688 | 210917 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994023.9222099995 | 2099259.0924400003 | 37.7438223849926 | -122.46333621999399 | (37.7438223849926, -122.463336219994) | |||
| 162596 | 162596 | 194326 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015764.48229 | 2112042.08861 | 37.7801502823482 | -122.38905414805599 | (37.7801502823482, -122.389054148056) |
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");