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) | |||
| 3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
| 3170 | 3170 | 208471 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1175 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/23/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 780657 | 5991201.16474 | 2105172.16858 | 37.7598951180952 | -122.473527781682 | (37.7598951180952, -122.473527781682) | |
| 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) | |||
| 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) | ||
| 3787 | 3787 | 65935 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1343 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1990 12:00:00 AM | 14 | Permit Number 28954 | 6006463.24964 | 2119706.38252 | 37.800674552539604 | -122.421775955514 | (37.8006745525396, -122.421775955514) | ||
| 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 | ||||||||
| 8287 | 8287 | 47845 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 8319 | 8319 | 47848 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 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) | |||
| 9991 | 9991 | 34375 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38127 | 6003918.97921609 | 2097483.80532691 | 37.7395129612854 | -122.428994891637 | (37.7395129612854, -122.428994891637) | ||
| 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) | |||
| 12078 | 12078 | 47847 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12229 | 12229 | 47849 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12714 | 12714 | 47846 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 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 | ||||||||
| 16207 | 16207 | 47844 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 16947 | 16947 | 29712 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.5035900003 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | |||
| 17074 | 17074 | 29980 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.535069999 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | ||
| 17267 | 17267 | 29992 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005877.58141 | 2099371.3233 | 37.7448063305595 | -122.42235696431601 | (37.7448063305595, -122.422356964316) | ||
| 17337 | 17337 | 30016 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.5289199995 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | ||
| 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) | |||
| 17567 | 17567 | 30007 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005678.3438 | 2098731.5578099997 | 37.7430384387857 | -122.42300042833 | (37.7430384387857, -122.42300042833) | ||
| 17655 | 17655 | 30017 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.2110900003 | 37.743211575362004 | -122.42293717722201 | (37.743211575362, -122.422937177222) | ||
| 17674 | 17674 | 5570 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1027 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1998 12:00:00 AM | 8 | 3x3 | 6005145.15998 | 2102348.30914 | 37.752939104875296 | -122.42510132197701 | (37.7529391048753, -122.425101321977) | ||
| 17696 | 17696 | 5612 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1165 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2006 12:00:00 AM | 3 | 3X3 | 6005185.4414800005 | 2101562.25197 | 37.750783049509295 | -122.424906100762 | (37.7507830495093, -122.424906100762) | ||
| 17852 | 17852 | 29994 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.229830001 | 2099389.42314 | 37.744856347235896 | -122.422338718883 | (37.7448563472359, -122.422338718883) | ||
| 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) | ||||
| 18184 | 18184 | 89570 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4935 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983308.7395 | 2111690.5540299998 | 37.77733251999 | -122.50130555865499 | (37.77733251999, -122.501305558655) | ||
| 18242 | 18242 | 2325 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2298X Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2004 12:00:00 AM | 3 | 3X3 | 6009629.89674 | 2103998.72024 | 37.757723086282 | -122.409708671514 | (37.757723086282, -122.409708671514) | ||
| 18460 | 18460 | 29998 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.8207 | 2099404.7215 | 37.7448986684345 | -122.42232047341601 | (37.7448986684345, -122.422320473416) | ||
| 18498 | 18498 | 30012 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005734.30948 | 2098905.3013 | 37.743518656953 | -122.422819258997 | (37.743518656953, -122.422819258997) | ||
| 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) | ||||
| 18873 | 18873 | 29989 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005863.98756 | 2099326.06351 | 37.74468129061479 | -122.42240075410801 | (37.7446812906148, -122.422400754108) | ||
| 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) | |||
| 19092 | 19092 | 5696 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1552 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2008 12:00:00 AM | 6 | 3x3 | 6005224.49905 | 2099276.7754 | 37.7445098618418 | -122.42460847732201 | (37.7445098618418, -122.424608477322) | ||
| 19193 | 19193 | 30011 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 795X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | 6005625.43803 | 2098570.80228 | 37.7425940549807 | -122.423171938039 | (37.7425940549807, -122.423171938039) | ||
| 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) | |||
| 19754 | 19754 | 109729 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4534 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774273 | 6000926.1 | 2104675.0 | 37.7590883953394 | -122.439858400707 | (37.7590883953394, -122.439858400707) |
| 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) | |||
| 19921 | 19921 | 29988 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005860.9876 | 2099317.01753 | 37.7446562831756 | -122.42241048477501 | (37.7446562831756, -122.422410484775) | ||
| 19973 | 19973 | 29997 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.0743 | 2099402.63475 | 37.7448928965893 | -122.422322906097 | (37.7448928965893, -122.422322906097) | ||
| 20201 | 20201 | 30009 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005685.14822 | 2098754.53828 | 37.7431019219116 | -122.422978533436 | (37.7431019219116, -122.422978533436) | ||
| 20445 | 20445 | 29981 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005920.83177 | 2099524.56663 | 37.7452295416039 | -122.422218297841 | (37.7452295416039, -122.422218297841) | ||
| 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) | |||
| 20506 | 20506 | 29709 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005913.75363 | 2099762.2133 | 37.745881666108204 | -122.422259654058 | (37.7458816661082, -122.422259654058) | |||
| 20584 | 20584 | 29990 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005867.00191 | 2099335.81011 | 37.7447082226084 | -122.422391023449 | (37.7447082226084, -122.422391023449) | ||
| 20690 | 20690 | 29987 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 688X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005801.21502 | 2099130.13322 | 37.7441397692444 | -122.42260388936 | (37.7441397692444, -122.42260388936) | ||
| 20739 | 20739 | 29982 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005921.74385 | 2099534.70656 | 37.7452574349955 | -122.422215864289 | (37.7452574349955, -122.422215864289) | ||
| 20960 | 20960 | 29713 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005909.200119999 | 2099831.66519 | 37.7460721083515 | -122.422280333079 | (37.7460721083515, -122.422280333079) | |||
| 21484 | 21484 | 30010 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005675.35784 | 2098723.21181 | 37.7430153540666 | -122.423010159912 | (37.7430153540666, -122.423010159912) | ||
| 21551 | 21551 | 30008 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005682.80795 | 2098743.3766799998 | 37.743071142629795 | -122.422985832334 | (37.7430711426298, -122.422985832334) | ||
| 21719 | 21719 | 29996 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005885.11752 | 2099395.68964 | 37.7448736601053 | -122.422332636749 | (37.7448736601053, -122.422332636749) | ||
| 21854 | 21854 | 30013 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005738.10231 | 2098921.33618 | 37.7435628991021 | -122.42280728365101 | (37.7435628991021, -122.422807283651) | ||
| 22277 | 22277 | 29993 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005880.60295 | 2099381.4202099997 | 37.7448342248263 | -122.422347233647 | (37.7448342248263, -122.422347233647) | ||
| 22281 | 22281 | 29985 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 688X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005799.980169999 | 2099121.4011 | 37.744115723156796 | -122.422607538818 | (37.7441157231568, -122.422607538818) | ||
| 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) | |||
| 24542 | 24542 | 38375 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | 2 | Permit Number 40434 | 5982171.278 | 2102815.4467 | 37.7528971616744 | -122.50458262013201 | (37.7528971616744, -122.504582620132) | |
| 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) |
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");