trees
897 rows where qSpecies_id = 160 sorted by Location 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 124002 | 25804 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 6 | 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 | ||
| 124473 | 25803 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 5 | 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 | ||
| 135433 | 25802 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 4 | 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 | ||
| 163556 | 25800 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 2 | 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 8261 | 25749 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 2 | 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 | ||
| 63944 | 25748 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 1 | 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 | ||
| 109952 | 25752 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 5 | 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 | ||
| 136776 | 25754 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 7 | 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 | ||
| 156843 | 25750 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 102544 | 27697 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 36 | 10 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | |||
| 18521 | 25799 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | 3 | 1 | 10 | 28860 | 6 | ||
| 54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 119938 | 25746 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 151371 | 25747 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 20512 | 25787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.84401 | 37.8037556344242 | -122.401747862284 | (37.8037556344242, -122.401747862284) | 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 | |||
| 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 | |||
| 167963 | 25788 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012327.37501 | 2120629.11501 | 37.8035370964877 | -122.401548430804 | (37.8035370964877, -122.401548430804) | 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 | |||
| 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 | |||
| 156810 | 25789 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012378.15701 | 2120553.59401 | 37.8033325675946 | -122.401367385829 | (37.8033325675946, -122.401367385829) | 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 | |||
| 29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
| 39383 | 27948 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 5 | 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 | ||
| 86897 | 27949 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 6 | 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 | ||
| 113822 | 27947 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 4 | 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 | ||
| 129757 | 27951 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 8 | 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 | ||
| 137989 | 27946 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 3 | 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 | ||
| 145456 | 27950 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 7 | 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 | ||
| 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 | ||
| 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 | |||
| 131654 | 25790 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012501.85401 | 2120373.90601 | 37.8028460885889 | -122.400926692934 | (37.8028460885889, -122.400926692934) | 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 | |||
| 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 | |||
| 21850 | 143058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 426 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6010776.1378 | 2120354.2833 | 37.8026957973236 | -122.406897202115 | (37.8026957973236, -122.406897202115) | 3 | 1 | 10 | 308 | 23 | |||
| 7822 | 26018 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 2 | 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 | ||
| 35010 | 26023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 7 | 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 | ||
| 38339 | 26022 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 6 | 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 | ||
| 79273 | 26024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 8 | 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 | ||
| 91496 | 26017 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 1 | 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 | ||
| 167274 | 26019 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 157640 | 25791 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012561.75001 | 2120285.36501 | 37.802606317276 | -122.400713196915 | (37.802606317276, -122.400713196915) | 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 | |||
| 3088 | 261629 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 620x The Embarcadero | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012640 | 2120258 | 37.8025355435841 | -122.400440487668 | (37.8025355435841, -122.400440487668) | 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 | |||
| 30754 | 25792 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012611.22901 | 2120208.54201 | 37.8023981394217 | -122.400536574048 | (37.8023981394217, -122.400536574048) | 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 | |||
| 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 | |||
| 124280 | 25793 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012660.70901 | 2120133.02101 | 37.802193536328 | -122.400360040215 | (37.802193536328, -122.400360040215) | 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 | |||
| 28610 | 25736 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 1 | 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 | ||
| 47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | 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 | ||
| 58643 | 25738 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 3 | 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 | ||
| 99231 | 25742 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 7 | 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 | ||
| 99532 | 25737 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 2 | 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 | ||
| 124324 | 25741 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 6 | 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 | ||
| 133427 | 25744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 9 | 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 | ||
| 145567 | 25743 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 8 | 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 | ||
| 146265 | 27698 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | |||
| 161637 | 25739 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 4 | 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 | ||
| 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 | ||
| 18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | 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 | ||
| 25850 | 27930 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 2 | 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 | ||
| 34341 | 27931 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 3 | 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 | ||
| 86553 | 27933 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 5 | 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 | ||
| 143696 | 27932 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 4 | 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 | ||
| 164979 | 27935 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 7 | 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 152632 | 25794 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012712.79201 | 2120057.50001 | 37.8019890781012 | -122.400174499685 | (37.8019890781012, -122.400174499685) | 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 | |||
| 22525 | 25795 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012764.87501 | 2119980.67701 | 37.8017810445969 | -122.399988868692 | (37.8017810445969, -122.399988868692) | 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 |
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) );