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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82793 | 82793 | 95708 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 277 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392.0 | 2091652.0 | 37.7235268927559 | -122.42694415274201 | (37.7235268927559, -122.426944152742) | ||
| 106660 | 106660 | 88115 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4133 Kirkham St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51116 | 5982072.0 | 2104866.0 | 37.758521560647395 | -122.505077887073 | (37.7585215606474, -122.505077887073) | |||
| 112057 | 112057 | 88275 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1910 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51266 | 5986038.6 | 2102202.7 | 37.7514414512274 | -122.49116379172399 | (37.7514414512274, -122.491163791724) | |||
| 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) | ||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | |||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | |||
| 29637 | 29637 | 247866 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 398 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.40961330563101 | (37.7423644418716, -122.409613305631) | ||||
| 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) | |||
| 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) | |||
| 31214 | 31214 | 205302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 301 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5994373.92191 | 2098940.4961900003 | 37.7429677574573 | -122.46210291221901 | (37.7429677574573, -122.462102912219) | |||
| 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) | |||
| 31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
| 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) | |||
| 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) | |||
| 31964 | 31964 | 118151 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3450 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5984812.19796 | 2111117.65554 | 37.7758476821806 | -122.49606240946501 | (37.7758476821806, -122.496062409465) | |||
| 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) | ||||
| 32190 | 32190 | 182215 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2998 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985108.0649 | 2104343.6089 | 37.757265383354294 | -122.49453945569599 | (37.7572653833543, -122.494539455696) | |||
| 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) | |
| 32340 | 32340 | 205339 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992450.822319999 | 2090054.7824900001 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | |||
| 32477 | 32477 | 182479 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1556 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985001.2277 | 2104593.5315 | 37.7579453479887 | -122.494927362203 | (37.7579453479887, -122.494927362203) | |||
| 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) | |||
| 33412 | 33412 | 183505 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2542 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988022.2437 | 2097979.1378 | 37.739960371072996 | -122.483994519568 | (37.739960371073, -122.483994519568) | |||
| 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) | ||||
| 33775 | 33775 | 245747 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 180 States St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6001087.3217 | 2106343.25573 | 37.763678192709605 | -122.43942040492901 | (37.7636781927096, -122.439420404929) | |||
| 34029 | 34029 | 182428 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1551 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985887.38 | 2104676.4366 | 37.7582248168708 | -122.49186881998699 | (37.7582248168708, -122.491868819987) | |||
| 34068 | 34068 | 118164 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3640 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5984224.54908 | 2111096.5750599997 | 37.77575536408371 | -122.498093648535 | (37.7757553640837, -122.498093648535) | |||
| 34195 | 34195 | 245674 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 940 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6001893.13408 | 2101250.5885 | 37.749740782017604 | -122.436268872035 | (37.7497407820176, -122.436268872035) | |||
| 34324 | 34324 | 182909 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2650 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982526.4517 | 2096517.0785 | 37.7356244692498 | -122.50288816885599 | (37.7356244692498, -122.502888168856) | |||
| 34332 | 34332 | 189296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 621 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011838.19125 | 2105389.54808 | 37.7616654928887 | -122.402169215947 | (37.7616654928887, -122.402169215947) | |||
| 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) | |||
| 34827 | 34827 | 48773 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 7777 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2002 12:00:00 AM | 20 | Permit Number 46030 | 5982884.108519999 | 2112361.52314 | 37.77914985913689 | -122.50282415167 | (37.7791498591369, -122.50282415167) | ||
| 35042 | 35042 | 118163 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3624 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5984301.57815 | 2111099.62261 | 37.7757682477987 | -122.497827414814 | (37.7757682477987, -122.497827414814) |
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");