trees
897 rows where qSpecies_id = 160 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
1611 | 247638 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.409751390215 | (37.7373232876386, -122.409751390215) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | |||
4245 | 28231 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 14 | 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 | ||||
4408 | 234354 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6004979.81363 | 2104508.34972 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | 2 | 4 | 5 | 28862 | 3 | ||||
4436 | 194278 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750 22nd St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6012817.61072 | 2103799.38432 | 37.7573538722899 | -122.398670182286 | (37.7573538722899, -122.398670182286) | 10 | 3 | 8 | 28856 | 29 | ||||
9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
11271 | 194293 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 46 | Median : Yard | Tree | DPW 1 | 28 | 6014318.79649 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | 10 | 3 | 8 | 58 | 1 | ||||
12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
13313 | 251111 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 7 | Median : Yard | Tree | DPW 1 | |||||||||||||||
13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
14024 | 194292 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 43 | Median : Yard | Tree | DPW 1 | 38 | 6014354.24031 | 2095291.86255 | 37.7340794959614 | -122.392760714642 | (37.7340794959614, -122.392760714642) | 10 | 3 | 8 | 58 | 1 | ||||
14999 | 233935 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150x Dolores St | 9 | Median : Yard | Tree | DPW 1 | 30 | 6004826.52958 | 2107279.95522 | 37.7664622347806 | -122.426554344032 | (37.7664622347806, -122.426554344032) | 8 | 4 | 5 | 28862 | 3 | ||||
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 | |||||
15958 | 251109 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Yard | Tree | DPW 1 | |||||||||||||||
15995 | 251116 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | |||||||||||||||
19170 | 251114 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 16 | Median : Yard | Tree | DPW 1 | |||||||||||||||
19478 | 251110 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 5 | Median : Yard | Tree | DPW 1 | |||||||||||||||
20723 | 28232 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 15 | 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 | ||||
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 | |||
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 | ||||
21737 | 233937 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 230x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.426470450778 | (37.7655506342911, -122.426470450778) | 8 | 4 | 5 | 28862 | 3 | ||||
21756 | 28219 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 2 | 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 | ||||
22076 | 234356 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 22 | 6004985.93046 | 2104422.99085 | 37.7586266989802 | -122.425799629353 | (37.7586266989802, -122.425799629353) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | |||
25166 | 194288 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 37 | Median : Yard | Tree | DPW 1 | 34 | 6014411.93404 | 2095259.01392 | 37.7339925045513 | -122.392558950849 | (37.7339925045513, -122.392558950849) | 10 | 3 | 8 | 58 | 1 | ||||
25303 | 194388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | 6013107.94825 | 2089911.65871 | 37.7192372512804 | -122.396692522765 | (37.7192372512804, -122.396692522765) | 10 | 3 | 8 | 58 | 1 | ||||
27019 | 51202 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.7600495413778 | -122.43037732339 | (37.7600495413778, -122.43037732339) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | |||
29806 | 234362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||||
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) | ||||||||||
34128 | 194284 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | 31 | 6014504.15008 | 2095180.20764 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | 10 | 3 | 8 | 58 | 1 | ||||
35012 | 118600 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 249 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 37 | 5981958.17368 | 2112601.6345 | 37.7797546732687 | -122.506045091658 | (37.7797546732687, -122.506045091658) | 11 | 6 | 2 | 55 | 26 | ||||
35031 | 194386 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||||
38161 | 28233 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 16 | 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 | ||||
38835 | 96683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 28 | Permit Number 768040 | 5985881.45738 | 2113426.06761 | 37.7822484912616 | -122.492533661722 | (37.7822484912616, -122.492533661722) | 11 | 6 | 2 | 55 | 26 | ||
38982 | 60467 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883 | 2089135 | 37.7161883486769 | -122.452719710267 | (37.7161883486769, -122.452719710267) | 9 | 8 | 6 | 28861 | 24 | |||
39261 | 234359 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x Dolores St | 13 | Median : Yard | Tree | DPW 1 | 31 | 6005116.63925 | 2102018.48994 | 37.7520318867687 | -122.425176485533 | (37.7520318867687, -122.425176485533) | 2 | 4 | 5 | 28862 | 22 | ||||
39492 | 27959 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 3 | 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 | |||
41657 | 132069 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 45 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6007646.13343 | 2119391.20002 | 37.7998757746973 | -122.417660327771 | (37.7998757746973, -122.417660327771) | 5 | 1 | 1 | 28858 | 32 | ||||
42942 | 28236 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 19 | 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 | ||||
44000 | 233940 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 270x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6004851.53435 | 2106800.76384 | 37.7651479034782 | -122.426433734123 | (37.7651479034782, -122.426433734123) | 8 | 4 | 5 | 28862 | 3 | ||||
45318 | 194287 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 32 | Median : Yard | Tree | DPW 1 | 31 | 6014435.32238 | 2095233.37666 | 37.7339234087228 | -122.392476296866 | (37.7339234087228, -122.392476296866) | 10 | 3 | 8 | 58 | 1 | ||||
46369 | 28229 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 12 | 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 | ||||
46829 | 96681 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985880.88078 | 2113443.18167 | 37.7822954478301 | -122.492536917233 | (37.7822954478301, -122.492536917233) | 11 | 6 | 2 | 55 | 26 | ||
49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
50694 | 28220 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 3 | 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 | ||||
51299 | 233936 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 230x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.426479630127 | (37.7656304545194, -122.426479630127) | 8 | 4 | 5 | 28862 | 3 | ||||
52333 | 234371 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | 2 | 7 | 5 | 63 | 7 | ||||
52419 | 234367 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | 2 | 7 | 5 | 63 | 22 | ||||
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 | |||||
53552 | 28226 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 9 | 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 | ||||
54034 | 210911 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | 9 | 7 | 4 | 59 | 40 | ||||
54159 | 27775 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
55277 | 194276 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2347 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | 6010780.52383 | 2105047.83738 | 37.7606681393399 | -122.405803207256 | (37.7606681393399, -122.405803207256) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||||
57058 | 194389 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | 10 | 3 | 8 | 58 | 1 | ||||
59030 | 27777 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
62567 | 194289 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 38 | Median : Yard | Tree | DPW 1 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.392613948889 | (37.734007417094, -122.392613948889) | 10 | 3 | 8 | 58 | 1 | ||||
65015 | 194291 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 41 | Median : Yard | Tree | DPW 1 | 38 | 6014364.32912 | 2095287.31351 | 37.7340675655682 | -122.392725516077 | (37.7340675655682, -122.392725516077) | 10 | 3 | 8 | 58 | 1 | ||||
66677 | 28227 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 10 | 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 | ||||
66787 | 194390 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6013152.66051 | 2089880.87187 | 37.7191552052161 | -122.396535811395 | (37.7191552052161, -122.396535811395) | 10 | 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 | ||||
71485 | 27847 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
73230 | 96694 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 3132@32nd Ave Clement St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
73854 | 194294 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 49 | Median : Yard | Tree | DPW 1 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | 10 | 3 | 8 | 58 | 1 | ||||
76035 | 233929 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8 Octavia St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6005769.81739 | 2109368.12443 | 37.7722491293339 | -122.423440144659 | (37.7722491293339, -122.423440144659) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
80221 | 27782 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 5 | 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 | |||
83051 | 234345 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 34 | 6005211.50018 | 2100294.54181 | 37.7473036813364 | -122.424725813644 | (37.7473036813364, -122.424725813644) | 2 | 7 | 5 | 63 | 22 | ||||
83322 | 233939 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 270x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 32 | 6004850.2917 | 2106826.33652 | 37.7652180496996 | -122.426439853137 | (37.7652180496996, -122.426439853137) | 8 | 4 | 5 | 28862 | 3 | ||||
83784 | 234360 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||||
86217 | 27942 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 3 | 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 | |||
86782 | 210912 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 5997433.76219 | 2094954.34243 | 37.7321984389023 | -122.451235463255 | (37.7321984389023, -122.451235463255) | 9 | 7 | 4 | 59 | 40 | ||||
87181 | 106114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1752X DOLORES ST | 1 | Median : Yard | Tree | DPW 1 | 6005197 | 2098194.1 | 37.7415355284645 | -122.424626562024 | (37.7415355284645, -122.424626562024) | 2 | 7 | 5 | 63 | 7 | |||||
88106 | 27780 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 3 | 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 | |||
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 | |||||
89061 | 234369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.424122818219 | (37.7411720001789, -122.424122818219) | 2 | 7 | 5 | 63 | 7 | ||||
90541 | 28237 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 20 | 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 | ||||
90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
92097 | 27960 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 4 | 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 | |||
92196 | 233934 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150x Dolores St | 7 | Median : Yard | Tree | DPW 1 | 34 | 6004824.15396 | 2107326.99928 | 37.7665912721916 | -122.426565911081 | (37.7665912721916, -122.426565911081) | 8 | 4 | 5 | 28862 | 3 | ||||
94064 | 27767 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 1 | 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 | |||
94606 | 194290 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 40 | Median : Yard | Tree | DPW 1 | 27 | 6014381.30223 | 2095272.57767 | 37.7340280466394 | -122.392665803801 | (37.7340280466394, -122.392665803801) | 10 | 3 | 8 | 58 | 1 | ||||
96263 | 233933 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 35 | 6004817.19467 | 2107404.11108 | 37.76680260927 | -122.426595473608 | (37.76680260927, -122.426595473608) | 8 | 4 | 5 | 28862 | 3 | ||||
97339 | 27843 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
97718 | 27717 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
98562 | 234368 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | 2 | 7 | 5 | 63 | 7 | ||||
99109 | 194297 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2198 Revere Ave | 1 | Side Yard : Yard | Tree | Private 2 | 31 | 6011968.87844 | 2096761.78456 | 37.7379828180593 | -122.401110955803 | (37.7379828180593, -122.401110955803) | 10 | 3 | 8 | 58 | 1 | ||||
100652 | 234346 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350x Dolores St | 7 | Median : Yard | Tree | DPW 1 | 33 | 6005214.83803 | 2100265.33674 | 37.7472236794354 | -122.424712194312 | (37.7472236794354, -122.424712194312) | 2 | 7 | 5 | 63 | 22 | ||||
101136 | 27845 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
101265 | 27778 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
102382 | 194387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6013093.20116 | 2089924.29981 | 37.7192711404238 | -122.396744383961 | (37.7192711404238, -122.396744383961) | 10 | 3 | 8 | 58 | 1 | ||||
103103 | 234347 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | 2 | 4 | 5 | 28862 | 3 | ||||
103607 | 234348 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6004955.10734 | 2105017.76202 | 37.7602580583932 | -122.425948567888 | (37.7602580583932, -122.425948567888) | 2 | 4 | 5 | 28862 | 3 | ||||
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 |
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) );