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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 136550 | 136550 | 186179 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984928.6664 | 2103564.4514 | 37.755115531312704 | -122.49510242297701 | (37.7551155313127, -122.495102422977) | |||
| 24453 | 24453 | 185441 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985106.1344 | 2099492.3058 | 37.7439449206951 | -122.49418856991899 | (37.7439449206951, -122.494188569919) | |||
| 54350 | 54350 | 194294 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 49 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | ||||
| 27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
| 27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
| 54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
| 70141 | 70141 | 194290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014381.3022300005 | 2095272.57767 | 37.7340280466394 | -122.39266580380101 | (37.7340280466394, -122.392665803801) | ||||
| 58702 | 58702 | 194289 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.39261394888901 | (37.734007417094, -122.392613948889) | ||||
| 35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
| 134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
| 39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
| 150397 | 150397 | 194286 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6014450.16973 | 2095221.3993900002 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | ||||
| 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) | ||||
| 72691 | 72691 | 234342 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 Dolores St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 6ft | 6004943.9168300005 | 2104413.64545 | 37.7585986644128 | -122.425944266413 | (37.7585986644128, -122.425944266413) | |||
| 42394 | 42394 | 201687 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | ||||
| 72122 | 72122 | 234341 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 3ft | 6004869.93402 | 2105476.5468200003 | 37.7615129588681 | -122.42627580688401 | (37.7615129588681, -122.426275806884) | |||
| 115023 | 115023 | 28238 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 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) | ||||
| 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) | |||
| 22831 | 22831 | 251116 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 25705 | 25705 | 234339 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 3ft | 6004868.93824 | 2105500.74139 | 37.7615793351331 | -122.426280973507 | (37.7615793351331, -122.426280973507) | |||
| 35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
| 93618 | 93618 | 28237 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 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) | ||||
| 22828 | 22828 | 251115 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 44771 | 44771 | 234338 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 3ft | 6004867.72819 | 2105514.5268599996 | 37.761617118366104 | -122.42628614009199 | (37.7616171183661, -122.426286140092) | |||
| 81194 | 81194 | 28236 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 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) | ||||
| 59423 | 59423 | 194280 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016126.44291 | 2100241.55687 | 37.747768618243605 | -122.38697869801202 | (37.7477686182436, -122.386978698012) | ||||
| 76008 | 76008 | 201682 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010248.09063 | 2109749.24504 | 37.773547339368704 | -122.40797621303899 | (37.7735473393687, -122.407976213039) | ||||
| 80229 | 80229 | 18563 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 107571 | 107571 | 28235 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 39365 | 39365 | 234337 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 6004866.4127400005 | 2105541.3308900003 | 37.7616906415182 | -122.42629259813299 | (37.7616906415182, -122.426292598133) | |||
| 56654 | 56654 | 132101 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | |||
| 103442 | 103442 | 96695 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 119895 | 119895 | 28234 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 151971 | 151971 | 194274 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6015578.255919999 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | ||||
| 15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 87101 | 87101 | 96694 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 124299 | 124299 | 28233 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 135157 | 135157 | 132081 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012501.69351 | 2120366.8481099997 | 37.802826700352995 | -122.400926752172 | (37.802826700353, -122.400926752172) | |||
| 152917 | 152917 | 194273 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6015573.17514 | 2103426.7647700002 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | |||
| 155521 | 155521 | 194340 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6015972.31673 | 2112547.01001 | 37.7815482020175 | -122.388370398867 | (37.7815482020175, -122.388370398867) | |||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 48115 | 48115 | 132100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.802820809805496 | -122.400753698321 | (37.8028208098055, -122.400753698321) | |||
| 73838 | 73838 | 28232 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 101220 | 101220 | 26535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | ||
| 107261 | 107261 | 96693 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 129396 | 129396 | 93074 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 301 Executive Park Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 150698 | 150698 | 234330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005083.062580001 | 2102603.58555 | 37.7536365264144 | -122.42533423108699 | (37.7536365264144, -122.425334231087) | ||||
| 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) | |||
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 22824 | 22824 | 251112 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : 22 | Tree 1 | DPW 2 | ||||||||||
| 33192 | 33192 | 194377 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.789304668530896 | -122.388377800289 | (37.7893046685309, -122.388377800289) | |||
| 61697 | 61697 | 28231 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 106263 | 106263 | 96692 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 117814 | 117814 | 24973 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 129992 | 129992 | 132099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.40060816104099 | (37.8026555899447, -122.400608161041) | |||
| 146068 | 146068 | 5446 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | ||
| 155084 | 155084 | 234329 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005081.6594 | 2102660.65252 | 37.7537931397475 | -122.425343144298 | (37.7537931397475, -122.425343144298) | ||||
| 155383 | 155383 | 194338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015989.55415 | 2112403.0150099997 | 37.781153779156206 | -122.388300712233 | (37.7811537791562, -122.388300712233) | |||
| 160623 | 160623 | 234336 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6004864.2449199995 | 2105581.16954 | 37.7617999064621 | -122.42630293226101 | (37.7617999064621, -122.426302932261) | |||
| 35716 | 35716 | 194337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015953.29851 | 2112409.5704799998 | 37.781169770014294 | -122.38842659752198 | (37.7811697700143, -122.388426597522) | |||
| 37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
| 47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
| 69507 | 69507 | 132112 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011208.1934400005 | 2121737.88602 | 37.8065189965151 | -122.40549956557501 | (37.8065189965151, -122.405499565575) | |||
| 81526 | 81526 | 103927 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/05/2001 12:00:00 AM | 4x4 | 6014859.0 | 2117030.0 | 37.793795709183996 | -122.392535650186 | (37.793795709184, -122.392535650186) | |||
| 85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 97883 | 97883 | 24986 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 103351 | 103351 | 25147 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 108524 | 108524 | 28230 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 131778 | 131778 | 234335 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 3ft | 6004864.336759999 | 2105585.63058 | 37.7618121606106 | -122.42630293224899 | (37.7618121606106, -122.426302932249) | |||
| 142252 | 142252 | 24972 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 30823 | 30823 | 132092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011191.46105 | 2121714.3637599996 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | |||
| 42729 | 42729 | 194375 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6016059.60857 | 2115304.2736400003 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | |||
| 61273 | 61273 | 194336 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015966.10007 | 2112335.54697 | 37.7809672274079 | -122.38837714201799 | (37.7809672274079, -122.388377142018) | |||
| 61544 | 61544 | 132098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.802442786052396 | -122.40041578348699 | (37.8024427860524, -122.400415783487) | |||
| 62624 | 62624 | 132132 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013567.49669 | 2118786.0724 | 37.798545661218 | -122.39712759317699 | (37.798545661218, -122.397127593177) | |||
| 66121 | 66121 | 194352 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016055.63748 | 2113520.42583 | 37.7842255997618 | -122.388150099168 | (37.7842255997618, -122.388150099168) | |||
| 79855 | 79855 | 28229 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
| 80653 | 80653 | 28194 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
| 82856 | 82856 | 25006 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 470X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004864.935087999 | 2105663.9116336997 | 37.762027135623605 | -122.426306436493 | (37.7620271356236, -122.426306436493) | |||
| 94898 | 94898 | 28032 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 12 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | ||
| 99831 | 99831 | 25146 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 100281 | 100281 | 24985 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 121520 | 121520 | 25525 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
| 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) | |||
| 3463 | 3463 | 25005 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004909.6221900005 | 2105744.1135299997 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | |||
| 13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
| 29064 | 29064 | 194335 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403588999 | (37.7809992081901, -122.38849403589) | |||
| 35095 | 35095 | 132128 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014303.114130001 | 2117497.5911 | 37.7950487184753 | -122.39449183764299 | (37.7950487184753, -122.394491837643) | |||
| 54301 | 54301 | 194281 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6016211.24922 | 2100302.5214299997 | 37.7479407097974 | -122.38668969007601 | (37.7479407097974, -122.386689690076) | ||||
| 74450 | 74450 | 132131 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6013617.689669999 | 2118709.1573799998 | 37.7983372649156 | -122.39694851296001 | (37.7983372649156, -122.39694851296) |
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");