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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81490 | 81490 | 62008 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1985 12:00:00 AM | Permit Number 22077 | 6003692.18423041 | 2120397.09224754 | 37.8024144061446 | -122.431414313869 | (37.8024144061446, -122.431414313869) | ||
| 81491 | 81491 | 63452 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 425 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30038 | 6006658.37862364 | 2096248.30501412 | 37.7362752333103 | -122.419435593969 | (37.7362752333103, -122.419435593969) | ||
| 81643 | 81643 | 11276 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 81756 | 81756 | 97781 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 249 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | strip | 5992441.6 | 2097612.4 | 37.7392096976829 | -122.468687674985 | (37.7392096976829, -122.468687674985) | |||
| 81860 | 81860 | 107385 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2518X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:45:00 AM | 3 | 3x3 | 6002277.0 | 2097180.0 | 37.738585702213996 | -122.434650415337 | (37.738585702214, -122.434650415337) | ||
| 82160 | 82160 | 12018 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 82194 | 82194 | 109085 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
| 82770 | 82770 | 25448 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 82837 | 82837 | 62309 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 197 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22447 | 5996603.44612338 | 2111537.89783115 | 37.7776851364685 | -122.45530408152 | (37.7776851364685, -122.45530408152) | ||
| 82877 | 82877 | 12490 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 82914 | 82914 | 67118 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30538 | 5998791.80760997 | 2105372.50995466 | 37.7608818625197 | -122.44728997041 | (37.7608818625197, -122.44728997041) | ||
| 83291 | 83291 | 12008 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 83388 | 83388 | 35531 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 90 Bartlett St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38922 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 83877 | 83877 | 67842 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31510 | 6004840.52212153 | 2100493.06857021 | 37.7478278305843 | -122.426022759795 | (37.7478278305843, -122.426022759795) | ||
| 84312 | 84312 | 49473 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1300 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2003 12:00:00 AM | 3x3 | Permit Number 46398 | 5992038.44394874 | 2098453.2514756 | 37.7414951640526 | -122.47014280690901 | (37.7414951640526, -122.470142806909) | ||
| 85051 | 85051 | 107853 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
| 85272 | 85272 | 9290 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 22 George Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017267.4584317 | 2094080.8187147 | 37.7309155826614 | -122.38260447080299 | (37.7309155826614, -122.382604470803) | |||
| 85692 | 85692 | 63202 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.094069201 | 2112837.90974399 | 37.78056150785579 | -122.496750144554 | (37.7805615078558, -122.496750144554) | ||
| 85734 | 85734 | 24064 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 85830 | 85830 | 32711 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 920 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44986 | 6007431.49416975 | 2114487.39461752 | 37.786399059728396 | -122.41805522728599 | (37.7863990597284, -122.418055227286) | ||
| 86223 | 86223 | 33221 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 130 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | ||
| 86597 | 86597 | 102294 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1500 Michigan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016449.0 | 2101073.5 | 37.7500708170088 | -122.38592128356701 | (37.7500708170088, -122.385921283567) | ||||
| 86863 | 86863 | 61680 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 67 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21677 | 6013883.88231185 | 2093810.46965069 | 37.7299857582394 | -122.39428321764 | (37.7299857582394, -122.39428321764) | ||
| 87121 | 87121 | 109844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x5 | 6012019.0 | 2117742.0 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | |||
| 87198 | 87198 | 11271 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 87247 | 87247 | 95380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 87477 | 87477 | 91084 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4055 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824.0 | 2101802.0 | 37.751307673555395 | -122.433089295463 | (37.7513076735554, -122.433089295463) | ||
| 87873 | 87873 | 12038 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1250X La Salle Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 88047 | 88047 | 68834 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 213 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32785 | 5999328.0521661 | 2094050.43857188 | 37.7298248100363 | -122.444621556754 | (37.7298248100363, -122.444621556754) | ||
| 88193 | 88193 | 66803 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.769198696470006 | -122.42096001468201 | (37.76919869647, -122.420960014682) | ||
| 88326 | 88326 | 109852 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
| 88340 | 88340 | 11272 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 88646 | 88646 | 69470 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1570 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33586 | 5991155.36555461 | 2104799.07062441 | 37.75886803765071 | -122.47365896033001 | (37.7588680376507, -122.47365896033) | ||
| 88878 | 88878 | 56525 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24366 | 5993992.30583295 | 2104307.94730884 | 37.7576834321386 | -122.463811929837 | (37.7576834321386, -122.463811929837) | ||
| 89065 | 89065 | 95379 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 89113 | 89113 | 60659 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 230 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20293 | 6004386.7781208 | 2097051.60858115 | 37.7383527156426 | -122.42734666633999 | (37.7383527156426, -122.42734666634) | ||
| 90102 | 90102 | 92012 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | ||||
| 91133 | 91133 | 11969 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 960X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6015772.64696 | 2096469.87167 | 37.7373927489725 | -122.387938970322 | (37.7373927489725, -122.387938970322) | |||
| 91420 | 91420 | 53072 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 530@ CAPITOL Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | ||
| 91579 | 91579 | 109086 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
| 91742 | 91742 | 67301 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1992 12:00:00 AM | Permit Number 30782 | 5997564.33795756 | 2107830.91613748 | 37.7675618065748 | -122.451712570063 | (37.7675618065748, -122.451712570063) | |||
| 91878 | 91878 | 109496 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 342 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004048.2 | 2103384.6 | 37.755722487303295 | -122.428968694341 | (37.7557224873033, -122.428968694341) | ||||
| 92365 | 92365 | 11339 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 92405 | 92405 | 17264 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 35 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017206.9997371 | 2094294.0023377 | 37.73149760272761 | -122.38282831855 | (37.7314976027276, -122.38282831855) | |||
| 92462 | 92462 | 110177 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
| 92760 | 92760 | 12019 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1250X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
| 92809 | 92809 | 60776 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1619 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31531 | 6003372.01868235 | 2098812.50590148 | 37.7431302912001 | -122.430980846877 | (37.7431302912001, -122.430980846877) | ||
| 92852 | 92852 | 32999 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 92881 | 92881 | 11274 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 92976 | 92976 | 17269 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 47 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017166.42434 | 2094311.14519 | 37.731542431743 | -122.382969789508 | (37.731542431743, -122.382969789508) | |||
| 93072 | 93072 | 65615 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 907 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | Permit Number 28522 | 6001416.70920324 | 2088928.18069936 | 37.71587921156971 | -122.43703426598101 | (37.7158792115697, -122.437034265981) | ||
| 93083 | 93083 | 34702 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 546 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38359 | 5981647.34162822 | 2112027.92469202 | 37.7781611337001 | -122.50707780583099 | (37.7781611337001, -122.507077805831) | ||
| 93127 | 93127 | 26775 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 800X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 93701 | 93701 | 40165 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 556 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41358 | 6002795.8683083 | 2102135.2617094 | 37.7522211355172 | -122.433210387902 | (37.7522211355172, -122.433210387902) | ||
| 93782 | 93782 | 56208 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 232 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1995 12:00:00 AM | Permit Number 12328 | 6007936.60722908 | 2100249.03484728 | 37.7473322642805 | -122.41529934331601 | (37.7473322642805, -122.415299343316) | ||
| 94436 | 94436 | 24061 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 94515 | 94515 | 107708 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
| 94524 | 94524 | 112418 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | ||||
| 94623 | 94623 | 11320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1216X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/1999 12:00:00 AM | 3 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 94650 | 94650 | 61652 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21641 | 5993002.2450542 | 2114941.18121592 | 37.7868223445778 | -122.468009369168 | (37.7868223445778, -122.468009369168) | ||
| 95658 | 95658 | 17262 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 30 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017260.6217082 | 2094327.801916 | 37.7315933721704 | -122.382645286292 | (37.7315933721704, -122.382645286292) | |||
| 95843 | 95843 | 101217 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011994.2 | 2106304.5 | 37.764186453503605 | -122.401693953948 | (37.7641864535036, -122.401693953948) | ||||
| 96019 | 96019 | 17259 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 25 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017276.1591118 | 2094269.688168 | 37.7314346616221 | -122.38258752773001 | (37.7314346616221, -122.38258752773) | |||
| 96237 | 96237 | 11349 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 96365 | 96365 | 32699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.41420647278099 | (37.7865240684083, -122.414206472781) | ||
| 96390 | 96390 | 11261 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1145X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 96443 | 96443 | 12011 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 96919 | 96919 | 66246 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29346 | 5995210.96497601 | 2091915.27509183 | 37.7237263724293 | -122.458700188143 | (37.7237263724293, -122.458700188143) | ||
| 96952 | 96952 | 11557 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 830X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015930.31003 | 2096671.7579 | 37.737955820868294 | -122.38740793019 | (37.7379558208683, -122.38740793019) | |||
| 97012 | 97012 | 68706 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3727 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32714 | 6004057.02264849 | 2105954.86981245 | 37.7627803365256 | -122.42912143882099 | (37.7627803365256, -122.429121438821) | ||
| 97138 | 97138 | 61114 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1116 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20961 | 6007611.65468316 | 2103146.29299754 | 37.7552692105316 | -122.416628217941 | (37.7552692105316, -122.416628217941) | ||
| 97302 | 97302 | 44123 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2007 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | Permit Number 43625 | 6003862.36561668 | 2115304.31925422 | 37.7884406009287 | -122.43046181544099 | (37.7884406009287, -122.430461815441) | ||
| 97470 | 97470 | 11281 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 97973 | 97973 | 11291 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 98028 | 98028 | 17263 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 35 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017206.9997371 | 2094294.0023377 | 37.73149760272761 | -122.38282831855 | (37.7314976027276, -122.38282831855) | |||
| 98052 | 98052 | 60695 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2901 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20340 | 6008888.31014725 | 2103298.66329221 | 37.75575930319879 | -122.41222391568998 | (37.7557593031988, -122.41222391569) | ||
| 98243 | 98243 | 65552 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28451 | 5995547.56425531 | 2097511.07200024 | 37.7391104150803 | -122.457941385434 | (37.7391104150803, -122.457941385434) | ||
| 98297 | 98297 | 67812 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 950 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | Permit Number 31466 | 6003745.95469336 | 2102716.06929971 | 37.7538697471416 | -122.429966268708 | (37.7538697471416, -122.429966268708) | ||
| 98498 | 98498 | 109631 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 5989374.0 | 2093588.0 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | |||||
| 98604 | 98604 | 58502 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | Permit Number 17675 | 5999614.32190404 | 2108410.03271869 | 37.7692691057292 | -122.444663596269 | (37.7692691057292, -122.444663596269) | |||
| 98686 | 98686 | 9285 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
| 98847 | 98847 | 63361 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 431 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30041 | 6006645.62978775 | 2096239.24235854 | 37.736249631190205 | -122.419479029307 | (37.7362496311902, -122.419479029307) | ||
| 98975 | 98975 | 12084 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 99337 | 99337 | 29918 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 810 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | ||||
| 99687 | 99687 | 11344 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 99896 | 99896 | 20988 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2002X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 200 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 100492 | 100492 | 107709 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
| 100586 | 100586 | 66384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | ||
| 100642 | 100642 | 17279 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 75 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016964.0762842 | 2094462.847211 | 37.731947792828 | -122.383679910748 | (37.731947792828, -122.383679910748) | |||
| 100772 | 100772 | 63269 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 39 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23826 | 6006964.49512199 | 2099515.87189553 | 37.745264480969404 | -122.418608862279 | (37.7452644809694, -122.418608862279) | ||
| 100945 | 100945 | 12032 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1250X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 100989 | 100989 | 63496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1665 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31923 | 5993996.85139129 | 2104175.81914419 | 37.757320904245205 | -122.463786619524 | (37.7573209042452, -122.463786619524) | ||
| 101188 | 101188 | 17273 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 53 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017144.20686 | 2094317.06632 | 37.7315574623644 | -122.38304701235799 | (37.7315574623644, -122.383047012358) | |||
| 101277 | 101277 | 11316 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1216X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | |||
| 102045 | 102045 | 33222 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 130 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | ||
| 102148 | 102148 | 17270 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 47 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017170.52754 | 2094318.4941200002 | 37.7315628371719 | -122.382956115072 | (37.7315628371719, -122.382956115072) | |||
| 102323 | 102323 | 17274 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 60 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017079.314769 | 2094437.156895 | 37.731883621429205 | -122.383279715267 | (37.7318836214292, -122.383279715267) | |||
| 102443 | 102443 | 12071 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1225X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 102915 | 102915 | 102295 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1500 Michigan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016449.0 | 2101073.5 | 37.7500708170088 | -122.38592128356701 | (37.7500708170088, -122.385921283567) |
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");