trees
897 rows where qSpecies_id = 160 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1062 | 20065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
1504 | 19794 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
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 | |||||||||||||||
13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
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 | |||||||||||||||
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 | |||||||||||||||
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) | ||||||||||
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) | ||||||||||
63037 | 118547 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5981731.05099 | 2112390.85514 | 37.7791625633163 | -122.506815156259 | (37.7791625633163, -122.506815156259) | 11 | 6 | 2 | 55 | 26 | |||
56236 | 118759 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.506024939755 | (37.7781852088244, -122.506024939755) | 11 | 6 | 2 | 55 | 26 | |||
35012 | 118600 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 249 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 37 | 5981958.17368 | 2112601.6345 | 37.7797546732687 | -122.506045091658 | (37.7797546732687, -122.506045091658) | 11 | 6 | 2 | 55 | 26 | ||||
104698 | 118599 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 249 Point Lobos Ave | 4 | Side Yard : Yard | Tree | Private 2 | 35 | 5981986.20635 | 2112598.88182 | 37.7797487653148 | -122.505947911919 | (37.7797487653148, -122.505947911919) | 11 | 6 | 2 | 55 | 26 | ||||
155454 | 118598 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 249 Point Lobos Ave | 8 | Side Yard : Yard | Tree | Private 2 | 35 | 5982022.83827 | 2112594.06181 | 37.7797376871414 | -122.505820830838 | (37.7797376871414, -122.505820830838) | 11 | 6 | 2 | 55 | 26 | ||||
14706 | 118708 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | 11 | 6 | 2 | 55 | 26 | |||
174070 | 118707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.7753106610998 | -122.503888560039 | (37.7753106610998, -122.503888560039) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
170063 | 118002 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.7805800987768 | -122.496794630747 | (37.7805800987768, -122.496794630747) | 11 | 6 | 2 | 55 | 26 | |||
189394 | 186179 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984928.6664 | 2103564.4514 | 37.7551155313127 | -122.495102422977 | (37.7551155313127, -122.495102422977) | 1 | 8 | 3 | 56 | 35 | |||
4941 | 186180 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984958.094 | 2103565.49 | 37.7551201057822 | -122.495000731871 | (37.7551201057822, -122.495000731871) | 1 | 8 | 3 | 56 | 35 | |||
164985 | 186007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985000.2752 | 2101640.5507 | 37.749837221065 | -122.49471294958 | (37.749837221065, -122.49471294958) | 1 | 8 | 3 | 29491 | 35 | |||
124312 | 182197 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | 1 | 8 | 3 | 56 | 35 | |||
145259 | 186006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985010.9219 | 2101633.2915 | 37.7498179124605 | -122.494675598244 | (37.7498179124605, -122.494675598244) | 1 | 8 | 3 | 29491 | 35 | |||
81219 | 186008 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985026.892 | 2101640.0667 | 37.7498374500445 | -122.494620873169 | (37.7498374500445, -122.494620873169) | 1 | 8 | 3 | 29491 | 35 | |||
116886 | 118208 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 578 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
121785 | 185441 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985106.1344 | 2099492.3058 | 37.7439449206951 | -122.494188569919 | (37.7439449206951, -122.494188569919) | 1 | 8 | 3 | 29491 | 35 | |||
77150 | 182268 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1466 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 0ft | 5985290.7143 | 2105238.2671 | 37.759732554956 | -122.493973725026 | (37.759732554956, -122.493973725026) | 1 | 8 | 3 | 56 | 35 | |||
106557 | 119450 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 33rd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5985749.05602 | 2110390.9661 | 37.7739072286205 | -122.492768088777 | (37.7739072286205, -122.492768088777) | 11 | 6 | 2 | 55 | 26 | ||||
110853 | 185382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2615 34th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 0ft | 5985803.8248 | 2097379.5833 | 37.7381847526444 | -122.491620661903 | (37.7381847526444, -122.491620661903) | 1 | 8 | 3 | 29491 | 35 | |||
139512 | 182680 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985854.1638 | 2103629.592 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
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 | ||
83503 | 182681 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2701 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5985882.7747 | 2103629.0901 | 37.7553488224274 | -122.491807644065 | (37.7553488224274, -122.491807644065) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
44648 | 119407 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375 32nd Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 9ft | 5985884.85714 | 2113320.57304 | 37.7819590323137 | -122.492514128744 | (37.7819590323137, -122.492514128744) | 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 | |||
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 | |||
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 | |||
108889 | 182872 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1845 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5987505.5699 | 2102718.6655 | 37.7529437568716 | -122.48612877159 | (37.7529437568716, -122.48612877159) | 1 | 8 | 3 | 56 | 35 | |||
133231 | 182873 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | 1 | 8 | 3 | 56 | 35 | |||
32602 | 120819 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587102 | (37.7856385654779, -122.47984587102) | 11 | 6 | 2 | 55 | 26 | |||
104462 | 120800 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4400 Fulton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 5ft | 5989719.73075 | 2109944.061 | 37.7729115360186 | -122.479000326374 | (37.7729115360186, -122.479000326374) | 11 | 6 | 2 | 55 | 26 | |||
101092 | 120801 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4400 Fulton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 5989725.4481 | 2109944.43454 | 37.7729128936687 | -122.478980576929 | (37.7729128936687, -122.478980576929) | 11 | 6 | 2 | 55 | 26 | |||
137161 | 210913 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5990641.45059 | 2103071.06132 | 37.7540936050568 | -122.475310139971 | (37.7540936050568, -122.475310139971) | 1 | 8 | 4 | 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 | |||
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 | |||
137538 | 210903 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.473153888536 | (37.7517188372786, -122.473153888536) | 1 | 8 | 4 | 29491 | 12 | |||
24405 | 210906 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.472393751863 | (37.7599277068135, -122.472393751863) | 1 | 8 | 4 | 56 | 12 | |||
20887 | 210907 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 32 | Width 3ft | 5991740.69924 | 2105187.89339 | 37.7599695243799 | -122.471662958305 | (37.7599695243799, -122.471662958305) | 1 | 8 | 4 | 56 | 12 | |||
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 | |
125654 | 210914 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 317 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993048.09757 | 2099658.5212 | 37.7448628475372 | -122.466739393103 | (37.7448628475372, -122.466739393103) | 1 | 8 | 4 | 29491 | 40 | |||
162934 | 218157 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1396 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | 5993196.82548 | 2097677.09951 | 37.7394309459859 | -122.46608116671 | (37.7394309459859, -122.46608116671) | 1 | 8 | 4 | 59 | 40 | ||||
174356 | 218156 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1396 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5993216.16649 | 2097685.94396 | 37.7394563464375 | -122.466014937058 | (37.7394563464375, -122.466014937058) | 1 | 8 | 4 | 59 | 40 | ||||
114949 | 210919 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994015.85922 | 2099234.22929 | 37.7437536525071 | -122.463362295833 | (37.7437536525071, -122.463362295833) | 1 | 8 | 4 | 59 | 40 | |||
114206 | 210918 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994017.59782 | 2099245.20708 | 37.7437838949233 | -122.463357080672 | (37.7437838949233, -122.463357080672) | 1 | 8 | 4 | 59 | 40 | |||
75567 | 210920 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994018.26687 | 2099229.17211 | 37.7437399054734 | -122.463353603909 | (37.7437399054734, -122.463353603909) | 1 | 8 | 4 | 59 | 40 | |||
70812 | 210921 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994023.0507 | 2099217.557 | 37.7437082889086 | -122.463336220006 | (37.7437082889086, -122.463336220006) | 1 | 8 | 4 | 59 | 40 | |||
12082 | 210917 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994023.92221 | 2099259.09244 | 37.7438223849926 | -122.463336219994 | (37.7438223849926, -122.463336219994) | 1 | 8 | 4 | 59 | 40 | |||
67446 | 210916 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) | 1 | 8 | 4 | 59 | 40 | |||
124175 | 210915 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 587 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 4ft | 5994038.34106 | 2099299.34237 | 37.7439337318666 | -122.463289283487 | (37.7439337318666, -122.463289283487) | 1 | 8 | 4 | 59 | 40 | |||
21377 | 210922 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 4ft | 5994038.37723 | 2099205.21989 | 37.7436752972852 | -122.463282329909 | (37.7436752972852, -122.463282329909) | 1 | 8 | 4 | 59 | 40 | |||
104220 | 109174 | Undocumented 4 | Phoenix canariensis :: Canary Island Date Palm 160 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.462644049637 | (37.7270439629203, -122.462644049637) | 9 | 8 | 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 | |||||
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 | |||
120657 | 210909 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994659.02084 | 2099296.69557 | 37.7439622025921 | -122.461142939006 | (37.7439622025921, -122.461142939006) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
82936 | 124656 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.459606621954 | (37.7883362746058, -122.459606621954) | 11 | 6 | 1 | 54 | 11 | |||
137220 | 124657 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 30 Presidio Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 7ft | 5995444.46973 | 2115398.79213 | 37.7882195529326 | -122.459593054716 | (37.7882195529326, -122.459593054716) | 11 | 6 | 1 | 54 | 11 | |||
60479 | 124659 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 199 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 8ft | 5995478.86593 | 2115238.56038 | 37.7877815776324 | -122.459462441459 | (37.7877815776324, -122.459462441459) | 11 | 6 | 1 | 54 | 11 | |||
187379 | 1443 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 151X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | |||
138744 | 124647 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Arguello Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5995536.86088 | 2115835.19472 | 37.78942310858 | -122.459305014392 | (37.78942310858, -122.459305014392) | 11 | 6 | 1 | 54 | 31 | ||||
171088 | 210924 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1540 Plymouth Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 3ft | 5995827.11774 | 2094309.51389 | 37.7303357729732 | -122.456743340437 | (37.7303357729732, -122.456743340437) | 9 | 7 | 4 | 28861 | 40 | |||
20323 | 210923 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1540 Plymouth Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 3ft | 5995839.22139 | 2094293.33064 | 37.7302920326405 | -122.456700326779 | (37.7302920326405, -122.456700326779) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
184623 | 210928 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | 5997342.33131 | 2095240.63361 | 37.7329792905421 | -122.451572201795 | (37.7329792905421, -122.451572201795) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
86782 | 210912 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 5997433.76219 | 2094954.34243 | 37.7321984389023 | -122.451235463255 | (37.7321984389023, -122.451235463255) | 9 | 7 | 4 | 59 | 40 | ||||
54034 | 210911 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | 9 | 7 | 4 | 59 | 40 | ||||
49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
52518 | 13388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5997667.52153 | 2098758.8322 | 37.7426580336411 | -122.45070150969 | (37.7426580336411, -122.45070150969) | 9 | 7 | 4 | 59 | 40 | |||
71795 | 132067 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3038 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999089.10208 | 2119262.1852 | 37.799036302553 | -122.44726145536 | (37.799036302553, -122.44726145536) | 13 | 9 | 1 | 57 | 17 | |||
177852 | 132068 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3601 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999659.13048 | 2120925.06177 | 37.8036346701745 | -122.445408603735 | (37.8036346701745, -122.445408603735) | 13 | 9 | 1 | 57 | 17 | |||
77645 | 210925 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 43 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 10ft | 5999799.64358 | 2095482.91454 | 37.7337849536105 | -122.443094053648 | (37.7337849536105, -122.443094053648) | 9 | 7 | 4 | 63 | 40 | |||
184237 | 210926 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 39 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 10ft | 5999833.49072 | 2095475.12852 | 37.7337655048678 | -122.44297647541 | (37.7337655048678, -122.44297647541) | 9 | 7 | 4 | 63 | 40 | |||
3603 | 247549 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 815 Buena Vista Ave West | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6000106.41756 | 2108406.30035 | 37.7692869261681 | -122.442961199511 | (37.7692869261681, -122.442961199511) | 15 | 5 | 11 | 29492 | 9 | |||
113407 | 210927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 234 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6000492.41263 | 2094973.31916 | 37.732425199355 | -122.440662410937 | (37.732425199355, -122.440662410937) | 9 | 7 | 5 | 63 | 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 | ||||
168832 | 245079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 154 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 0ft | 6000824.0394 | 2109520.8819 | 37.7723881764486 | -122.440558941181 | (37.7723881764486, -122.440558941181) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
82878 | 178086 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 364 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 3ft | 6001063.00753 | 2092653.59806 | 37.7260882551546 | -122.438523588412 | (37.7260882551546, -122.438523588412) | 9 | 7 | 6 | 28861 | 25 | |||
128175 | 234400 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4 Corwin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 3ft | 6001132.88166 | 2103964.26051 | 37.7571486461001 | -122.439092314277 | (37.7571486461001, -122.439092314277) | 2 | 4 | 5 | 28862 | 38 | |||
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 | |||
174797 | 234396 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1351 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 6ft | 6001401.68154 | 2099734.75899 | 37.7455507389883 | -122.437859774517 | (37.7455507389883, -122.437859774517) | 2 | 4 | 5 | 63 | 22 | |||
119946 | 234398 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3980 22nd St | 8 | : | Tree | Private 2 | 32 | 6001905.07347 | 2102956.38941 | 37.7544251823875 | -122.436349651817 | (37.7544251823875, -122.436349651817) | 2 | 4 | 5 | 28862 | 22 |
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) );