trees
897 rows where qSpecies_id = 160 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65475 | 96830 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
168440 | 96829 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
166202 | 96828 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
187923 | 96827 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
136779 | 96826 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
170914 | 96825 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
30456 | 96824 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
156457 | 96823 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
22504 | 96822 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
89748 | 96821 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | |||
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 | |||
164675 | 96686 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985884.08947 | 2113350.81045 | 37.7820420106561 | -122.492519011995 | (37.7820420106561, -122.492519011995) | 11 | 6 | 2 | 55 | 26 | ||
38835 | 96683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 28 | Permit Number 768040 | 5985881.45738 | 2113426.06761 | 37.7822484912616 | -122.492533661722 | (37.7822484912616, -122.492533661722) | 11 | 6 | 2 | 55 | 26 | ||
46829 | 96681 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985880.88078 | 2113443.18167 | 37.7822954478301 | -122.492536917233 | (37.7822954478301, -122.492536917233) | 11 | 6 | 2 | 55 | 26 | ||
123327 | 96673 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1449 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6014955.39834 | 2095258.9558 | 37.7340225115191 | -122.390680007822 | (37.7340225115191, -122.390680007822) | 10 | 3 | 8 | 58 | 1 | |||
86619 | 95065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | 10 | 3 | 8 | 58 | 1 | |||
148760 | 9369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
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 | |||
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 | |||
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 | |||||
109708 | 703 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | 2 | 7 | 5 | 28859 | 22 | |||
167307 | 67033 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 174 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1992 12:00:00 AM | 30 | 5x5 | Permit Number 30405 | 5992451.37715 | 2114312.24159 | 37.7850636224737 | -122.469869417746 | (37.7850636224737, -122.469869417746) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
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 | |||
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 | ||
82561 | 5679 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.17219 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | 2 | 7 | 5 | 63 | 22 | ||
115608 | 5557 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 977 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2006 12:00:00 AM | 32 | 3x3 | 6005125.10547 | 2102657.90315 | 37.753788045101 | -122.425192702095 | (37.753788045101, -122.425192702095) | 2 | 4 | 5 | 28859 | 19 | ||
28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
159468 | 5457 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 8 | 6004998.45452 | 2104996.17843 | 37.7602012446183 | -122.425797113951 | (37.7602012446183, -122.425797113951) | 2 | 4 | 5 | 28859 | 19 | |||
192759 | 5446 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 14 | Median : Cutout | Tree | DPW 1 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | ||
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 | ||||
163164 | 29537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2600X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.389986064473 | (37.7225535544976, -122.389986064473) | 10 | 3 | 8 | 58 | 1 | |||
144525 | 29536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2600X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6015127.6919 | 2091149.846 | 37.7227492757118 | -122.389797412937 | (37.7227492757118, -122.389797412937) | 10 | 3 | 8 | 58 | 1 | |||
90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
170678 | 28224 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 7 | 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 | ||||
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 | ||||
185236 | 28221 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 4 | 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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
132193 | 28031 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | 4 | 2 | 10 | 28860 | 6 | ||
43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
187664 | 28029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.74201 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | 4 | 2 | 10 | 28860 | 6 | ||
191559 | 28028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | 4 | 2 | 10 | 28860 | 6 | ||
111729 | 28027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.97501 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | 4 | 2 | 10 | 28860 | 6 | ||
17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
28206 | 28025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.7960727946079 | -122.394977873693 | (37.7960727946079, -122.394977873693) | 3 | 2 | 10 | 28860 | 6 | ||
45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
77477 | 28023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | 3 | 2 | 10 | 28860 | 6 | ||
144197 | 28022 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.7963552526163 | -122.39520669408 | (37.7963552526163, -122.39520669408) | 3 | 2 | 10 | 28860 | 6 | ||
48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
132259 | 28003 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
129077 | 28002 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
73069 | 28001 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
119113 | 28000 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
166942 | 27999 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
144410 | 27998 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
74716 | 27997 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
185888 | 27962 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
152650 | 27961 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
92097 | 27960 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
39492 | 27959 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
28642 | 27958 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
129757 | 27951 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
145456 | 27950 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
86897 | 27949 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 |
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) );