trees
897 rows where qSpecies_id = 160 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193608 | 187520 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Lauren Ct | 1 | : | Tree | Private 2 | 24 | Width 5ft | 6012373.80363 | 2088075.52954 | 37.7141547210285 | -122.399101386534 | (37.7141547210285, -122.399101386534) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | |||
| 193297 | 194313 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | 12 | 2 | 9 | 28855 | 6 | |||
| 193134 | 194316 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 7ft | 6014969.23068 | 2116866.26037 | 37.7933522391693 | -122.392142782374 | (37.7933522391693, -122.392142782374) | 12 | 2 | 9 | 28855 | 6 | |||
| 193128 | 27787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 192759 | 5446 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 14 | Median : Cutout | Tree | DPW 1 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 192277 | 18551 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014649.71614 | 2095074.32399 | 37.7334985860723 | -122.391723949223 | (37.7334985860723, -122.391723949223) | 10 | 3 | 8 | 58 | 1 | |||
| 191559 | 28028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | 4 | 2 | 10 | 28860 | 6 | ||
| 191216 | 234383 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3483 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005156.87556 | 2103096.10876 | 37.7549930502992 | -122.425114011399 | (37.7549930502992, -122.425114011399) | 2 | 4 | 5 | 28859 | 19 | |||
| 190771 | 26025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | ||
| 190651 | 234375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.7602382499206 | -122.425809806971 | (37.7602382499206, -122.425809806971) | 2 | 4 | 5 | 28859 | 19 | |||
| 190485 | 25067 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | 2 | 4 | 5 | 28862 | 22 | |||
| 190203 | 25753 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
| 189449 | 26020 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | |||
| 189286 | 26027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | ||
| 189165 | 25631 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.62162 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | 3 | 2 | 10 | 28860 | 6 | ||
| 188941 | 26021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | |||
| 188360 | 18535 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6006489 | 2098160 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | 2 | 7 | 7 | 28859 | 2 | |||
| 187923 | 96827 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 187664 | 28029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.74201 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | 4 | 2 | 10 | 28860 | 6 | ||
| 187379 | 1443 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 151X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | |||
| 187277 | 25150 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 6004790.11345 | 2107911.6189 | 37.7681945727608 | -122.426725288037 | (37.7681945727608, -122.426725288037) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | |||
| 186891 | 25083 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005162.35719 | 2101213.31575 | 37.7498236473552 | -122.424961105075 | (37.7498236473552, -122.424961105075) | 2 | 4 | 5 | 28859 | 22 | |||
| 186642 | 234353 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004972.99997 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | 2 | 4 | 5 | 28862 | 3 | ||||
| 186350 | 25740 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 186217 | 246356 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2100x Market St | 3 | Median : Cutout | Tree | DPW 1 | 32 | Width 0ft | 6003986.7122 | 2107511.3108 | 37.7670499684983 | -122.429475620431 | (37.7670499684983, -122.429475620431) | 8 | 4 | 5 | 28862 | 3 | |||
| 185888 | 27962 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
| 185850 | 25106 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005241.17775 | 2099713.87888 | 37.7457109900772 | -122.424581892451 | (37.7457109900772, -122.424581892451) | 2 | 7 | 5 | 63 | 22 | |||
| 185625 | 132133 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 27 | Width 10ft | 6013516.34459 | 2118862.0699 | 37.7987514845508 | -122.39730992891 | (37.7987514845508, -122.39730992891) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 185249 | 87850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.451634593656 | (37.7437272652603, -122.451634593656) | 9 | 7 | 4 | 59 | 40 | |||
| 185236 | 28221 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 185165 | 24961 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.7677089127708 | -122.42667516164 | (37.7677089127708, -122.42667516164) | 8 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 184625 | 25539 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003230.8711 | 2106796.1855 | 37.7650435846647 | -122.432038884515 | (37.7650435846647, -122.432038884515) | 15 | 4 | 5 | 28862 | 3 | ||
| 184623 | 210928 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | 5997342.33131 | 2095240.63361 | 37.7329792905421 | -122.451572201795 | (37.7329792905421, -122.451572201795) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | ||||
| 184237 | 210926 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 39 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 10ft | 5999833.49072 | 2095475.12852 | 37.7337655048678 | -122.44297647541 | (37.7337655048678, -122.44297647541) | 9 | 7 | 4 | 63 | 40 | |||
| 183865 | 26537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 06/23/1997 12:00:00 AM | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 183670 | 24972 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 13 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 183652 | 25801 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |||
| 183434 | 25064 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005102.42257 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | 2 | 4 | 5 | 28862 | 22 | |||
| 183143 | 27786 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 182274 | 246404 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2000x Market St | 3 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6004606.9445 | 2108108.5245 | 37.7687248704296 | -122.427372879895 | (37.7687248704296, -122.427372879895) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 181577 | 27774 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 181531 | 25530 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002661.3855 | 2106250.4058 | 37.7635127037236 | -122.433969576289 | (37.7635127037236, -122.433969576289) | 15 | 4 | 5 | 28862 | 3 | ||
| 181317 | 25515 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2100X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004020.8124 | 2107556.2611 | 37.767175321793 | -122.429360878869 | (37.767175321793, -122.429360878869) | 7 | 4 | 5 | 28862 | 3 | ||
| 181062 | 25537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003301.0095 | 2106860.3121 | 37.7652236369165 | -122.431800872336 | (37.7652236369165, -122.431800872336) | 15 | 4 | 5 | 28862 | 3 | ||
| 180593 | 25037 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | 2 | 4 | 5 | 28862 | 22 | |||
| 180464 | 27938 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013758.52527 | 2118508.28044 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | 3 | 1 | 10 | 28860 | 6 | |||
| 180397 | 27480 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 70 | 20 | 6004900.72353 | 2105815.65161 | 37.7624458004571 | -122.426193461385 | (37.7624458004571, -122.426193461385) | 8 | 4 | 5 | 28859 | 3 | ||
| 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 | |||
| 179504 | 25535 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.7653921725618 | -122.431593762963 | (37.7653921725618, -122.431593762963) | 15 | 4 | 5 | 28862 | 3 | ||
| 179404 | 25118 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005257.61936 | 2099436.85892 | 37.7449512850908 | -122.42450533857 | (37.7449512850908, -122.42450533857) | 2 | 7 | 5 | 63 | 22 | |||
| 179338 | 25632 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 179105 | 234351 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 30 | 6004966.99113 | 2104720.19059 | 37.7594416691168 | -122.425886285347 | (37.7594416691168, -122.425886285347) | 2 | 4 | 5 | 28862 | 3 | ||||
| 178894 | 194358 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016102.75205 | 2114084.3299 | 37.7857765633769 | -122.388026462162 | (37.7857765633769, -122.388026462162) | 6 | 2 | 9 | 28856 | 6 | |||
| 178812 | 194343 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016001.63432 | 2112937.23784 | 37.7826213045779 | -122.388296216498 | (37.7826213045779, -122.388296216498) | 6 | 2 | 9 | 28856 | 6 | |||
| 178595 | 194322 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014773.34204 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | 12 | 2 | 10 | 28855 | 6 | |||
| 178405 | 27783 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
| 178077 | 25680 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 177506 | 25072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005130.36391 | 2101800.25652 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | 2 | 4 | 5 | 28862 | 22 | |||
| 177197 | 27945 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 176945 | 234357 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 24 | 6004986.09692 | 2104380.36291 | 37.7585096621012 | -122.425796019476 | (37.7585096621012, -122.425796019476) | 2 | 4 | 5 | 28862 | 3 | ||||
| 176871 | 234401 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3899 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 3ft | 6003740.05582 | 2104771.47672 | 37.75951307439 | -122.430133288745 | (37.75951307439, -122.430133288745) | 2 | 4 | 5 | 28862 | 3 | |||
| 176830 | 233927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 389 Webster St | 3 | : | Tree | Private 2 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | 7 | 9 | 11 | 29492 | 10 | |||
| 176702 | 234343 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 7ft | 6005056.06627 | 2103868.04272 | 37.7571069049763 | -122.425517573176 | (37.7571069049763, -122.425517573176) | 2 | 4 | 5 | 28859 | 19 | |||
| 176605 | 27779 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
| 175834 | 194342 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6016043.56926 | 2112825.74631 | 37.7823174973895 | -122.38814335515 | (37.7823174973895, -122.38814335515) | 6 | 2 | 9 | 28856 | 6 | |||
| 175806 | 233932 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 24 | 6004814.58298 | 2107439.68856 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | 8 | 4 | 5 | 28862 | 3 | ||||
| 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 | |||
| 175022 | 234373 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 9ft | 6004999.25531 | 2105001.64416 | 37.7602162974746 | -122.425794733444 | (37.7602162974746, -122.425794733444) | 2 | 4 | 5 | 28859 | 19 | |||
| 174797 | 234396 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1351 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 6ft | 6001401.68154 | 2099734.75899 | 37.7455507389883 | -122.437859774517 | (37.7455507389883, -122.437859774517) | 2 | 4 | 5 | 63 | 22 | |||
| 174699 | 194367 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 6016138.88729 | 2114959.31506 | 37.7881810762396 | -122.38796252217 | (37.7881810762396, -122.38796252217) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 173942 | 194353 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6016057.99648 | 2113605.13958 | 37.7844583353237 | -122.388147851742 | (37.7844583353237, -122.388147851742) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 172743 | 194275 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 01st St | 34 | : Yard | Tree | Private 2 | 8 | 6014376.65997 | 2105881.88915 | 37.76315871732 | -122.393424068061 | (37.76315871732, -122.393424068061) | 14 | 3 | 8 | 28856 | 29 | ||||
| 172631 | 27853 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.7804039822192 | -122.389031454309 | (37.7804039822192, -122.389031454309) | 6 | 2 | 9 | 28856 | 20 | ||
| 172546 | 25784 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013869.26975 | 2118339.24702 | 37.797335579338 | -122.396052026484 | (37.797335579338, -122.396052026484) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | |||
| 172222 | 25751 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
| 172163 | 25520 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2194X Market St | 7 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798 | 2107172.9273566 | 37.7660974938136 | -122.430877759148 | (37.7660974938136, -122.430877759148) | 7 | 4 | 5 | 28862 | 3 | ||
| 172032 | 25111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005242.59316 | 2099769.24096 | 37.7458630816199 | -122.424580935573 | (37.7458630816199, -122.424580935573) | 2 | 7 | 5 | 63 | 22 | |||
| 171928 | 25536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003342.0906 | 2106904.3991 | 37.7653470177984 | -122.431661930586 | (37.7653470177984, -122.431661930586) | 15 | 4 | 5 | 28862 | 3 | ||
| 171833 | 27851 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.53901 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | 6 | 2 | 9 | 28856 | 20 | ||
| 171707 | 27934 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
| 171175 | 25645 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 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) );