Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1287 | 1287 | 245764 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Width 3ft | Permit Number 779702 | 6004001.6074 | 2097411.86925 | 37.739320118017 | -122.428704072653 | (37.739320118017, -122.428704072653) | ||
| 1737 | 1737 | 182373 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1534 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5984996.2741 | 2104755.1988 | 37.7583889515074 | -122.49495641386801 | (37.7583889515074, -122.494956413868) | |||
| 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) | |||
| 2252 | 2252 | 252990 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 52 Pierce St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x8 | 6002925.0 | 2108585.0 | 37.7699378868501 | -122.433224642796 | (37.7699378868501, -122.433224642796) | ||||
| 2958 | 2958 | 93566 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000961.67566 | 2121419.55702 | 37.8050666921269 | -122.440936588171 | (37.8050666921269, -122.440936588171) | |||
| 3368 | 3368 | 253427 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3369 | 3369 | 253425 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3370 | 3370 | 253423 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3380 | 3380 | 253426 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3382 | 3382 | 122965 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993050.799269999 | 2114904.9128799997 | 37.786725565514004 | -122.467838745487 | (37.786725565514, -122.467838745487) | |||
| 4626 | 4626 | 93565 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000974.0103 | 2121410.57303 | 37.8050427269948 | -122.44089325793999 | (37.8050427269948, -122.44089325794) | |||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 6085 | 6085 | 93568 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Cervantes Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000935.9481 | 2121438.25936 | 37.8051165784228 | -122.44102696373001 | (37.8051165784228, -122.44102696373) | |||
| 6655 | 6655 | 20047 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 8820 | 8820 | 93567 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000948.30119 | 2121430.16554 | 37.8050950585436 | -122.440983633492 | (37.8050950585436, -122.440983633492) | |||
| 8871 | 8871 | 93569 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Cervantes Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000923.60214 | 2121446.70907 | 37.805139075870706 | -122.441070294867 | (37.8051390758707, -122.441070294867) | |||
| 9702 | 9702 | 104171 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6002306.0 | 2096613.0 | 37.7370304975493 | -122.43450961762501 | (37.7370304975493, -122.434509617625) | |||
| 11441 | 11441 | 25394 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1045 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6000938.80793 | 2088782.07415 | 37.715450859936 | -122.43867564846902 | (37.715450859936, -122.438675648469) | |||
| 11858 | 11858 | 111285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x10 | 6003156.565119999 | 2086725.0907599998 | 37.709928747378505 | -122.43086338266501 | (37.7099287473785, -122.430863382665) | |||
| 13145 | 13145 | 19899 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 14316 | 14316 | 101784 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1017 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012216.2726 | 2103633.6604400002 | 37.7568653093127 | -122.40073821739901 | (37.7568653093127, -122.400738217399) | |||
| 15056 | 15056 | 20048 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 17549 | 17549 | 5699 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1569 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6 | 6005313.38344 | 2099208.61144 | 37.7443277185515 | -122.424296285742 | (37.7443277185515, -122.424296285742) | |||
| 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) | ||||
| 18680 | 18680 | 122353 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 155 Appleton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006071.0 | 2097171.0 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | ||||
| 18978 | 18978 | 15065 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1X Minerva St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996005.0253 | 2089004.0026599998 | 37.7157783129984 | -122.45574493019501 | (37.7157783129984, -122.455744930195) | |||
| 19443 | 19443 | 5712 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1617 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005334.5075199995 | 2098914.22042 | 37.743520580615 | -122.42420231019501 | (37.743520580615, -122.424202310195) | |||
| 19864 | 19864 | 26510 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2854 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6008945.91858 | 2101850.94862 | 37.7517874366552 | -122.41192238692301 | (37.7517874366552, -122.411922386923) | |||
| 20463 | 20463 | 5571 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1033 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005142.90403 | 2102326.22826 | 37.7528783484711 | -122.425107552489 | (37.7528783484711, -122.425107552489) | |||
| 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) | |||
| 23036 | 23036 | 11607 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4300 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 5981158.1048 | 2105571.7891 | 37.7604056423858 | -122.50829087908899 | (37.7604056423858, -122.508290879089) | |||
| 23096 | 23096 | 12683 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1301 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5991446.199519999 | 2114750.37653 | 37.7862084655919 | -122.473378948706 | (37.7862084655919, -122.473378948706) | |||
| 23180 | 23180 | 11605 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4300 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 5981172.9444 | 2105571.7891 | 37.7604065168831 | -122.50823955670201 | (37.7604065168831, -122.508239556702) | |||
| 23253 | 23253 | 5092 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2605 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 51 | 6002286.56903 | 2096627.94981 | 37.7370704432348 | -122.434577867771 | (37.7370704432348, -122.434577867771) | ||||
| 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) | |||
| 23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
| 23475 | 23475 | 245699 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 689 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003071.60291 | 2104232.46466 | 37.757995194134395 | -122.432406630082 | (37.7579951941344, -122.432406630082) | |||
| 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) | ||||
| 23577 | 23577 | 118033 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 89 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984120.82492 | 2112822.3596099997 | 37.780487786596204 | -122.498579960483 | (37.7804877865962, -122.498579960483) | |||
| 23908 | 23908 | 245647 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 478 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006778.49517 | 2100999.42527 | 37.749327509367106 | -122.419357245036 | (37.7493275093671, -122.419357245036) | |||
| 23910 | 23910 | 118018 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 492 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 5984413.88926 | 2112528.9426700003 | 37.779699331346 | -122.49754445899099 | (37.779699331346, -122.497544458991) | |||
| 24094 | 24094 | 118130 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3329 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5985237.75106 | 2111079.5821 | 37.775768059624504 | -122.494587526681 | (37.7757680596245, -122.494587526681) | |||
| 24180 | 24180 | 245677 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4206 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | Width 3ft | 6001747.193080001 | 2102367.94443 | 37.7528004815642 | -122.436853519485 | (37.7528004815642, -122.436853519485) | |||
| 24192 | 24192 | 183253 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5980913.074 | 2106102.483 | 37.7618483320506 | -122.50917772189 | (37.7618483320506, -122.50917772189) | |||
| 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) | |||
| 24330 | 24330 | 205383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 64 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994182.66644 | 2101796.2621 | 37.750797955763396 | -122.46297136414101 | (37.7507979557634, -122.462971364141) | |||
| 24414 | 24414 | 205283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 5994526.48433 | 2100257.0572599997 | 37.7465914866063 | -122.46167083296801 | (37.7465914866063, -122.461670832968) | |||
| 24740 | 24740 | 182490 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1560 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985003.029 | 2104585.8759 | 37.7579244332823 | -122.494920568176 | (37.7579244332823, -122.494920568176) | |||
| 24782 | 24782 | 245521 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 5 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998664.3758 | 2106893.76883 | 37.765051575289604 | -122.447840222145 | (37.7650515752896, -122.447840222145) | |||
| 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) | |||
| 25031 | 25031 | 126107 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2520 Baker St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5999698.94271 | 2117540.8900200003 | 37.794344910846206 | -122.44502739999201 | (37.7943449108462, -122.445027399992) | |||
| 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) | |||
| 25100 | 25100 | 205364 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 250 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994743.5494800005 | 2100407.30657 | 37.747016525988705 | -122.460931137866 | (37.7470165259887, -122.460931137866) | |||
| 25151 | 25151 | 189343 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1151 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017750.34235 | 2096562.27095 | 37.7377558246748 | -122.38110750730499 | (37.7377558246748, -122.381107507305) | |||
| 25253 | 25253 | 182913 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2650 Sloat Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982496.6705 | 2096518.7706 | 37.735627364936 | -122.502991257405 | (37.735627364936, -122.502991257405) | |||
| 25300 | 25300 | 117795 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3755 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983918.45231 | 2111030.33934 | 37.7755555482917 | -122.499147602329 | (37.7755555482917, -122.499147602329) | |||
| 25357 | 25357 | 245500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 290 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010408.82405 | 2099965.2209400004 | 37.7466916081328 | -122.406730554867 | (37.7466916081328, -122.406730554867) | |||
| 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) | |||
| 25604 | 25604 | 250134 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | ||||
| 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) | |||
| 25784 | 25784 | 182377 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1511 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985257.4301 | 2104883.1297 | 37.7587554987564 | -122.494062662548 | (37.7587554987564, -122.494062662548) | |||
| 25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
| 25903 | 25903 | 123464 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 644 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995356.46788 | 2111146.9174599997 | 37.7765399824879 | -122.459589450648 | (37.7765399824879, -122.459589450648) | |||
| 25938 | 25938 | 249996 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 41 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.40439586268101 | (37.8025435461134, -122.404395862681) | |||
| 25988 | 25988 | 182516 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1575 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985271.1371 | 2104502.1703 | 37.7577102918866 | -122.493987182038 | (37.7577102918866, -122.493987182038) | |||
| 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) | ||||
| 26113 | 26113 | 245518 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 71 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998295.5906 | 2106843.1359099997 | 37.7648914644932 | -122.449112105467 | (37.7648914644932, -122.449112105467) | |||
| 26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
| 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) | |||
| 26353 | 26353 | 182219 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1598 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985010.9097 | 2104360.0371 | 37.7573048039248 | -122.494876662608 | (37.7573048039248, -122.494876662608) | |||
| 26401 | 26401 | 189358 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017825.61264 | 2096067.48761 | 37.736401402503 | -122.380812873212 | (37.736401402503, -122.380812873212) | |||
| 26448 | 26448 | 245624 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 322 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006476.77935 | 2097220.02712 | 37.738933136141604 | -122.42013240038601 | (37.7389331361416, -122.420132400386) | |||
| 26606 | 26606 | 245480 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 168 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6006062.04873 | 2099258.29752 | 37.7445063913738 | -122.42171108379699 | (37.7445063913738, -122.421711083797) | |||
| 26668 | 26668 | 245605 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 635 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999820.90849 | 2107684.64891 | 37.7672891703973 | -122.44389690184799 | (37.7672891703973, -122.443896901848) | |||
| 26775 | 26775 | 117796 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3739 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983953.06795 | 2111029.92822 | 37.7755564500477 | -122.49902782995001 | (37.7755564500477, -122.49902782995) | |||
| 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) | ||||
| 27164 | 27164 | 187561 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.40405920239401 | (37.7143031001696, -122.404059202394) | ||||
| 27256 | 27256 | 245693 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001782.04143 | 2104305.66684 | 37.758122981497294 | -122.43687171366501 | (37.7581229814973, -122.436871713665) | |||
| 27351 | 27351 | 245675 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 549 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001592.628280001 | 2101435.5909700003 | 37.750231676050895 | -122.43732127666401 | (37.7502316760509, -122.437321276664) | |||
| 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) | |||
| 27628 | 27628 | 126112 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2501 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5999663.694080001 | 2117437.13083 | 37.794058003713005 | -122.445141900785 | (37.794058003713, -122.445141900785) | |||
| 27676 | 27676 | 205347 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2175 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991625.486740001 | 2100618.33125 | 37.7474160345426 | -122.471728402854 | (37.7474160345426, -122.471728402854) | |||
| 27963 | 27963 | 245573 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4185 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002743.424380001 | 2100624.8977799998 | 37.7480710575441 | -122.433283833306 | (37.7480710575441, -122.433283833306) | |||
| 28115 | 28115 | 205251 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1469 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991133.79898 | 2105423.31404 | 37.760580795391796 | -122.47377908645201 | (37.7605807953918, -122.473779086452) | |||
| 28139 | 28139 | 247240 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 921 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000040.78347 | 2108630.8128400003 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | |||
| 28157 | 28157 | 181439 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1395 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981197.3238 | 2105634.1509 | 37.760579181106 | -122.50815986988 | (37.760579181106, -122.50815986988) | |||
| 28367 | 28367 | 126067 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 139 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997532.4307 | 2115852.71345 | 37.7895857399475 | -122.452401866867 | (37.7895857399475, -122.452401866867) | |||
| 28443 | 28443 | 182222 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2840 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985405.1901 | 2104352.0968 | 37.757306074239104 | -122.49351252094999 | (37.7573060742391, -122.49351252095) | |||
| 28600 | 28600 | 245741 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 25 Temple St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5999967.936869999 | 2105824.43876 | 37.7621898821911 | -122.44325473101699 | (37.7621898821911, -122.443254731017) | |||
| 28613 | 28613 | 184182 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1618 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980983.7076 | 2104008.48 | 37.756102964650104 | -122.508777956978 | (37.7561029646501, -122.508777956978) | |||
| 29075 | 29075 | 126108 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2501 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5999653.99691 | 2117501.26675 | 37.7942335504827 | -122.445180067106 | (37.7942335504827, -122.445180067106) | |||
| 29121 | 29121 | 205270 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1224 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995838.93768 | 2107071.40007 | 37.7653774059583 | -122.45762550612301 | (37.7653774059583, -122.457625506123) | |||
| 29210 | 29210 | 183957 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2170 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989794.5815 | 2100587.2818 | 37.7472246780764 | -122.478057209982 | (37.7472246780764, -122.478057209982) | |||
| 29306 | 29306 | 245536 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008269.316980001 | 2099343.9975400004 | 37.7448659268119 | -122.414084835556 | (37.7448659268119, -122.414084835556) | |||
| 29308 | 29308 | 189383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1190 Fairfax Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017772.50724 | 2096612.75637 | 37.7378956710501 | -122.381034380748 | (37.7378956710501, -122.381034380748) |
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");