trees
897 rows where qSpecies_id = 160 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
| 28718 | 194364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.7873602722118 | -122.387727152497 | (37.7873602722118, -122.387727152497) | 6 | 2 | 9 | 28855 | 6 | |||
| 28783 | 234372 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.7487174209867 | -122.424406263843 | (37.7487174209867, -122.424406263843) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 29479 | 194301 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014450.94814 | 2117319.50323 | 37.7945679480926 | -122.393967833244 | (37.7945679480926, -122.393967833244) | 12 | 2 | 10 | 28855 | 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 | ||||
| 30086 | 14174 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
| 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 | |||
| 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 | ||||
| 31694 | 234402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002514.48058 | 2108813.73054 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | 15 | 5 | 5 | 29492 | 9 | |||
| 31803 | 132075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 32602 | 120819 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587102 | (37.7856385654779, -122.47984587102) | 11 | 6 | 2 | 55 | 26 | |||
| 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) | ||||||||||
| 33204 | 234387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005043.99676 | 2102621.60144 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | 2 | 4 | 5 | 28862 | 22 | |||
| 33867 | 25096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005188.03023 | 2100718.94336 | 37.7484676648463 | -122.42483715961 | (37.7484676648463, -122.42483715961) | 2 | 4 | 5 | 28859 | 19 | |||
| 33986 | 24963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004800.73696 | 2107633.50365 | 37.7674315357679 | -122.42666873509 | (37.7674315357679, -122.42666873509) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||||
| 35397 | 194379 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | 6 | 2 | 9 | 28855 | 6 | |||
| 35617 | 5707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005241.86416 | 2098983.9941 | 37.7437069318227 | -122.424527610259 | (37.7437069318227, -122.424527610259) | 2 | 7 | 5 | 63 | 22 | |||
| 36361 | 25026 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.425675315185 | (37.7572811108424, -122.425675315185) | 2 | 4 | 5 | 28862 | 3 | |||
| 36493 | 25099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.424800585099 | (37.7480997459068, -122.424800585099) | 2 | 4 | 5 | 28859 | 19 | |||
| 37098 | 194299 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014410.76303 | 2117359.45162 | 37.794675403602 | -122.394109677946 | (37.794675403602, -122.394109677946) | 12 | 2 | 10 | 28855 | 6 | |||
| 37137 | 24994 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.426332482174 | (37.7641827195917, -122.426332482174) | 8 | 4 | 5 | 28859 | 3 | |||
| 37457 | 194335 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 11 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403589 | (37.7809992081901, -122.38849403589) | 6 | 2 | 9 | 28856 | 20 | |||
| 37923 | 234382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.407418219675 | (37.7561790447523, -122.407418219675) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 38743 | 18563 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 18 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 38943 | 25129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | 2 | 7 | 5 | 63 | 22 | |||
| 39095 | 25102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 39756 | 194385 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6015616.39603 | 2115848.18198 | 37.7905927414207 | -122.389832379957 | (37.7905927414207, -122.389832379957) | 6 | 2 | 9 | 28855 | 6 | |||
| 40190 | 25085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005165.44363 | 2101134.84646 | 37.7496083631354 | -122.424944849843 | (37.7496083631354, -122.424944849843) | 2 | 4 | 5 | 28859 | 22 | |||
| 40411 | 25151 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004775.21348 | 2108066.24403 | 37.7686182937211 | -122.42678783859 | (37.7686182937211, -122.42678783859) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||||
| 41862 | 234342 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 Dolores St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 6ft | 6004943.91683 | 2104413.64545 | 37.7585986644128 | -122.425944266413 | (37.7585986644128, -122.425944266413) | 2 | 4 | 5 | 28862 | 3 | |||
| 42605 | 25098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005207.85517 | 2100363.53531 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | 2 | 7 | 5 | 63 | 22 | |||
| 42792 | 25073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.425104353592 | (37.7513282140435, -122.425104353592) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 43024 | 194324 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 6014719.87282 | 2117222.06559 | 37.7943153492131 | -122.393030491457 | (37.7943153492131, -122.393030491457) | 12 | 2 | 10 | 28855 | 6 | |||
| 43098 | 25024 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005003.84878 | 2104046.64903 | 37.7575943654175 | -122.425710873457 | (37.7575943654175, -122.425710873457) | 2 | 4 | 5 | 28862 | 3 | |||
| 43702 | 24989 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 370X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004890.15326 | 2106095.93205 | 37.7632147864474 | -122.426249975677 | (37.7632147864474, -122.426249975677) | 8 | 4 | 5 | 28859 | 3 | |||
| 43770 | 24998 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 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 | |||
| 44516 | 132094 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012848.0944 | 2119927.29492 | 37.8016391096046 | -122.399697138826 | (37.8016391096046, -122.399697138826) | 3 | 1 | 10 | 28860 | 6 | |||
| 44613 | 234336 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6004864.24492 | 2105581.16954 | 37.7617999064621 | -122.426302932261 | (37.7617999064621, -122.426302932261) | 8 | 4 | 5 | 28862 | 3 | |||
| 44648 | 119407 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375 32nd Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 9ft | 5985884.85714 | 2113320.57304 | 37.7819590323137 | -122.492514128744 | (37.7819590323137, -122.492514128744) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | ||||
| 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 | |||
| 46127 | 25143 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 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 | ||||
| 46729 | 25006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
| 47545 | 24964 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 48140 | 194380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.7900674842722 | -122.389207795421 | (37.7900674842722, -122.389207795421) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 48677 | 25052 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | 2 | 4 | 5 | 28862 | 22 | |||
| 49036 | 25075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1198 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | 2 | 4 | 5 | 28862 | 22 | |||
| 49188 | 234397 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 50815 | 194375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6016059.60857 | 2115304.27364 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | 6 | 2 | 9 | 28855 | 6 | |||
| 50904 | 194330 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 6 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 6015863.58652 | 2112149.96757 | 37.7804519868963 | -122.38871883132 | (37.7804519868963, -122.38871883132) | 6 | 2 | 9 | 28856 | 20 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 52518 | 13388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5997667.52153 | 2098758.8322 | 37.7426580336411 | -122.45070150969 | (37.7426580336411, -122.45070150969) | 9 | 7 | 4 | 59 | 40 | |||
| 52598 | 25009 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004942.00867 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | 2 | 4 | 5 | 28862 | 3 | |||
| 53288 | 210910 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387 | -122.461135900907 | (37.743908769387, -122.461135900907) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 53587 | 24987 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.426302779348 | (37.7638331171148, -122.426302779348) | 8 | 4 | 5 | 28859 | 3 | |||
| 53940 | 28194 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 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 | ||||
| 54047 | 18560 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014546.06488 | 2095149.21711 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | 10 | 3 | 8 | 58 | 1 | |||
| 54599 | 25021 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005015.54343 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | 2 | 4 | 5 | 28862 | 3 | |||
| 54880 | 194304 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | 12 | 2 | 10 | 28855 | 6 | |||
| 55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
| 55447 | 194394 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014490.42947 | 2089308.04208 | 37.7176566864975 | -122.391871584628 | (37.7176566864975, -122.391871584628) | 10 | 3 | 8 | 58 | 1 | |||
| 55831 | 25003 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||||
| 56033 | 25025 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 56236 | 118759 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.506024939755 | (37.7781852088244, -122.506024939755) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | ||||
| 57209 | 194341 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | 6 | 2 | 9 | 28856 | 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 | |||
| 57730 | 25005 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004909.62219 | 2105744.11353 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | 8 | 4 | 5 | 28859 | 3 | |||
| 57913 | 234378 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.422392021673 | (37.7622720010628, -122.422392021673) | 8 | 4 | 5 | 28859 | 19 | |||
| 58327 | 132127 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.7951191201157 | -122.394552795494 | (37.7951191201157, -122.394552795494) | 4 | 2 | 10 | 28860 | 6 |
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) );