trees
897 rows where qSpecies_id = 160 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128483 | 100535 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2050X Market St | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004529.3 | 2108103.5 | 37.7687066827543 | -122.427641088373 | (37.7687066827543, -122.427641088373) | 7 | 4 | 5 | 28862 | 3 | |||
96272 | 100536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2050X Market St | 6 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004529.3 | 2108103.5 | 37.7687066827543 | -122.427641088373 | (37.7687066827543, -122.427641088373) | 7 | 4 | 5 | 28862 | 3 | |||
23067 | 100537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
173092 | 100538 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 2 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
124663 | 100539 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 3 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
133621 | 100540 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | |||
87181 | 106114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1752X DOLORES ST | 1 | Median : Yard | Tree | DPW 1 | 6005197 | 2098194.1 | 37.7415355284645 | -122.424626562024 | (37.7415355284645, -122.424626562024) | 2 | 7 | 5 | 63 | 7 | |||||
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 | |
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 | ||||
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 | |||
184514 | 116529 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 745X SANCHEZ ST | 6 | Median : Yard | Tree | DPW 1 | 18 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
137613 | 116685 | Undocumented 4 | Phoenix canariensis :: Canary Island Date Palm 160 | 1x BIRD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005912 | 2105722 | 37.7622457626745 | -122.422689168159 | (37.7622457626745, -122.422689168159) | 8 | 4 | 5 | 28859 | 19 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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) | ||||||||||
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) | ||||||||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
41657 | 132069 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 45 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6007646.13343 | 2119391.20002 | 37.7998757746973 | -122.417660327771 | (37.7998757746973, -122.417660327771) | 5 | 1 | 1 | 28858 | 32 | ||||
73081 | 132070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 1 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 6013297.80252 | 2119184.84583 | 37.7996255806051 | -122.398088816445 | (37.7996255806051, -122.398088816445) | 3 | 1 | 10 | 28860 | 6 | |||
95027 | 132071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013261.91929 | 2119233.02284 | 37.7997558644996 | -122.398216368212 | (37.7997558644996, -122.398216368212) | 3 | 1 | 10 | 28860 | 6 | |||
109811 | 132072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013209.18431 | 2119314.66631 | 37.799977100409 | -122.398404583712 | (37.799977100409, -122.398404583712) | 3 | 1 | 10 | 28860 | 6 | |||
112625 | 132073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013155.58738 | 2119398.118 | 37.8002032529271 | -122.398595909995 | (37.8002032529271, -122.398595909995) | 3 | 1 | 10 | 28860 | 6 | |||
105728 | 132074 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.8004318615024 | -122.398798125256 | (37.8004318615024, -122.398798125256) | 3 | 1 | 10 | 28860 | 6 | |||
31803 | 132075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | 3 | 1 | 10 | 28860 | 6 | |||
134552 | 132076 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 25 | Width 10ft | 6012766.89134 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | 3 | 1 | 10 | 28860 | 6 | |||
1681 | 132077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012714.412 | 2120058.13658 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | 3 | 1 | 10 | 28860 | 6 | |||
112744 | 132078 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012663.13034 | 2120132.51785 | 37.8021922897941 | -122.400351625829 | (37.8021922897941, -122.400351625829) | 3 | 1 | 10 | 28860 | 6 | |||
184689 | 132079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.400534313224 | (37.8023972264213, -122.400534313224) | 3 | 1 | 10 | 28860 | 6 | |||
23431 | 132080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.400710234101 | (37.802598598112, -122.400710234101) | 3 | 1 | 10 | 28860 | 6 | |||
129767 | 132081 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6012501.69351 | 2120366.84811 | 37.802826700353 | -122.400926752172 | (37.802826700353, -122.400926752172) | 3 | 1 | 10 | 28860 | 6 | |||
94663 | 132082 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012375.04896 | 2120549.19866 | 37.8033203256223 | -122.40137783234 | (37.8033203256223, -122.40137783234) | 3 | 1 | 10 | 28860 | 6 | |||
84322 | 132083 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012328.94165 | 2120621.527 | 37.8035163490725 | -122.401542475719 | (37.8035163490725, -122.401542475719) | 3 | 1 | 10 | 28860 | 6 | |||
187104 | 132084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 25 | Width 10ft | 6012274.61558 | 2120706.35336 | 37.8037462301721 | -122.401736440606 | (37.8037462301721, -122.401736440606) | 3 | 1 | 10 | 28860 | 6 | |||
121346 | 132085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012153.58511 | 2120867.04559 | 37.8041806971541 | -122.402166580042 | (37.8041806971541, -122.402166580042) | 3 | 1 | 10 | 28860 | 6 | |||
120033 | 132086 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011972.21269 | 2121045.33445 | 37.8046601095467 | -122.402806783124 | (37.8046601095467, -122.402806783124) | 3 | 1 | 10 | 28860 | 6 | |||
83186 | 132087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011581.4658 | 2121414.59731 | 37.8056521894584 | -122.404185013045 | (37.8056521894584, -122.404185013045) | 3 | 1 | 10 | 28860 | 23 | |||
87732 | 132088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011509.10408 | 2121480.92062 | 37.8058302534199 | -122.404440103948 | (37.8058302534199, -122.404440103948) | 3 | 1 | 10 | 28860 | 23 | |||
145461 | 132089 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011437.6783 | 2121540.455 | 37.8059897284039 | -122.404691478852 | (37.8059897284039, -122.404691478852) | 3 | 1 | 10 | 308 | 23 | |||
75327 | 132090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011358.77785 | 2121601.92287 | 37.8061540939119 | -122.40496885854 | (37.8061540939119, -122.40496885854) | 3 | 1 | 10 | 308 | 23 | |||
48409 | 132091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.8063057411882 | -122.405269766312 | (37.8063057411882, -122.405269766312) | 3 | 1 | 10 | 308 | 23 | |||
20141 | 132092 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011191.46105 | 2121714.36376 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | 3 | 1 | 10 | 308 | 23 | |||
172264 | 132093 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.399503945567 | (37.8014252975988, -122.399503945567) | 3 | 1 | 10 | 28860 | 6 | |||
44516 | 132094 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012848.0944 | 2119927.29492 | 37.8016391096046 | -122.399697138826 | (37.8016391096046, -122.399697138826) | 3 | 1 | 10 | 28860 | 6 | |||
99322 | 132095 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.8018477010824 | -122.399873230589 | (37.8018477010824, -122.399873230589) | 3 | 1 | 10 | 28860 | 6 | |||
119144 | 132096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | 3 | 1 | 10 | 28860 | 6 | |||
57723 | 132097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012695.81427 | 2120154.08889 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | 3 | 1 | 10 | 28860 | 6 | |||
74850 | 132098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.8024427860524 | -122.400415783487 | (37.8024427860524, -122.400415783487) | 3 | 1 | 10 | 28860 | 6 | |||
105718 | 132099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.400608161041 | (37.8026555899447, -122.400608161041) | 3 | 1 | 10 | 28860 | 6 | |||
40485 | 132100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 15 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.8028208098055 | -122.400753698321 | (37.8028208098055, -122.400753698321) | 3 | 1 | 10 | 28860 | 6 | |||
69730 | 132101 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 17 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | 3 | 1 | 10 | 28860 | 6 | |||
45636 | 132102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6012409.88323 | 2120572.11734 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | 3 | 1 | 10 | 28860 | 6 | |||
4871 | 132103 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | 3 | 1 | 10 | 28860 | 6 | |||
179721 | 132104 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | 3 | 1 | 10 | 28860 | 6 | |||
159594 | 132105 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6012001.46692 | 2121074.30881 | 37.8047412994387 | -122.402707584299 | (37.8047412994387, -122.402707584299) | 3 | 1 | 10 | 28860 | 6 | |||
166083 | 132106 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.403863521591 | (37.8055435810345, -122.403863521591) | 3 | 1 | 10 | 28860 | 23 | |||
175303 | 132107 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011604.73213 | 2121437.14607 | 37.8057154028122 | -122.404106084029 | (37.8057154028122, -122.404106084029) | 3 | 1 | 10 | 28860 | 23 | |||
187099 | 132108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011532.66827 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | 3 | 1 | 10 | 28860 | 23 | |||
52151 | 132109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.404617975463 | (37.8060696196846, -122.404617975463) | 3 | 1 | 10 | 308 | 23 | |||
168330 | 132110 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | 3 | 1 | 10 | 308 | 23 | |||
130505 | 132111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011290.22315 | 2121683.26622 | 37.8063736103221 | -122.40521183647 | (37.8063736103221, -122.40521183647) | 3 | 1 | 10 | 308 | 23 | |||
91316 | 132112 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011208.19344 | 2121737.88602 | 37.8065189965151 | -122.405499565575 | (37.8065189965151, -122.405499565575) | 3 | 1 | 10 | 308 | 23 | |||
1977 | 132113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.397977001937 | (37.7996825238869, -122.397977001937) | 3 | 1 | 10 | 28860 | 6 | |||
85425 | 132114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.7998185274531 | -122.39809024008 | (37.7998185274531, -122.39809024008) | 3 | 1 | 10 | 28860 | 6 | |||
132004 | 132115 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013243.85901 | 2119336.70039 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | 3 | 1 | 10 | 28860 | 6 | |||
78947 | 132116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.8002685895792 | -122.398479778719 | (37.8002685895792, -122.398479778719) | 3 | 1 | 10 | 28860 | 6 | |||
124776 | 132117 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6013132.77632 | 2119506.77553 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | 3 | 1 | 10 | 28860 | 6 | |||
153930 | 132118 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6014172.89911 | 2117759.32578 | 37.7957601406829 | -122.394960745056 | (37.7957601406829, -122.394960745056) | 4 | 2 | 10 | 28860 | 6 | |||
192630 | 132119 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014187.59198 | 2117732.03905 | 37.795686034729 | -122.394907992625 | (37.795686034729, -122.394907992625) | 4 | 2 | 10 | 28860 | 6 | |||
65491 | 132120 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 6014198.1938 | 2117703.48543 | 37.795608222696 | -122.394869307388 | (37.795608222696, -122.394869307388) | 4 | 2 | 10 | 28860 | 6 | |||
154796 | 132121 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945032 | (37.7955313378499, -122.39482945032) | 4 | 2 | 10 | 28860 | 6 | |||
121091 | 132122 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.394791937806 | (37.7954646414426, -122.394791937806) | 4 | 2 | 10 | 28860 | 6 | |||
87673 | 132123 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.7953979459112 | -122.394743875326 | (37.7953979459112, -122.394743875326) | 4 | 2 | 10 | 28860 | 6 | |||
165133 | 132124 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014245.1809 | 2117597.95018 | 37.7953210601821 | -122.394699328313 | (37.7953210601821, -122.394699328313) | 4 | 2 | 10 | 28860 | 6 | |||
113444 | 132125 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014258.52591 | 2117571.02815 | 37.79524788055 | -122.394651265852 | (37.79524788055, -122.394651265852) | 4 | 2 | 10 | 28860 | 6 | |||
193499 | 132126 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | 4 | 2 | 10 | 28860 | 6 | |||
58327 | 132127 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.7951191201157 | -122.394552795494 | (37.7951191201157, -122.394552795494) | 4 | 2 | 10 | 28860 | 6 | |||
177761 | 132128 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014303.11413 | 2117497.5911 | 37.7950487184753 | -122.394491837643 | (37.7950487184753, -122.394491837643) | 4 | 2 | 10 | 28860 | 6 | |||
9507 | 132129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013671.61354 | 2118630.60451 | 37.7981245788406 | -122.3967564088 | (37.7981245788406, -122.3967564088) | 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) );