Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | |||
| 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) | |||
| 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) | ||||
| 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 | ||||||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 25592 | 25592 | 69488 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 425 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 20 | Permit Number 33610 | 6002125.08495 | 2093879.83517 | 37.729515582259396 | -122.434939712705 | (37.7295155822594, -122.434939712705) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 27959 | 27959 | 47452 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 5049 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45359 | 5982965.18721 | 2111677.50205 | 37.777276501752894 | -122.502493031756 | (37.7772765017529, -122.502493031756) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29257 | 29257 | 92418 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1242 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52811 | 5984306.481000001 | 2106711.5777 | 37.763720214535496 | -122.49748642146099 | (37.7637202145355, -122.497486421461) |
| 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) | |||
| 29339 | 29339 | 49418 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 413@ 19th ST Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014094.43855 | 2105154.43805 | 37.7611456110148 | -122.39434924833799 | (37.7611456110148, -122.394349248338) | ||
| 29630 | 29630 | 245636 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008273.01473 | 2099327.11999 | 37.7448197924968 | -122.414070855604 | (37.7448197924968, -122.414070855604) | |||
| 29672 | 29672 | 92402 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1535 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52802 | 5985244.0 | 2104754.6 | 37.7584018060121 | -122.494099636368 | (37.7584018060121, -122.494099636368) |
| 29837 | 29837 | 35003 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3508 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2013 12:00:00 AM | 3 | Permit Number 768133 | 5984707.64332 | 2111114.1304599997 | 37.775831878815495 | -122.49642382506 | (37.7758318788155, -122.49642382506) | ||
| 29905 | 29905 | 69492 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 61 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33614 | 6002850.0061800005 | 2094591.87485 | 37.7315118155116 | -122.43248442771099 | (37.7315118155116, -122.432484427711) | |
| 29991 | 29991 | 205348 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2179 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991626.2491 | 2100612.76808 | 37.7474008036235 | -122.47172536133199 | (37.7474008036235, -122.471725361332) | |||
| 30540 | 30540 | 37494 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 31228 | 31228 | 183686 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1319 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984282.0441 | 2106184.7768 | 37.7622723352997 | -122.497532043867 | (37.7622723352997, -122.497532043867) | |||
| 31330 | 31330 | 182475 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1566 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987172.6159 | 2104623.1628 | 37.758153578438 | -122.487420059761 | (37.758153578438, -122.487420059761) | |||
| 31346 | 31346 | 205349 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1500 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991296.39005 | 2098426.70371 | 37.741379343378796 | -122.472706614323 | (37.7413793433788, -122.472706614323) | |||
| 31486 | 31486 | 245655 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3164 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008635.322430001 | 2101576.74228 | 37.7510170971771 | -122.412977088449 | (37.7510170971771, -122.412977088449) | |||
| 31587 | 31587 | 205311 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 181 Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999522.68832 | 2094056.5705400002 | 37.7298527515924 | -122.44394912005801 | (37.7298527515924, -122.443949120058) | |||
| 31716 | 31716 | 184418 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3717 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981908.8319 | 2100773.9171 | 37.7472762530428 | -122.505338890407 | (37.7472762530428, -122.505338890407) | |||
| 32209 | 32209 | 78576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 574 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2011 12:00:00 AM | 3 | Permit Number 767978 | 6009888.44286 | 2088699.0602400003 | 37.7157279923247 | -122.40773572982599 | (37.7157279923247, -122.407735729826) | |
| 32398 | 32398 | 245535 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008270.02595 | 2099337.89362 | 37.7448492066234 | -122.414081952318 | (37.7448492066234, -122.414081952318) | |||
| 32454 | 32454 | 245686 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 84 Pond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003174.39941 | 2106002.2203 | 37.7628603465492 | -122.43217750079201 | (37.7628603465492, -122.432177500792) | |||
| 32507 | 32507 | 182194 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2830 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985446.5605 | 2104353.3136 | 37.7573118352003 | -122.493369537581 | (37.7573118352003, -122.493369537581) | |||
| 32550 | 32550 | 246184 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 789 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999946.1417 | 2108227.6327 | 37.76878721042821 | -122.443502747941 | (37.7687872104282, -122.443502747941) | |||
| 32561 | 32561 | 117656 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4945 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5983252.4812199995 | 2111689.75712 | 37.7773270279447 | -122.501500112185 | (37.7773270279447, -122.501500112185) | |||
| 32665 | 32665 | 183711 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3727 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5984132.3296 | 2106974.9206 | 37.7644330705313 | -122.49810819735501 | (37.7644330705313, -122.498108197355) | |||
| 32698 | 32698 | 92457 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2174 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52847 | 5981421.6737 | 2100290.4816 | 37.7459201959872 | -122.506987562585 | (37.7459201959872, -122.506987562585) |
| 32705 | 32705 | 184612 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3550 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982960.1392 | 2102917.9885 | 37.7532250836044 | -122.501862221436 | (37.7532250836044, -122.501862221436) | |||
| 33145 | 33145 | 245548 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1187 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007688.255059999 | 2102766.23628 | 37.7542299692468 | -122.41633639261002 | (37.7542299692468, -122.41633639261) | |||
| 33155 | 33155 | 245533 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 111 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6008271.8645 | 2099305.4728900003 | 37.744760289760706 | -122.414073301756 | (37.7447602897607, -122.414073301756) | |||
| 33338 | 33338 | 35006 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3516 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2013 12:00:00 AM | 10 | Permit Number 768133 | 5984654.255030001 | 2111112.3919 | 37.775823977470395 | -122.49660837764 | (37.7758239774704, -122.49660837764) | ||
| 33360 | 33360 | 189380 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1190 Fairfax Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017813.34162 | 2096563.52583 | 37.73776274764779 | -122.380889773354 | (37.7377627476478, -122.380889773354) | |||
| 33385 | 33385 | 205269 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991539.28876 | 2105242.88363 | 37.7601088581456 | -122.47236354183799 | (37.7601088581456, -122.472363541838) |
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");