trees
897 rows where qSpecies_id = 160 sorted by Fire Prevention Districts
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) | ||||||||||
| 35049 | 194282 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 6 | Front Yard : Yard | Tree | Private 2 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | 3 | 8 | 58 | 1 | |||||
| 53310 | 194279 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 21 | Front Yard : Yard | Tree | Private 2 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | 3 | 8 | 58 | 1 | |||||
| 88702 | 194283 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6016255.79944 | 2100318.37917 | 37.7479867182066 | -122.386536741486 | (37.7479867182066, -122.386536741486) | 3 | 8 | 58 | 1 | |||||
| 115708 | 194280 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 18 | Front Yard : Yard | Tree | Private 2 | 3 | 6016126.44291 | 2100241.55687 | 37.7477686182436 | -122.386978698012 | (37.7477686182436, -122.386978698012) | 3 | 8 | 58 | 1 | |||||
| 119218 | 194281 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 11 | Front Yard : Yard | Tree | Private 2 | 38 | 6016211.24922 | 2100302.52143 | 37.7479407097974 | -122.386689690076 | (37.7479407097974, -122.386689690076) | 3 | 8 | 58 | 1 | |||||
| 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) | ||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 1611 | 247638 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.409751390215 | (37.7373232876386, -122.409751390215) | 10 | 7 | 7 | 28859 | 2 | ||||
| 3537 | 18548 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014665.0129 | 2095058.69239 | 37.7334565140045 | -122.391669970993 | (37.7334565140045, -122.391669970993) | 10 | 3 | 8 | 58 | 1 | |||
| 4436 | 194278 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 22nd St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6012817.61072 | 2103799.38432 | 37.7573538722899 | -122.398670182286 | (37.7573538722899, -122.398670182286) | 10 | 3 | 8 | 28856 | 29 | ||||
| 7512 | 234395 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X Ogden Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
| 11271 | 194293 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 46 | Median : Yard | Tree | DPW 1 | 28 | 6014318.79649 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | 10 | 3 | 8 | 58 | 1 | ||||
| 14024 | 194292 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 43 | Median : Yard | Tree | DPW 1 | 38 | 6014354.24031 | 2095291.86255 | 37.7340794959614 | -122.392760714642 | (37.7340794959614, -122.392760714642) | 10 | 3 | 8 | 58 | 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 | ||||
| 22376 | 194392 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 5 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6014755.05221 | 2089115.57759 | 37.7171429037943 | -122.390943451878 | (37.7171429037943, -122.390943451878) | 10 | 3 | 8 | 58 | 1 | |||
| 23344 | 194391 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 828x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014866.8225 | 2088973.55401 | 37.7167591360948 | -122.390547193499 | (37.7167591360948, -122.390547193499) | 10 | 3 | 8 | 58 | 1 | |||
| 25166 | 194288 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 37 | Median : Yard | Tree | DPW 1 | 34 | 6014411.93404 | 2095259.01392 | 37.7339925045513 | -122.392558950849 | (37.7339925045513, -122.392558950849) | 10 | 3 | 8 | 58 | 1 | ||||
| 25303 | 194388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | 6013107.94825 | 2089911.65871 | 37.7192372512804 | -122.396692522765 | (37.7192372512804, -122.396692522765) | 10 | 3 | 8 | 58 | 1 | ||||
| 25464 | 18556 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 11 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | 10 | 3 | 8 | 58 | 1 | |||
| 34128 | 194284 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | 31 | 6014504.15008 | 2095180.20764 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | 10 | 3 | 8 | 58 | 1 | ||||
| 35031 | 194386 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | 10 | 3 | 8 | 58 | 1 | ||||
| 37923 | 234382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.407418219675 | (37.7561790447523, -122.407418219675) | 10 | 4 | 7 | 28859 | 19 | |||
| 38743 | 18563 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 18 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 44354 | 194295 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1942 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | 10 | 3 | 8 | 58 | 1 | |||
| 45318 | 194287 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 32 | Median : Yard | Tree | DPW 1 | 31 | 6014435.32238 | 2095233.37666 | 37.7339234087228 | -122.392476296866 | (37.7339234087228, -122.392476296866) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 55277 | 194276 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2347 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | 6010780.52383 | 2105047.83738 | 37.7606681393399 | -122.405803207256 | (37.7606681393399, -122.405803207256) | 10 | 3 | 8 | 28856 | 29 | ||||
| 55447 | 194394 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014490.42947 | 2089308.04208 | 37.7176566864975 | -122.391871584628 | (37.7176566864975, -122.391871584628) | 10 | 3 | 8 | 58 | 1 | |||
| 57058 | 194389 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | 10 | 3 | 8 | 58 | 1 | ||||
| 62567 | 194289 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 38 | Median : Yard | Tree | DPW 1 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.392613948889 | (37.734007417094, -122.392613948889) | 10 | 3 | 8 | 58 | 1 | ||||
| 65015 | 194291 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 41 | Median : Yard | Tree | DPW 1 | 38 | 6014364.32912 | 2095287.31351 | 37.7340675655682 | -122.392725516077 | (37.7340675655682, -122.392725516077) | 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 | |||
| 66787 | 194390 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6013152.66051 | 2089880.87187 | 37.7191552052161 | -122.396535811395 | (37.7191552052161, -122.396535811395) | 10 | 3 | 8 | 58 | 1 | ||||
| 73854 | 194294 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 49 | Median : Yard | Tree | DPW 1 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 75350 | 178084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.397811068042 | (37.7126358803078, -122.397811068042) | 10 | 3 | 8 | 309 | 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 | |||
| 94606 | 194290 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 40 | Median : Yard | Tree | DPW 1 | 27 | 6014381.30223 | 2095272.57767 | 37.7340280466394 | -122.392665803801 | (37.7340280466394, -122.392665803801) | 10 | 3 | 8 | 58 | 1 | ||||
| 99109 | 194297 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2198 Revere Ave | 1 | Side Yard : Yard | Tree | Private 2 | 31 | 6011968.87844 | 2096761.78456 | 37.7379828180593 | -122.401110955803 | (37.7379828180593, -122.401110955803) | 10 | 3 | 8 | 58 | 1 | ||||
| 100339 | 247642 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 632 Banks St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.413075474255 | (37.7354426820387, -122.413075474255) | 10 | 7 | 7 | 28859 | 2 | |||
| 102382 | 194387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6013093.20116 | 2089924.29981 | 37.7192711404238 | -122.396744383961 | (37.7192711404238, -122.396744383961) | 10 | 3 | 8 | 58 | 1 | ||||
| 117843 | 194273 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Tennessee St | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6015573.17514 | 2103426.76477 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | 10 | 3 | 8 | 28856 | 29 | |||
| 123280 | 194286 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 29 | Median : Yard | Tree | DPW 1 | 36 | 6014450.16973 | 2095221.39939 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 125430 | 194274 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Tennessee St | 17 | Median : Yard | Tree | DPW 1 | 28 | 6015578.25592 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | 10 | 3 | 8 | 28856 | 29 | ||||
| 130470 | 194393 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 9 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | 6014647.11529 | 2089218.63866 | 37.7174198994758 | -122.391323741894 | (37.7174198994758, -122.391323741894) | 10 | 3 | 8 | 58 | 1 | |||
| 130810 | 178085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012726.32279 | 2087488.85731 | 37.7125634740919 | -122.397841808652 | (37.7125634740919, -122.397841808652) | 10 | 3 | 8 | 309 | 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 | |||
| 157546 | 194285 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 28 | Median : Yard | Tree | DPW 1 | 30 | 6014471.94536 | 2095201.40696 | 37.7338376601657 | -122.392347443777 | (37.7338376601657, -122.392347443777) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 168952 | 194296 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1799 Revere Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 6014052.02799 | 2095141.78592 | 37.733650626363 | -122.393795063609 | (37.733650626363, -122.393795063609) | 10 | 3 | 8 | 58 | 1 | ||||
| 170823 | 194277 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | Width 7ft | 6012002.23785 | 2102241.02504 | 37.7530294975215 | -122.401380567153 | (37.7530294975215, -122.401380567153) | 10 | 3 | 8 | 28856 | 29 | |||
| 181615 | 18559 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.7336616880341 | -122.392019656183 | (37.7336616880341, -122.392019656183) | 10 | 3 | 8 | 58 | 1 | |||
| 183525 | 18555 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014626.04256 | 2095092.92008 | 37.7335483329791 | -122.391807096032 | (37.7335483329791, -122.391807096032) | 10 | 3 | 8 | 58 | 1 | |||
| 185555 | 194395 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 9 | Median : Cutout | Tree | DPW 1 | 20 | Width 5ft | 6014427.53162 | 2089348.90616 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | 10 | 3 | 8 | 58 | 1 | |||
| 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 |
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) );