trees
897 rows where qSpecies_id = 160 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 | |||
73469 | 234377 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 Harrison St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6008587.9096 | 2108086.3181 | 37.768888242332 | -122.413601406792 | (37.768888242332, -122.413601406792) | 8 | 4 | 7 | 28853 | 19 | |||
119946 | 234398 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3980 22nd St | 8 | : | Tree | Private 2 | 32 | 6001905.07347 | 2102956.38941 | 37.7544251823875 | -122.436349651817 | (37.7544251823875, -122.436349651817) | 2 | 4 | 5 | 28862 | 22 | ||||
120873 | 234376 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 Harrison St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.413603886225 | (37.7689633348285, -122.413603886225) | 8 | 4 | 7 | 28853 | 19 | |||
167872 | 194272 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1022 Minna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007547.68753 | 2109714.25342 | 37.7732997020571 | -122.417314852308 | (37.7732997020571, -122.417314852308) | 8 | 2 | 9 | 28853 | 19 | |||
170937 | 194325 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88 King St | 1 | : | Tree | Private 2 | 31 | Width 8ft | 6015700.56916 | 2111985.57661 | 37.7799915700032 | -122.389271307346 | (37.7799915700032, -122.389271307346) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |||
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 | |||
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 | ||||
1493 | 264741 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 2 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
15348 | 264739 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
68051 | 255454 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000622 | 2094989 | 37.7324756340381 | -122.440215522188 | (37.7324756340381, -122.440215522188) | 9 | 7 | 5 | 63 | 40 | ||||
20896 | 187504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | 9 | 7 | 6 | 309 | 5 | ||||
31169 | 201683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 19 | Front Yard : Yard | Tree | Private 2 | 23 | 6010259.33764 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | 14 | 2 | 9 | 28853 | 34 | ||||
35049 | 194282 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 6 | Front Yard : Yard | Tree | Private 2 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | 3 | 8 | 58 | 1 | |||||
44354 | 194295 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1942 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | 10 | 3 | 8 | 58 | 1 | |||
53310 | 194279 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 21 | Front Yard : Yard | Tree | Private 2 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | 3 | 8 | 58 | 1 | |||||
67451 | 201687 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | 14 | 2 | 9 | 28853 | 34 | ||||
76464 | 187499 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854948 | (37.7093979531098, -122.42400854948) | 9 | 7 | 6 | 309 | 5 | ||||
84522 | 234381 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Eugenia Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.419926400796 | (37.74136892295, -122.419926400796) | 2 | 7 | 7 | 28859 | 2 | ||||
88702 | 194283 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6016255.79944 | 2100318.37917 | 37.7479867182066 | -122.386536741486 | (37.7479867182066, -122.386536741486) | 3 | 8 | 58 | 1 | |||||
103678 | 201682 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 18 | Front Yard : Yard | Tree | Private 2 | 25 | 6010248.09063 | 2109749.24504 | 37.7735473393687 | -122.407976213039 | (37.7735473393687, -122.407976213039) | 14 | 2 | 9 | 28853 | 34 | ||||
115708 | 194280 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 18 | Front Yard : Yard | Tree | Private 2 | 3 | 6016126.44291 | 2100241.55687 | 37.7477686182436 | -122.386978698012 | (37.7477686182436, -122.386978698012) | 3 | 8 | 58 | 1 | |||||
119218 | 194281 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 11 | Front Yard : Yard | Tree | Private 2 | 38 | 6016211.24922 | 2100302.52143 | 37.7479407097974 | -122.386689690076 | (37.7479407097974, -122.386689690076) | 3 | 8 | 58 | 1 | |||||
123803 | 201684 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 20 | Front Yard : Yard | Tree | Private 2 | 30 | 6010233.57215 | 2109769.89905 | 37.773603237626 | -122.408027891695 | (37.773603237626, -122.408027891695) | 14 | 2 | 9 | 28853 | 34 | ||||
138819 | 187495 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6005184.36761 | 2086469.76682 | 37.7093423678344 | -122.423836763664 | (37.7093423678344, -122.423836763664) | 9 | 7 | 6 | 309 | 5 | ||||
161340 | 187497 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.423952396694 | (37.7093649785846, -122.423952396694) | 9 | 7 | 6 | 309 | 5 | ||||
12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
1012 | 24992 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004882.50848 | 2106257.62148 | 37.7636583150142 | -122.426287928865 | (37.7636583150142, -122.426287928865) | 8 | 4 | 5 | 28859 | 3 | |||
1174 | 259410 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 7 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
2509 | 27941 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
2957 | 25027 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
3522 | 25785 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
3537 | 18548 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014665.0129 | 2095058.69239 | 37.7334565140045 | -122.391669970993 | (37.7334565140045, -122.391669970993) | 10 | 3 | 8 | 58 | 1 | |||
5116 | 25071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005127.37654 | 2101840.69033 | 37.7515442968352 | -122.42512670443 | (37.7515442968352, -122.42512670443) | 2 | 4 | 5 | 28862 | 22 | |||
6713 | 25016 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
7075 | 25030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
7222 | 25538 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | 15 | 4 | 5 | 28862 | 3 | ||
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 | ||
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 | ||
8378 | 25503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.425481812147 | (37.7702480498919, -122.425481812147) | 7 | 2 | 5 | 28853 | 19 | ||
8561 | 25119 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959639 | (37.7448725899054, -122.42449959639) | 2 | 7 | 5 | 63 | 22 | |||
9423 | 25058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594342 | -122.425291287561 | (37.753237594342, -122.425291287561) | 2 | 4 | 5 | 28862 | 22 | |||
9494 | 259411 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
9943 | 25035 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
12278 | 259406 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 3 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
12845 | 259408 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 5 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
12943 | 246349 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2190x Market St | 1 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.7663626060268 | -122.430369556243 | (37.7663626060268, -122.430369556243) | 8 | 4 | 5 | 28862 | 3 | |||
15633 | 25139 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.7417043484808 | -122.424181770586 | (37.7417043484808, -122.424181770586) | 2 | 7 | 5 | 63 | 7 | |||
16199 | 259409 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 6 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
16574 | 25108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005223.67149 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | 2 | 7 | 5 | 63 | 22 | |||
17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
17335 | 24980 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
17465 | 246342 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020x Market St | 4 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004356.6072 | 2107872.2367 | 37.7680619198287 | -122.428221935713 | (37.7680619198287, -122.428221935713) | 8 | 4 | 5 | 28862 | 3 | |||
18007 | 259314 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 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 | ||
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 | ||
18870 | 259407 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
18928 | 25136 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.7419479631307 | -122.424208394127 | (37.7419479631307, -122.424208394127) | 2 | 7 | 5 | 63 | 7 | |||
18950 | 25113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | 2 | 7 | 5 | 63 | 22 | |||
19729 | 25157 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.426760449752 | (37.7685272607631, -122.426760449752) | 8 | 4 | 5 | 28862 | 3 | |||
19829 | 23674 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 319 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
20670 | 24996 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004898.74738 | 2105973.30508 | 37.7628785677218 | -122.42621152066 | (37.7628785677218, -122.42621152066) | 8 | 4 | 5 | 28859 | 3 | |||
20840 | 27943 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
21370 | 25043 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
21739 | 25033 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004995.41159 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | 2 | 4 | 5 | 28862 | 3 | |||
22145 | 25523 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2194X Market St | 10 | 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 | ||
22376 | 194392 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 5 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6014755.05221 | 2089115.57759 | 37.7171429037943 | -122.390943451878 | (37.7171429037943, -122.390943451878) | 10 | 3 | 8 | 58 | 1 | |||
22504 | 96822 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
22781 | 26096 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | 3 | 1 | 10 | 28860 | 6 | ||
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 | |||
23344 | 194391 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 828x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014866.8225 | 2088973.55401 | 37.7167591360948 | -122.390547193499 | (37.7167591360948, -122.390547193499) | 10 | 3 | 8 | 58 | 1 | |||
23418 | 248619 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1801x Market St | 1 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.423438937501 | (37.7715594473913, -122.423438937501) | 8 | 2 | 5 | 28853 | 19 | |||
23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | 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 | |||
23966 | 25090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | 2 | 4 | 5 | 28859 | 22 | |||
24155 | 26028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 4 | 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 | ||
24974 | 25527 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | 15 | 4 | 5 | 28862 | 3 | ||
25206 | 25733 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
25464 | 18556 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 11 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | 10 | 3 | 8 | 58 | 1 | |||
25582 | 25084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.424951961675 | (37.7497200220711, -122.424951961675) | 2 | 4 | 5 | 28859 | 22 | |||
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 | ||
26524 | 25516 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2190X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | 8 | 4 | 5 | 28862 | 3 | ||
27682 | 27481 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | 2 | 4 | 5 | 28862 | 22 | ||
27783 | 25501 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.7703500248187 | -122.425355725564 | (37.7703500248187, -122.425355725564) | 7 | 2 | 5 | 28853 | 19 | ||
28000 | 27867 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | 12 | 2 | 9 | 28855 | 6 | ||
28206 | 28025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.7960727946079 | -122.394977873693 | (37.7960727946079, -122.394977873693) | 3 | 2 | 10 | 28860 | 6 | ||
28540 | 25054 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.425381222462 | (37.7542196827988, -122.425381222462) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
28642 | 27958 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 2 | 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 | |||
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 | |||
30456 | 96824 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
30604 | 246402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2000x Market St | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004659.311 | 2108158.3365 | 37.7688646036969 | -122.427195296669 | (37.7688646036969, -122.427195296669) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||
32091 | 24337 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020X Market St | 2 | Median : Cutout | Tree | DPW 1 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | 8 | 4 | 5 | 28862 | 3 | ||
32583 | 25100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6005208.52852 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | 2 | 7 | 5 | 63 | 22 | |||
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) | ||||||||||
32855 | 25683 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481 | -122.388411289639 | (37.781564418481, -122.388411289639) | 6 | 2 | 9 | 28856 | 20 |
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) );