trees
897 rows where qSpecies_id = 160 sorted by Zip Codes
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) | ||||||||||
49577 | 25506 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1998X Market St | 6 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.426362499197 | (37.7696634052537, -122.426362499197) | 7 | 4 | 5 | 28852 | 10 | ||
76035 | 233929 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8 Octavia St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6005769.81739 | 2109368.12443 | 37.7722491293339 | -122.423440144659 | (37.7722491293339, -122.423440144659) | 7 | 9 | 11 | 28852 | 10 | ||||
76048 | 246535 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6005703.30857 | 2109325.61851 | 37.7721286642513 | -122.423667182089 | (37.7721286642513, -122.423667182089) | 7 | 9 | 11 | 28852 | 10 | |||
90037 | 25507 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1998X Market St | 7 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.426362499197 | (37.7696634052537, -122.426362499197) | 7 | 4 | 5 | 28852 | 10 | ||
90140 | 104248 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
103758 | 233928 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.7721950216148 | -122.423420179704 | (37.7721950216148, -122.423420179704) | 7 | 9 | 11 | 28852 | 10 | |||
120541 | 246536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1x Octavia St | 2 | Median : Yard | Tree | DPW 1 | 31 | Width 8ft | 6005696.49055 | 2109344.97624 | 37.7721814310539 | -122.423692142805 | (37.7721814310539, -122.423692142805) | 7 | 9 | 11 | 28852 | 10 | |||
134915 | 104247 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
142816 | 25505 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1998X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.426362499197 | (37.7696634052537, -122.426362499197) | 7 | 4 | 5 | 28852 | 10 | ||
169551 | 234385 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 384 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004737.93375 | 2109866.74234 | 37.7735599182016 | -122.427045042888 | (37.7735599182016, -122.427045042888) | 7 | 9 | 11 | 28852 | 10 | |||
8378 | 25503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.425481812147 | (37.7702480498919, -122.425481812147) | 7 | 2 | 5 | 28853 | 19 | ||
23418 | 248619 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1801x Market St | 1 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.423438937501 | (37.7715594473913, -122.423438937501) | 8 | 2 | 5 | 28853 | 19 | |||
27783 | 25501 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.7703500248187 | -122.425355725564 | (37.7703500248187, -122.425355725564) | 7 | 2 | 5 | 28853 | 19 | ||
30086 | 14174 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
31169 | 201683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 19 | Front Yard : Yard | Tree | Private 2 | 23 | 6010259.33764 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | 14 | 2 | 9 | 28853 | 34 | ||||
55472 | 25504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005007.7768 | 2108494.7101 | 37.769807904671 | -122.426013925385 | (37.769807904671, -122.426013925385) | 8 | 2 | 5 | 28853 | 19 | ||
66185 | 25498 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | 7 | 2 | 9 | 28853 | 19 | ||
67451 | 201687 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | 14 | 2 | 9 | 28853 | 34 | ||||
73469 | 234377 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 Harrison St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6008587.9096 | 2108086.3181 | 37.768888242332 | -122.413601406792 | (37.768888242332, -122.413601406792) | 8 | 4 | 7 | 28853 | 19 | |||
103678 | 201682 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 18 | Front Yard : Yard | Tree | Private 2 | 25 | 6010248.09063 | 2109749.24504 | 37.7735473393687 | -122.407976213039 | (37.7735473393687, -122.407976213039) | 14 | 2 | 9 | 28853 | 34 | ||||
109762 | 25500 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005964.12554 | 2109421.56816 | 37.7724068380339 | -122.422771813485 | (37.7724068380339, -122.422771813485) | 7 | 2 | 9 | 28853 | 19 | ||
115159 | 248621 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 132x McCoppin St | 1 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6005771.7237 | 2109102.262 | 37.7715192426118 | -122.423414646865 | (37.7715192426118, -122.423414646865) | 8 | 2 | 5 | 28853 | 19 | |||
117166 | 113319 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005986 | 2109035 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | 8 | 2 | 9 | 28853 | 19 | |||
120873 | 234376 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 Harrison St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.413603886225 | (37.7689633348285, -122.413603886225) | 8 | 4 | 7 | 28853 | 19 | |||
121696 | 14173 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
123803 | 201684 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 20 | Front Yard : Yard | Tree | Private 2 | 30 | 6010233.57215 | 2109769.89905 | 37.773603237626 | -122.408027891695 | (37.773603237626, -122.408027891695) | 14 | 2 | 9 | 28853 | 34 | ||||
128669 | 25499 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005915.63153 | 2109374.76445 | 37.7722755900698 | -122.42293623204 | (37.7722755900698, -122.42293623204) | 7 | 2 | 9 | 28853 | 19 | ||
128733 | 119624 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | ||||
152088 | 245964 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950x Market St | 2 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005048.2837 | 2108538.5237 | 37.7699304954931 | -122.425876932133 | (37.7699304954931, -122.425876932133) | 7 | 2 | 5 | 28853 | 19 | |||
153923 | 245963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950x Market St | 1 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | 7 | 2 | 5 | 28853 | 19 | |||
158271 | 248622 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 142x McCoppin St | 2 | Median : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6005746.1935 | 2109104.2775 | 37.7715233357229 | -122.423503100629 | (37.7715233357229, -122.423503100629) | 8 | 2 | 5 | 28853 | 19 | |||
159762 | 25496 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005866.13841 | 2109325.79411 | 37.772138336447 | -122.423103951995 | (37.772138336447, -122.423103951995) | 7 | 2 | 9 | 28853 | 19 | ||
163124 | 234403 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6006066.15182 | 2108969.94189 | 37.7711725365248 | -122.422386799311 | (37.7711725365248, -122.422386799311) | 8 | 2 | 9 | 28853 | 19 | |||
163179 | 245965 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950x Market St | 3 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005023.4835 | 2108512.8969 | 37.7698587289196 | -122.425960891085 | (37.7698587289196, -122.425960891085) | 8 | 2 | 5 | 28853 | 19 | |||
167872 | 194272 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1022 Minna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007547.68753 | 2109714.25342 | 37.7732997020571 | -122.417314852308 | (37.7732997020571, -122.417314852308) | 8 | 2 | 9 | 28853 | 19 | |||
169762 | 25497 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005883.25661 | 2109339.92737 | 37.7721781089695 | -122.423045743371 | (37.7721781089695, -122.423045743371) | 7 | 2 | 9 | 28853 | 19 | ||
177544 | 25502 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005183.0311 | 2108665.831 | 37.7702876647003 | -122.425419904307 | (37.7702876647003, -122.425419904307) | 8 | 2 | 5 | 28853 | 19 | ||
16115 | 194311 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 21 | Width 7ft | 6015171.22981 | 2116694.38601 | 37.7928915254696 | -122.391431824244 | (37.7928915254696, -122.391431824244) | 12 | 2 | 9 | 28855 | 6 | |||
23782 | 194377 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.7893046685309 | -122.388377800289 | (37.7893046685309, -122.388377800289) | 6 | 2 | 9 | 28855 | 6 | |||
27236 | 194306 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014568.03404 | 2117229.07965 | 37.7943261725661 | -122.393556366426 | (37.7943261725661, -122.393556366426) | 12 | 2 | 10 | 28855 | 6 | |||
28000 | 27867 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | 12 | 2 | 9 | 28855 | 6 | ||
28718 | 194364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.7873602722118 | -122.387727152497 | (37.7873602722118, -122.387727152497) | 6 | 2 | 9 | 28855 | 6 | |||
29479 | 194301 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014450.94814 | 2117319.50323 | 37.7945679480926 | -122.393967833244 | (37.7945679480926, -122.393967833244) | 12 | 2 | 10 | 28855 | 6 | |||
35397 | 194379 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | 6 | 2 | 9 | 28855 | 6 | |||
37098 | 194299 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014410.76303 | 2117359.45162 | 37.794675403602 | -122.394109677946 | (37.794675403602, -122.394109677946) | 12 | 2 | 10 | 28855 | 6 | |||
38999 | 103927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 13 | Median : Cutout | Tree | DPW 1 | 02/05/2001 12:00:00 AM | 4x4 | 6014859 | 2117030 | 37.793795709184 | -122.392535650186 | (37.793795709184, -122.392535650186) | 12 | 2 | 10 | 28855 | 6 | |||
39756 | 194385 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6015616.39603 | 2115848.18198 | 37.7905927414207 | -122.389832379957 | (37.7905927414207, -122.389832379957) | 6 | 2 | 9 | 28855 | 6 | |||
43024 | 194324 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 6014719.87282 | 2117222.06559 | 37.7943153492131 | -122.393030491457 | (37.7943153492131, -122.393030491457) | 12 | 2 | 10 | 28855 | 6 | |||
48140 | 194380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.7900674842722 | -122.389207795421 | (37.7900674842722, -122.389207795421) | 6 | 2 | 9 | 28855 | 6 | |||
50815 | 194375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6016059.60857 | 2115304.27364 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | 6 | 2 | 9 | 28855 | 6 | |||
51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 | |||
54880 | 194304 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | 12 | 2 | 10 | 28855 | 6 | |||
76255 | 194368 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016180.02295 | 2114964.39899 | 37.7881973143891 | -122.387820553369 | (37.7881973143891, -122.387820553369) | 6 | 2 | 9 | 28855 | 6 | |||
77982 | 194321 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.7940353120341 | -122.392743821769 | (37.7940353120341, -122.392743821769) | 12 | 2 | 10 | 28855 | 6 | |||
78238 | 194371 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016101.39527 | 2115134.80634 | 37.7886608582508 | -122.388104490939 | (37.7886608582508, -122.388104490939) | 6 | 2 | 9 | 28855 | 6 | |||
80832 | 194312 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 25 | Width 7ft | 6015090.90053 | 2116737.38808 | 37.7930051404365 | -122.391712777831 | (37.7930051404365, -122.391712777831) | 12 | 2 | 9 | 28855 | 6 | |||
88902 | 27870 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.08301 | 37.7928294135533 | -122.391484690649 | (37.7928294135533, -122.391484690649) | 12 | 2 | 9 | 28855 | 6 | ||
90546 | 194365 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016199.77941 | 2114766.14566 | 37.7876540501504 | -122.387738360742 | (37.7876540501504, -122.387738360742) | 6 | 2 | 9 | 28855 | 6 | |||
99182 | 194372 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016142.80175 | 2115153.32591 | 37.7887140027843 | -122.387962522166 | (37.7887140027843, -122.387962522166) | 6 | 2 | 9 | 28855 | 6 | |||
101879 | 194310 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015149.43028 | 2116672.04989 | 37.7928289857212 | -122.391505690053 | (37.7928289857212, -122.391505690053) | 12 | 2 | 9 | 28855 | 6 | |||
103535 | 194305 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 6014543.5989 | 2117243.74376 | 37.7943650790379 | -122.393641942341 | (37.7943650790379, -122.393641942341) | 12 | 2 | 10 | 28855 | 6 | |||
103858 | 194320 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | 12 | 2 | 10 | 28855 | 6 | |||
103953 | 194378 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6015852.13367 | 2115594.9283 | 37.7899104347693 | -122.388999044794 | (37.7899104347693, -122.388999044794) | 6 | 2 | 9 | 28855 | 6 | |||
107471 | 194374 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016126.62936 | 2115234.83636 | 37.7889369159647 | -122.388024167087 | (37.7889369159647, -122.388024167087) | 6 | 2 | 9 | 28855 | 6 | |||
111098 | 194370 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016163.96985 | 2115051.82185 | 37.788436468407 | -122.387882197423 | (37.788436468407, -122.387882197423) | 6 | 2 | 9 | 28855 | 6 | |||
113439 | 194300 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6014431.69544 | 2117339.12323 | 37.7946207500099 | -122.394035824707 | (37.7946207500099, -122.394035824707) | 12 | 2 | 10 | 28855 | 6 | |||
116516 | 27866 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.7935388882384 | -122.39231180375 | (37.7935388882384, -122.39231180375) | 12 | 2 | 9 | 28855 | 6 | ||
120757 | 194318 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 7ft | 6014918.37663 | 2116934.10067 | 37.7935356891802 | -122.392323489462 | (37.7935356891802, -122.392323489462) | 12 | 2 | 9 | 28855 | 6 | |||
123691 | 194369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6016121.08498 | 2115040.32123 | 37.7884025145026 | -122.388029770758 | (37.7884025145026, -122.388029770758) | 6 | 2 | 9 | 28855 | 6 | |||
124081 | 194314 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015030.09218 | 2116803.1524 | 37.7931823383373 | -122.391927780566 | (37.7931823383373, -122.391927780566) | 12 | 2 | 9 | 28855 | 6 | |||
125075 | 194308 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200x The Embarcadero | 2 | Median : Cutout | Tree | DPW 1 | 26 | Width 5ft | 6015341.48875 | 2116462.31194 | 37.792263751921 | -122.39082648877 | (37.792263751921, -122.39082648877) | 6 | 2 | 9 | 28855 | 6 | |||
126982 | 194383 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6015768.92359 | 2115752.81804 | 37.7903393511162 | -122.389297976729 | (37.7903393511162, -122.389297976729) | 6 | 2 | 9 | 28855 | 6 | |||
132557 | 194381 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6015827.50848 | 2115690.11268 | 37.79017042428 | -122.389090895237 | (37.79017042428, -122.389090895237) | 6 | 2 | 9 | 28855 | 6 | |||
135984 | 194317 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014996.79198 | 2116890.75749 | 37.7934210328094 | -122.392049131461 | (37.7934210328094, -122.392049131461) | 12 | 2 | 9 | 28855 | 6 | |||
139826 | 27868 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.7931911572627 | -122.39189954881 | (37.7931911572627, -122.39189954881) | 12 | 2 | 9 | 28855 | 6 | ||
143179 | 194384 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6015676.83265 | 2115781.59367 | 37.7904132565166 | -122.389618618317 | (37.7904132565166, -122.389618618317) | 6 | 2 | 9 | 28855 | 6 | |||
146729 | 194315 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015053.74343 | 2116822.79374 | 37.7932375819021 | -122.391847319118 | (37.7932375819021, -122.391847319118) | 12 | 2 | 9 | 28855 | 6 | |||
148025 | 194376 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016101.40226 | 2115318.33028 | 37.7891647735922 | -122.388117279302 | (37.7891647735922, -122.388117279302) | 6 | 2 | 9 | 28855 | 6 | |||
154415 | 194319 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.7936013558627 | -122.392257538577 | (37.7936013558627, -122.392257538577) | 12 | 2 | 9 | 28855 | 6 | |||
154419 | 194382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6015730.53426 | 2115716.10313 | 37.7902364120368 | -122.389428237241 | (37.7902364120368, -122.389428237241) | 6 | 2 | 9 | 28855 | 6 | |||
155937 | 194323 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 7ft | 6014746.37404 | 2117187.87081 | 37.7942229303951 | -122.392936399892 | (37.7942229303951, -122.392936399892) | 12 | 2 | 10 | 28855 | 6 | |||
156774 | 194303 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6014498.26565 | 2117280.42263 | 37.7944632715183 | -122.393801370556 | (37.7944632715183, -122.393801370556) | 12 | 2 | 10 | 28855 | 6 | |||
157034 | 194307 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200x The Embarcadero | 1 | Median : Cutout | Tree | DPW 1 | 25 | Width 5ft | 6015377.01126 | 2116388.0666 | 37.7920618622252 | -122.390698388434 | (37.7920618622252, -122.390698388434) | 6 | 2 | 9 | 28855 | 6 | |||
157612 | 194373 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016083.24848 | 2115225.49637 | 37.7889088670017 | -122.38817360834 | (37.7889088670017, -122.38817360834) | 6 | 2 | 9 | 28855 | 6 | |||
159054 | 27869 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.391678556907 | (37.7930087163181, -122.391678556907) | 12 | 2 | 9 | 28855 | 6 | ||
159980 | 194302 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 5ft | 6014474.29881 | 2117301.48742 | 37.7945197786065 | -122.393885774627 | (37.7945197786065, -122.393885774627) | 12 | 2 | 10 | 28855 | 6 | |||
160332 | 194298 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.7947337632981 | -122.394181185735 | (37.7947337632981, -122.394181185735) | 12 | 2 | 10 | 28855 | 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) );