Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2068 | 2068 | 158899 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 253 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 0ft | 5998481.355769999 | 2093479.93721 | 37.7282099959864 | -122.447507621406 | (37.7282099959864, -122.447507621406) | |||
| 3577 | 3577 | 253466 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98X Marston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 18031 | 18031 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 22915 | 22915 | 189301 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1345 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013913.31542 | 2104750.9131 | 37.76002754956421 | -122.394947417095 | (37.7600275495642, -122.394947417095) | |||
| 23391 | 23391 | 126083 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999112.99946 | 2121376.93874 | 37.804844210643104 | -122.44733105300199 | (37.8048442106431, -122.447331053002) | |||
| 23516 | 23516 | 201490 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 404 Hawes St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018801.89872 | 2095027.62617 | 37.7335999801502 | -122.37736527181299 | (37.7335999801502, -122.377365271813) | ||||
| 24304 | 24304 | 175944 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1764 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5997944.4131 | 2088561.35887 | 37.7146740246601 | -122.449009674469 | (37.7146740246601, -122.449009674469) | |||
| 24831 | 24831 | 205461 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 18 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 6ft | 5998119.976480001 | 2093734.95335 | 37.728889551613705 | -122.44877527875799 | (37.7288895516137, -122.448775278758) | |||
| 24964 | 24964 | 205338 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Ralston St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5992219.15057 | 2089273.39944 | 37.716300015102796 | -122.46885013342899 | (37.7163000151028, -122.468850133429) | |||
| 25035 | 25035 | 175929 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 207 San Juan Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001163.218780001 | 2092286.63013 | 37.7250863447352 | -122.438150888659 | (37.7250863447352, -122.438150888659) | |||
| 25446 | 25446 | 122296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1799 Cabrillo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5990085.59 | 2110638.88168 | 37.7748405619036 | -122.477785590315 | (37.7748405619036, -122.477785590315) | |||
| 25511 | 25511 | 119143 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5981300.41517 | 2111472.41115 | 37.776615419273895 | -122.508236685403 | (37.7766154192739, -122.508236685403) | |||
| 25733 | 25733 | 245683 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3678 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6003829.6930599995 | 2103071.3220900004 | 37.7548499295039 | -122.429702017943 | (37.7548499295039, -122.429702017943) | |||
| 26058 | 26058 | 205425 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 60 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999706.93127 | 2095527.57253 | 37.7339022872494 | -122.44341779339399 | (37.7339022872494, -122.443417793394) | ||||
| 26166 | 26166 | 205403 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 920 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5995980.66539 | 2094683.17632 | 37.7313705751845 | -122.456239515042 | (37.7313705751845, -122.456239515042) | |||
| 26788 | 26788 | 245731 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 82 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6001964.94974 | 2108129.58047 | 37.76863290861979 | -122.436512831101 | (37.7686329086198, -122.436512831101) | |||
| 26892 | 26892 | 205315 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 147 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999124.07118 | 2093461.08055 | 37.7281949287511 | -122.44528438218201 | (37.7281949287511, -122.445284382182) | ||||
| 27398 | 27398 | 205475 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | ||||
| 27512 | 27512 | 126081 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999108.91341 | 2121411.06481 | 37.8049376780854 | -122.447347650898 | (37.8049376780854, -122.447347650898) | |||
| 27539 | 27539 | 245689 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 50 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000846.651319999 | 2104372.11422 | 37.758252222176104 | -122.44011145208599 | (37.7582522221761, -122.440111452086) | |||
| 29337 | 29337 | 205252 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1489 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991141.67594 | 2105283.7326 | 37.760197998052604 | -122.473741661159 | (37.7601979980526, -122.473741661159) | |||
| 29536 | 29536 | 184083 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1600 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984945.8447 | 2104060.7868 | 37.756479336636296 | -122.49507961366301 | (37.7564793366363, -122.495079613663) | |||
| 29731 | 29731 | 205427 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 90 Melrose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5999502.43609 | 2095532.0272 | 37.7339028547262 | -122.444125112901 | (37.7339028547262, -122.444125112901) | |||
| 30118 | 30118 | 205434 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 222 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000590.7976 | 2094973.99964 | 37.732432670014894 | -122.440322320638 | (37.7324326700149, -122.440322320638) | |||
| 30910 | 30910 | 205308 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 312 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5999357.46661 | 2094402.70977 | 37.7307937428201 | -122.444545176343 | (37.7307937428201, -122.444545176343) | ||||
| 32072 | 32072 | 126075 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 5997922.81564 | 2113961.32913 | 37.7844148567072 | -122.450914744323 | (37.7844148567072, -122.450914744323) | |||
| 32087 | 32087 | 205478 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 442 Circular Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5999784.33637 | 2093736.40435 | 37.7289885714569 | -122.44302159167 | (37.7289885714569, -122.44302159167) | ||||
| 32242 | 32242 | 126072 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5997944.17854 | 2113963.60849 | 37.78442233817079 | -122.45084100083099 | (37.7844223381708, -122.450841000831) | |||
| 32298 | 32298 | 205451 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 370 Monterey Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5999656.98493 | 2094723.11119 | 37.731690576464 | -122.44353270427 | (37.731690576464, -122.44353270427) | |||
| 32329 | 32329 | 186320 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1800 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984982.8796 | 2102861.3111 | 37.753188075713204 | -122.494863100231 | (37.7531880757132, -122.494863100231) | |||
| 32592 | 32592 | 205476 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999461.7393 | 2093534.4829400002 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | ||||
| 33151 | 33151 | 205411 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Joost Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 6ft | 6001323.450019999 | 2094964.8155099999 | 37.7324491402005 | -122.43778871637 | (37.7324491402005, -122.43778871637) | |||
| 33292 | 33292 | 175977 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1053 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 6ft | 6007850.48463 | 2093695.0400900003 | 37.72933159448 | -122.41513330118 | (37.72933159448, -122.41513330118) | |||
| 33500 | 33500 | 205456 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 265 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6000331.962859999 | 2094928.67856 | 37.7322934882457 | -122.44121392020901 | (37.7322934882457, -122.441213920209) | ||||
| 34395 | 34395 | 175877 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 224 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6007380.7921 | 2087208.4436400002 | 37.7114943717343 | -122.416297828777 | (37.7114943717343, -122.416297828777) | |||
| 35105 | 35105 | 205305 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 251 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999742.41189 | 2094337.43006 | 37.7306364577097 | -122.44320967680099 | (37.7306364577097, -122.443209676801) | |||
| 35522 | 35522 | 205463 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 15 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5999770.24312 | 2093744.34025 | 37.7290095580429 | -122.443070882641 | (37.7290095580429, -122.443070882641) | |||
| 36613 | 36613 | 175920 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3014 22nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5989746.7412 | 2095193.8817200002 | 37.7324130198412 | -122.47782843323601 | (37.7324130198412, -122.477828433236) | |||
| 36720 | 36720 | 175883 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 52 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5999221.0603 | 2088431.7990299999 | 37.7143912139527 | -122.444587768206 | (37.7143912139527, -122.444587768206) | |||
| 36972 | 36972 | 205245 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1590 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5990905.54832 | 2104583.73328 | 37.7582623071733 | -122.47450722074 | (37.7582623071733, -122.47450722074) | |||
| 37256 | 37256 | 205423 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 60 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999724.04127 | 2095532.1759900001 | 37.7339159029983 | -122.443358969664 | (37.7339159029983, -122.443358969664) | ||||
| 37479 | 37479 | 175958 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 964 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005280.1292 | 2092112.2492799999 | 37.7248408154316 | -122.423906757903 | (37.7248408154316, -122.423906757903) | |||
| 37489 | 37489 | 205485 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 66 Marston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998899.62113 | 2093233.2174 | 37.7275564550591 | -122.44604392890601 | (37.7275564550591, -122.446043928906) | ||||
| 37592 | 37592 | 245768 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 50 Digby St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6002895.54677 | 2097597.3994299998 | 37.7397668805496 | -122.432541584154 | (37.7397668805496, -122.432541584154) | |||
| 38618 | 38618 | 205246 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1518 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5990890.58105 | 2105042.0422 | 37.7595198346025 | -122.474592431492 | (37.7595198346025, -122.474592431492) | |||
| 38868 | 38868 | 205375 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 340 Rivera St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5992005.20225 | 2100503.1627 | 37.7471217736707 | -122.470406998394 | (37.7471217736707, -122.470406998394) | |||
| 38987 | 38987 | 245572 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 560 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 6002734.90719 | 2100089.37623 | 37.74660015789 | -122.43327502533998 | (37.74660015789, -122.43327502534) | |||
| 39272 | 39272 | 245571 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4220 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002399.35344 | 2100348.21593 | 37.7472918291588 | -122.43445383688 | (37.7472918291588, -122.43445383688) | ||||
| 39334 | 39334 | 205454 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 90 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 6001505.95732 | 2094694.4733099998 | 37.7317172188577 | -122.437138397743 | (37.7317172188577, -122.437138397743) | |||
| 39480 | 39480 | 175927 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 207 San Juan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001152.36448 | 2092293.4422400002 | 37.725104431914204 | -122.438188898514 | (37.7251044319142, -122.438188898514) | |||
| 39586 | 39586 | 205482 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 66 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998899.7709800005 | 2093221.03408 | 37.727523011064 | -122.44604253493799 | (37.727523011064, -122.446042534938) | ||||
| 39976 | 39976 | 245594 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 490 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002120.10164 | 2102991.64483 | 37.754534200898 | -122.435608552002 | (37.754534200898, -122.435608552002) | |||
| 39988 | 39988 | 205320 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 116 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998646.31985 | 2093225.3991200002 | 37.727520519930394 | -122.44691902769199 | (37.7275205199304, -122.446919027692) | ||||
| 40404 | 40404 | 126082 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999109.9891800005 | 2121405.06557 | 37.8049212672724 | -122.44734349603 | (37.8049212672724, -122.44734349603) | |||
| 40499 | 40499 | 205393 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1110 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998260.64924 | 2095668.48595 | 37.734206617839 | -122.44842815215 | (37.734206617839, -122.44842815215) | |||
| 41090 | 41090 | 126079 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2826 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000085.94786 | 2118320.10762 | 37.796506516817104 | -122.443744328262 | (37.7965065168171, -122.443744328262) | |||
| 41409 | 41409 | 175964 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 716 Peru Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 6005262.51487 | 2092457.27514 | 37.7257871864131 | -122.423992172815 | (37.7257871864131, -122.423992172815) | |||
| 41451 | 41451 | 205472 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5999475.13727 | 2093536.5919400002 | 37.7284222989294 | -122.444076160988 | (37.7284222989294, -122.444076160988) | ||||
| 41587 | 41587 | 205468 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 178 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5998873.03951 | 2093527.74224 | 37.7283636334597 | -122.446156997958 | (37.7283636334597, -122.446156997958) | |||
| 42232 | 42232 | 205327 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 218 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5994824.42193 | 2089656.9549900002 | 37.7175033403925 | -122.45987288223499 | (37.7175033403925, -122.459872882235) | |||
| 42343 | 42343 | 245597 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 179 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6003322.29715 | 2096498.45527 | 37.736773622893296 | -122.430987650966 | (37.7367736228933, -122.430987650966) | |||
| 42498 | 42498 | 189305 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 501 Texas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6013843.528390001 | 2104740.21019 | 37.7599942809301 | -122.395188028931 | (37.7599942809301, -122.395188028931) | |||
| 42554 | 42554 | 189294 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1940 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6012210.95839 | 2104716.11171 | 37.7598371855631 | -122.40083264261801 | (37.7598371855631, -122.400832642618) | |||
| 43595 | 43595 | 245703 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 485 Liberty St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003161.31999 | 2103874.76001 | 37.7570181095143 | -122.432070807024 | (37.7570181095143, -122.432070807024) | |||
| 43677 | 43677 | 205391 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1110 Teresita Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998274.927730001 | 2095667.8791200002 | 37.734205767985394 | -122.448378743402 | (37.7342057679854, -122.448378743402) | |||
| 43713 | 43713 | 205474 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999468.48436 | 2093527.67559 | 37.728397437176106 | -122.444098519924 | (37.7283974371761, -122.444098519924) | ||||
| 43764 | 43764 | 205442 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 551 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5998447.7669400005 | 2094952.5637599998 | 37.7322515618476 | -122.447729708064 | (37.7322515618476, -122.447729708064) | |||
| 43834 | 43834 | 205429 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 979 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5998328.88078 | 2095661.5706 | 37.7341915308101 | -122.448191757267 | (37.7341915308101, -122.448191757267) | |||
| 44416 | 44416 | 175952 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 275 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004189.375469999 | 2091812.49337 | 37.723956112778104 | -122.42765601892201 | (37.7239561127781, -122.427656018922) | ||||
| 44969 | 44969 | 205417 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 198 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000139.85205 | 2095251.7294400001 | 37.733169565523795 | -122.441901267552 | (37.7331695655238, -122.441901267552) | ||||
| 45176 | 45176 | 205449 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 582 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 10ft | 5997495.93941 | 2095291.26202 | 37.7331270995186 | -122.45104479079599 | (37.7331270995186, -122.451044790796) | |||
| 45400 | 45400 | 175972 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 96 Stoneybrook Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | 6005707.91985 | 2093742.9430799999 | 37.729342485259 | -122.422543755295 | (37.729342485259, -122.422543755295) | ||||
| 45991 | 45991 | 189302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1345 20th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013921.81731 | 2104751.14346 | 37.760028654829 | -122.39491802906099 | (37.760028654829, -122.394918029061) | |||
| 47011 | 47011 | 205318 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 116 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5998650.07157 | 2093225.61944 | 37.7275213392142 | -122.44690607387 | (37.7275213392142, -122.44690607387) | ||||
| 47108 | 47108 | 186831 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1200 Sunset Blvd | 90 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984823.4905 | 2106576.2092 | 37.763378820926 | -122.495688286465 | (37.763378820926, -122.495688286465) | |||
| 47142 | 47142 | 205428 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 814 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 5999472.09449 | 2095611.6344299999 | 37.734119706463396 | -122.444235731314 | (37.7341197064634, -122.444235731314) | |||
| 47188 | 47188 | 205323 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 744 Lakeview Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5994595.93663 | 2089945.86852 | 37.7182834851695 | -122.460683570699 | (37.7182834851695, -122.460683570699) | |||
| 47265 | 47265 | 205389 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 14 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5997839.20016 | 2095661.66504 | 37.734163784039005 | -122.449884737311 | (37.734163784039, -122.449884737311) | |||
| 47894 | 47894 | 126080 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999106.49254 | 2121421.6346299998 | 37.8049665616081 | -122.44735678979099 | (37.8049665616081, -122.447356789791) | |||
| 48041 | 48041 | 205408 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 190 Marietta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5998852.43229 | 2097817.92525 | 37.7401422836322 | -122.44653676816401 | (37.7401422836322, -122.446536768164) | |||
| 48604 | 48604 | 205400 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 104 Omar Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5998070.50386 | 2097545.50519 | 37.739349589724895 | -122.449220725551 | (37.7393495897249, -122.449220725551) | |||
| 48898 | 48898 | 189304 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1345 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013935.92208 | 2104751.61933 | 37.760030745741894 | -122.394869280409 | (37.7600307457419, -122.394869280409) | |||
| 49199 | 49199 | 205307 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 251 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999754.48593 | 2094339.62957 | 37.730643185524706 | -122.44316809305599 | (37.7306431855247, -122.443168093056) | |||
| 49305 | 49305 | 205340 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 494 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993277.92087 | 2090411.70077 | 37.719486628792 | -122.465273175336 | (37.719486628792, -122.465273175336) | |||
| 50560 | 50560 | 245760 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 127 Farnum St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002444.1806 | 2097361.0891 | 37.739092420482294 | -122.43408532709 | (37.7390924204823, -122.43408532709) | |||
| 50943 | 50943 | 175928 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 207 San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001160.91031 | 2092287.3903299998 | 37.7250883007811 | -122.43815892321001 | (37.7250883007811, -122.43815892321) | |||
| 51363 | 51363 | 175921 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3014 22nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5989750.67751 | 2095205.8694200001 | 37.7324461634578 | -122.477815700639 | (37.7324461634578, -122.477815700639) | |||
| 51618 | 51618 | 205441 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 551 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5998447.07636 | 2094956.41614 | 37.7322621001019 | -122.44773237277599 | (37.7322621001019, -122.447732372776) | |||
| 52037 | 52037 | 205263 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1115 Kirkham St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5991466.37846 | 2105174.44554 | 37.7599167251969 | -122.47261071152501 | (37.7599167251969, -122.472610711525) | |||
| 52434 | 52434 | 205409 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 47 Chilton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001682.7652199995 | 2095616.45632 | 37.7342588207884 | -122.43659310730499 | (37.7342588207884, -122.436593107305) | ||||
| 52631 | 52631 | 186828 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1200 Sunset Blvd | 95 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984824.2272 | 2106601.6272 | 37.76344865476 | -122.495687613477 | (37.76344865476, -122.495687613477) | |||
| 53165 | 53165 | 205388 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 413 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5997508.41793 | 2095710.9307799998 | 37.7342801239184 | -122.45103190171301 | (37.7342801239184, -122.451031901713) | |||
| 53898 | 53898 | 245631 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 74 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6009564.00746 | 2098268.81598 | 37.741986347086204 | -122.40953214898799 | (37.7419863470862, -122.409532148988) | |||
| 54399 | 54399 | 175969 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 333 Pioche St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6005901.5466 | 2093289.9691299999 | 37.7281096397472 | -122.42184220585199 | (37.7281096397472, -122.421842205852) | |||
| 54518 | 54518 | 205460 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 658 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5997715.90163 | 2095023.42479 | 37.7324042730369 | -122.45026502641899 | (37.7324042730369, -122.450265026419) | |||
| 54637 | 54637 | 205249 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1521 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5990832.17445 | 2104998.6079599997 | 37.7593971913553 | -122.474791258137 | (37.7593971913553, -122.474791258137) | |||
| 54791 | 54791 | 175874 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1441 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5999110.44202 | 2089599.42923 | 37.717590947838104 | -122.44505399834699 | (37.7175909478381, -122.445053998347) | |||
| 54928 | 54928 | 245733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Alpine Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6001700.20179 | 2108226.0430400004 | 37.7688827231901 | -122.437435479759 | (37.7688827231901, -122.437435479759) | |||
| 55033 | 55033 | 205293 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 146 Stillings Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999807.52736 | 2095794.02146 | 37.7346396297213 | -122.443089132554 | (37.7346396297213, -122.443089132554) | ||||
| 55094 | 55094 | 181410 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1500 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984893.9566 | 2104717.3186 | 37.7582789528631 | -122.495307474291 | (37.7582789528631, -122.495307474291) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");