trees
897 rows where qSpecies_id = 160 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174 | 259410 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 7 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 1493 | 264741 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 2 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
| 3088 | 261629 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 620x The Embarcadero | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012640 | 2120258 | 37.8025355435841 | -122.400440487668 | (37.8025355435841, -122.400440487668) | 3 | 1 | 10 | 28860 | 6 | ||||
| 4101 | 261179 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
| 9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 9494 | 259411 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 12278 | 259406 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 3 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 12845 | 259408 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 5 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
| 13313 | 251111 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 7 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 13403 | 261178 | Property Tree 8 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
| 13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 15348 | 264739 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
| 15958 | 251109 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 15995 | 251116 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 16199 | 259409 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 6 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 18007 | 259314 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 18679 | 264760 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1501 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 18870 | 259407 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 19170 | 251114 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 16 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 19478 | 251110 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 5 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 19932 | 93074 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 301 Executive Park Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.7111429140183 | -122.390768534473 | (37.7111429140183, -122.390768534473) | 10 | 3 | 8 | 58 | 1 | ||
| 20118 | 173670 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012236 | 2086860 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | 10 | 3 | 8 | 309 | 1 | ||||
| 27019 | 51202 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.7600495413778 | -122.43037732339 | (37.7600495413778, -122.43037732339) | 2 | 4 | 5 | 28862 | 3 | ||||
| 32680 | 119700 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 6x Octavia St Frontage West | 2 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
| 38982 | 60467 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883 | 2089135 | 37.7161883486769 | -122.452719710267 | (37.7161883486769, -122.452719710267) | 9 | 8 | 6 | 28861 | 24 | |||
| 38999 | 103927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 13 | Median : Cutout | Tree | DPW 1 | 02/05/2001 12:00:00 AM | 4x4 | 6014859 | 2117030 | 37.793795709184 | -122.392535650186 | (37.793795709184, -122.392535650186) | 12 | 2 | 10 | 28855 | 6 | |||
| 55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
| 68051 | 255454 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000622 | 2094989 | 37.7324756340381 | -122.440215522188 | (37.7324756340381, -122.440215522188) | 9 | 7 | 5 | 63 | 40 | ||||
| 73230 | 96694 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 3132@32nd Ave Clement St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 87181 | 106114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1752X DOLORES ST | 1 | Median : Yard | Tree | DPW 1 | 6005197 | 2098194.1 | 37.7415355284645 | -122.424626562024 | (37.7415355284645, -122.424626562024) | 2 | 7 | 5 | 63 | 7 | |||||
| 112363 | 96695 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 3132@32nd Ave Clement St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 124825 | 96692 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 3132@32nd Ave Clement St | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 128733 | 119624 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | ||||
| 129258 | 96693 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 3132@32nd Ave Clement St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 137613 | 116685 | Undocumented 4 | Phoenix canariensis :: Canary Island Date Palm 160 | 1x BIRD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005912 | 2105722 | 37.7622457626745 | -122.422689168159 | (37.7622457626745, -122.422689168159) | 8 | 4 | 5 | 28859 | 19 | ||||
| 139354 | 92744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52968 | 6009200 | 2091312 | 37.7228640173614 | -122.41029969524 | (37.7228640173614, -122.41029969524) | 9 | 3 | 7 | 309 | 28 | |||
| 165589 | 119699 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 6x Octavia St Frontage West | 1 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
| 183865 | 26537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 06/23/1997 12:00:00 AM | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 185249 | 87850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.451634593656 | (37.7437272652603, -122.451634593656) | 9 | 7 | 4 | 59 | 40 | |||
| 30086 | 14174 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
| 121696 | 14173 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
| 174513 | 210908 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1351 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5994231.83561 | 2106400.13756 | 37.7634418445856 | -122.463135347428 | (37.7634418445856, -122.463135347428) | 1 | 5 | 11 | 56 | 12 | |||
| 33204 | 234387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005043.99676 | 2102621.60144 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | 2 | 4 | 5 | 28862 | 22 | |||
| 53288 | 210910 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387 | -122.461135900907 | (37.743908769387, -122.461135900907) | 1 | 8 | 4 | 59 | 40 | |||
| 84522 | 234381 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Eugenia Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.419926400796 | (37.74136892295, -122.419926400796) | 2 | 7 | 7 | 28859 | 2 | ||||
| 137929 | 210904 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1539 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990882.40967 | 2107206.58351 | 37.7654626131273 | -122.474778680202 | (37.7654626131273, -122.474778680202) | 11 | 8 | 11 | 56 | 12 | |||
| 140960 | 210905 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1545 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990857.32948 | 2107205.82169 | 37.7654590680093 | -122.474865370365 | (37.7654590680093, -122.474865370365) | 11 | 8 | 11 | 56 | 12 | |||
| 151516 | 118706 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4201 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 5982550.59501 | 2110970.7524 | 37.7753116033094 | -122.503874858049 | (37.7753116033094, -122.503874858049) | 11 | 6 | 2 | 55 | 26 | |||
| 169551 | 234385 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 384 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004737.93375 | 2109866.74234 | 37.7735599182016 | -122.427045042888 | (37.7735599182016, -122.427045042888) | 7 | 9 | 11 | 28852 | 10 | |||
| 188799 | 234384 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 899 Hampshire St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6010216.79049 | 2104076.88773 | 37.757970587791 | -122.407684453188 | (37.757970587791, -122.407684453188) | 10 | 4 | 7 | 28859 | 19 | |||
| 35617 | 5707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005241.86416 | 2098983.9941 | 37.7437069318227 | -122.424527610259 | (37.7437069318227, -122.424527610259) | 2 | 7 | 5 | 63 | 22 | |||
| 102242 | 5485 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
| 147428 | 187316 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.7442631184817 | -122.494303219592 | (37.7442631184817, -122.494303219592) | 1 | 8 | 3 | 29491 | 35 | |||
| 4245 | 28231 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 11369 | 28185 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 20723 | 28232 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 21114 | 28183 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 21756 | 28219 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 22545 | 28193 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 26231 | 28190 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 32855 | 25683 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481 | -122.388411289639 | (37.781564418481, -122.388411289639) | 6 | 2 | 9 | 28856 | 20 | ||
| 38161 | 28233 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 39367 | 25684 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015953.02501 | 2112484.79201 | 37.781376296324 | -122.388432795571 | (37.781376296324, -122.388432795571) | 6 | 2 | 9 | 28856 | 20 | ||
| 42942 | 28236 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 43710 | 27848 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015938.91901 | 2112416.43301 | 37.7811878161514 | -122.388476823036 | (37.7811878161514, -122.388476823036) | 6 | 2 | 9 | 28856 | 20 | ||
| 46369 | 28229 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 50694 | 28220 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 53552 | 28226 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 53940 | 28194 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 54047 | 18560 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014546.06488 | 2095149.21711 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | 10 | 3 | 8 | 58 | 1 | |||
| 66070 | 18558 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 13 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 66677 | 28227 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 68062 | 28186 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 74134 | 18554 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 9 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 85929 | 28191 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 90541 | 28237 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 91483 | 28184 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 93163 | 25628 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.395457184304 | (37.796375512586, -122.395457184304) | 3 | 2 | 10 | 28860 | 6 | ||
| 104027 | 28189 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 106305 | 5683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.63053 | 37.7457272812867 | -122.424719964463 | (37.7457272812867, -122.424719964463) | 2 | 7 | 5 | 63 | 22 | ||
| 111795 | 28225 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 117319 | 28235 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 122641 | 28192 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 123039 | 28230 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 124162 | 25629 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.7962750492973 | -122.395365553278 | (37.7962750492973, -122.395365553278) | 3 | 2 | 10 | 28860 | 6 | ||
| 130811 | 28188 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 132853 | 27850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.388618336487 | (37.7808457639334, -122.388618336487) | 6 | 2 | 9 | 28856 | 20 | ||
| 140133 | 28228 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 140856 | 28238 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 146762 | 28223 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 147240 | 25630 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | 3 | 2 | 10 | 28860 | 6 | ||
| 157234 | 28222 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 161413 | 28218 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 164202 | 28234 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 164580 | 27849 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | 6 | 2 | 9 | 28856 | 20 | ||
| 166238 | 28187 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 167386 | 27852 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.7805375397414 | -122.388880882265 | (37.7805375397414, -122.388880882265) | 6 | 2 | 9 | 28856 | 20 | ||
| 168494 | 24290 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X17 | 6000963.19469 | 2086697.35612 | 37.7097280749492 | -122.438442083037 | (37.7097280749492, -122.438442083037) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );