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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18187 | 18187 | 40261 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3543 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/2005 12:00:00 AM | Permit Number 47928 | 6005992.45992589 | 2101968.12777251 | 37.751943042038704 | -122.422144186794 | (37.7519430420387, -122.422144186794) | ||
| 19504 | 19504 | 52712 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 53@ FAIR AVE Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2006 12:00:00 AM | Permit Number 48768 | 6006913.27477728 | 2099421.81000315 | 37.745003324352204 | -122.418779304454 | (37.7450033243522, -122.418779304454) | ||
| 26478 | 26478 | 63265 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | |
| 40004 | 40004 | 34491 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1723 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38214 | 6009344.79247114 | 2099429.66611089 | 37.745161501342295 | -122.410372074504 | (37.7451615013423, -122.410372074504) | ||
| 50313 | 50313 | 69180 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | |
| 69668 | 69668 | 66337 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | |
| 77778 | 77778 | 64888 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2418 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25914 | 5989547.06003251 | 2098884.34921412 | 37.742534500381105 | -122.478788583135 | (37.7425345003811, -122.478788583135) | ||
| 81361 | 81361 | 63362 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 401 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30039 | 6006709.37395927 | 2096284.55563078 | 37.7363776416136 | -122.41926185234301 | (37.7363776416136, -122.419261852343) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 103396 | 103396 | 64118 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 402 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24889 | 6003939.69845123 | 2098396.37778582 | 37.7420198489818 | -122.428988299782 | (37.7420198489818, -122.428988299782) | ||
| 103815 | 103815 | 62431 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4402 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22591 | 5999916.26807627 | 2105779.65094566 | 37.76206395953 | -122.443430215898 | (37.76206395953, -122.443430215898) | ||
| 104468 | 104468 | 69209 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1013 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33260 | 6008042.23882633 | 2102024.29023495 | 37.7522126526326 | -122.41505971183399 | (37.7522126526326, -122.415059711834) | ||
| 104919 | 104919 | 63183 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | ||
| 105376 | 105376 | 65395 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1199 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | Permit Number 28618 | 6006415.64200439 | 2102619.79399643 | 37.7537562275815 | -122.42072701829599 | (37.7537562275815, -122.420727018296) | ||
| 105810 | 105810 | 63112 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 9 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1986 12:00:00 AM | Permit Number 23616 | 6007066.07091245 | 2099699.59516801 | 37.7457746619282 | -122.418270653095 | (37.7457746619282, -122.418270653095) | ||
| 106074 | 106074 | 54919 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 706 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | Permit Number 10786 | 6016194.08804658 | 2097035.77874441 | 37.7389699539681 | -122.386521286334 | (37.7389699539681, -122.386521286334) | ||
| 106325 | 106325 | 69542 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 775 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 8 | Permit Number 38643 | 6001970.16460074 | 2089302.5400568 | 37.71693856245 | -122.43514802944901 | (37.71693856245, -122.435148029449) | |
| 106823 | 106823 | 65482 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | Permit Number 28366 | 5994743.29707293 | 2091977.51972285 | 37.7238703903851 | -122.46032133316601 | (37.7238703903851, -122.460321333166) | ||
| 108589 | 108589 | 61664 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4900 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | Permit Number 21660 | 5992426.26787439 | 2114159.4357735002 | 37.7846426083195 | -122.46994515741699 | (37.7846426083195, -122.469945157417) | ||
| 109451 | 109451 | 65553 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28452 | 5995572.37835094 | 2097534.90092934 | 37.739177269089495 | -122.45785731399599 | (37.7391772690895, -122.457857313996) | ||
| 109618 | 109618 | 63102 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 151 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37593 | 6006585.95318508 | 2098816.77496864 | 37.74332359922 | -122.41986820091002 | (37.74332359922, -122.41986820091) | ||
| 111480 | 111480 | 67105 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.46759589895201 | (37.765744243823, -122.467595898952) | ||
| 111909 | 111909 | 60551 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.49547903508801 | (37.7788321315722, -122.495479035088) | ||
| 112059 | 112059 | 66850 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.77477913877421 | -122.447569047166 | (37.7747791387742, -122.447569047166) | ||
| 114187 | 114187 | 32724 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.786936628069796 | -122.419638162258 | (37.7869366280698, -122.419638162258) | ||
| 114200 | 114200 | 50874 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2004 12:00:00 AM | Permit Number 47384 | 6007625.30066101 | 2102900.0062832 | 37.7545937308752 | -122.41656358052 | (37.7545937308752, -122.41656358052) | ||
| 114250 | 114250 | 65614 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.715940663173704 | -122.43699057256201 | (37.7159406631737, -122.436990572562) | |
| 114821 | 114821 | 63106 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 67 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1986 12:00:00 AM | Permit Number 23602 | 6006857.2853572 | 2099318.42969221 | 37.744716312649004 | -122.41896557522101 | (37.744716312649, -122.418965575221) | ||
| 117345 | 117345 | 51287 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.774114887360504 | -122.479912367003 | (37.7741148873605, -122.479912367003) | ||
| 118150 | 118150 | 68260 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | ||
| 119576 | 119576 | 68317 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.50731153380801 | (37.7492103807501, -122.507311533808) | ||
| 120912 | 120912 | 60707 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1059 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20357 | 6009209.04775492 | 2102998.94986664 | 37.754954349681 | -122.4110935285 | (37.754954349681, -122.4110935285) | ||
| 121437 | 121437 | 33220 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 130 Vasquez Ave | 3 | 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) | ||
| 121834 | 121834 | 69022 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | ||
| 122165 | 122165 | 62017 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | ||
| 122660 | 122660 | 66751 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | ||
| 123487 | 123487 | 62308 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 930@ Lorraine Ct Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22446 | 5996162.7133263005 | 2112267.41531283 | 37.77966290152 | -122.456881494589 | (37.77966290152, -122.456881494589) | ||
| 124637 | 124637 | 67497 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 143 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1999 12:00:00 AM | Permit Number 31025 | 5999134.28418924 | 2093760.51474913 | 37.7290176881307 | -122.445270595435 | (37.7290176881307, -122.445270595435) | ||
| 125188 | 125188 | 63363 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 339 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30042 | 6006824.56139145 | 2096444.26906016 | 37.736822665934 | -122.418874924172 | (37.736822665934, -122.418874924172) | ||
| 126005 | 126005 | 60557 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20167 | 5985081.30797731 | 2111459.74994128 | 37.776802733932 | -122.495156735304 | (37.776802733932, -122.495156735304) | ||
| 126825 | 126825 | 58101 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | ||
| 127079 | 127079 | 31998 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 501#302 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | Permit Number 35397 | 5993950.60803177 | 2114839.47908066 | 37.7865978192777 | -122.464720892381 | (37.7865978192777, -122.464720892381) | ||
| 127914 | 127914 | 60604 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 526 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | Permit Number 20226 | 6000645.93118316 | 2110758.39288593 | 37.7757759257469 | -122.441263840373 | (37.7757759257469, -122.441263840373) | ||
| 138298 | 138298 | 63136 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 75 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23653 | 6007261.8048924 | 2099033.40342516 | 37.7439564645667 | -122.417546624418 | (37.7439564645667, -122.417546624418) | ||
| 138463 | 138463 | 63705 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1679 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24365 | 5994000.03328261 | 2104083.32941502 | 37.757067134665 | -122.463768902449 | (37.757067134665, -122.463768902449) | ||
| 139101 | 139101 | 32831 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4259 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37188 | 6001527.35157379 | 2101718.97801883 | 37.7510060780925 | -122.437567299188 | (37.7510060780925, -122.437567299188) | ||
| 139722 | 139722 | 68255 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | ||
| 139769 | 139769 | 63699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | ||
| 139868 | 139868 | 52193 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2050x Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | 14 | Permit Number 48383 | 6003893.10220549 | 2115458.97047215 | 37.788866975157205 | -122.430366510079 | (37.7888669751572, -122.430366510079) | |
| 140807 | 140807 | 65605 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | ||
| 141175 | 141175 | 61115 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1106 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 20962 | 6007608.55332469 | 2103202.26724843 | 37.7554227286129 | -122.416642908427 | (37.7554227286129, -122.416642908427) | ||
| 141186 | 141186 | 61435 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.44387490382499 | (37.7589393153031, -122.443874903825) | |
| 141990 | 141990 | 61657 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158003 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | ||
| 142804 | 142804 | 32992 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 9 | 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) | ||
| 142893 | 142893 | 32990 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 11 | 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) | ||
| 142936 | 142936 | 55768 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2006 12:00:00 AM | Permit Number 48893 | 6004070.72244185 | 2102685.02755706 | 37.7538029009663 | -122.428840933443 | (37.7538029009663, -122.428840933443) | ||
| 143352 | 143352 | 32991 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 10 | 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) | ||
| 143548 | 143548 | 53071 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 530@ CAPITOL Grafton Ave | 2 | 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) | ||
| 144319 | 144319 | 63123 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | ||
| 144476 | 144476 | 64980 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.42345589064699 | (37.744768585112, -122.423455890647) | ||
| 145237 | 145237 | 65550 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | ||
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 160277 | 160277 | 66846 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | |
| 170536 | 170536 | 32593 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.158172799 | 2105866.8789552 | 37.7614725555795 | -122.49319192882099 | (37.7614725555795, -122.493191928821) |
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");