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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129190 | 129190 | 94659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 33748 | 33748 | 214024 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000768.15588 | 2094464.1173900003 | 37.7310427480136 | -122.43967261170201 | (37.7310427480136, -122.439672611702) | |||
| 122311 | 122311 | 95106 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54035 | 6003118.7 | 2094425.3 | 37.731069671805294 | -122.43154361449699 | (37.7310696718053, -122.431543614497) | |
| 72907 | 72907 | 214025 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.8435 | 2094480.0839900002 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | |||
| 48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
| 116622 | 116622 | 214030 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.565880001 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | |||
| 24847 | 24847 | 214027 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | |||
| 106194 | 106194 | 102595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) |
| 31765 | 31765 | 214029 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.59206 | 2094530.6160900001 | 37.7312231430208 | -122.43981069901301 | (37.7312231430208, -122.439810699013) | |||
| 30486 | 30486 | 214028 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.43967507764201 | (37.7312270433827, -122.439675077642) | |||
| 41529 | 41529 | 73403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003121.9233099995 | 2094558.5911 | 37.7314358416937 | -122.43154198316999 | (37.7314358416937, -122.43154198317) | ||
| 185623 | 185623 | 78275 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2000 12:00:00 AM | 7 | 6014137.61661 | 2094337.2388799998 | 37.7314462603177 | -122.39344287108901 | (37.7314462603177, -122.393442871089) | ||
| 142202 | 142202 | 70387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003118.96111 | 2094567.6101799998 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | ||
| 79175 | 79175 | 47698 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 297 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458917998 | 37.732285975496104 | -122.44191439219401 | (37.7322859754961, -122.441914392194) | ||
| 122443 | 122443 | 47699 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 297 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458917998 | 37.732285975496104 | -122.44191439219401 | (37.7322859754961, -122.441914392194) | |||
| 35987 | 35987 | 51788 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 339 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52292 | 6012718.572319999 | 2094804.9461700001 | 37.7326515416146 | -122.39838161323 | (37.7326515416146, -122.39838161323) | |
| 167372 | 167372 | 40008 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.6711099998 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | |
| 68843 | 68843 | 32524 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.733726737790796 | -122.416328859904 | (37.7337267377908, -122.416328859904) | |
| 60527 | 60527 | 32523 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | |
| 137888 | 137888 | 214039 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000414.26094 | 2095519.5651200002 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | |||
| 183550 | 183550 | 32520 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.0670900003 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) | |
| 40556 | 40556 | 32518 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | |
| 113170 | 113170 | 88439 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51403 | 6007580.0 | 2095463.0 | 37.7341708239465 | -122.416193557304 | (37.7341708239465, -122.416193557304) | |||
| 147065 | 147065 | 32517 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.734187007231796 | -122.41618038453998 | (37.7341870072318, -122.41618038454) | |
| 142043 | 142043 | 51741 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 700 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | Permit Number 48018 | 6007951.80914494 | 2095656.00646211 | 37.73472167706821 | -122.414921747465 | (37.7347216770682, -122.414921747465) | |||
| 112273 | 112273 | 66617 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 29820 | 6003370.78769204 | 2095896.23030716 | 37.7351227979483 | -122.430777034501 | (37.7351227979483, -122.430777034501) | ||
| 132831 | 132831 | 201725 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1915 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013561.8417 | 2095888.78027 | 37.735674466103795 | -122.39554210998199 | (37.7356744661038, -122.395542109982) | ||||
| 188261 | 188261 | 240405 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003457.25772 | 2096114.18055 | 37.735726138447795 | -122.43049362280199 | (37.7357261384478, -122.430493622802) | |||
| 91962 | 91962 | 41706 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42155 | 6001936.91803675 | 2096162.95952183 | 37.7357738321427 | -122.435753508421 | (37.7357738321427, -122.435753508421) | ||
| 130150 | 130150 | 240411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | |||
| 25257 | 25257 | 240410 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.43584024433599 | (37.735834211766, -122.435840244336) | |||
| 96051 | 96051 | 40031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | ||
| 86331 | 86331 | 40032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | ||
| 56315 | 56315 | 240406 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | |||
| 30553 | 30553 | 240407 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | |||
| 95358 | 95358 | 47718 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45513 | 6003399.03676128 | 2096258.54340471 | 37.7361192276447 | -122.430705213698 | (37.7361192276447, -122.430705213698) | ||
| 157900 | 157900 | 240389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.41163431247601 | (37.7362484143157, -122.411634312476) | |||
| 81988 | 81988 | 69511 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.41158848323201 | (37.736290754505, -122.411588483232) | ||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 177305 | 177305 | 240408 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 180 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001780.1737 | 2096439.35558 | 37.7365238469964 | -122.436315208675 | (37.7365238469964, -122.436315208675) | |||
| 78865 | 78865 | 41694 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943005 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | ||
| 58739 | 58739 | 240420 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001790.0985900005 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | |||
| 75414 | 75414 | 240419 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001783.7465 | 2096493.5262099998 | 37.7366727900018 | -122.436306731665 | (37.7366727900018, -122.436306731665) | |||
| 75456 | 75456 | 240418 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001776.14511 | 2096508.8311299998 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | |||
| 73938 | 73938 | 240417 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001765.76464 | 2096530.8335799999 | 37.736774205667295 | -122.436371571893 | (37.7367742056673, -122.436371571893) | |||
| 88831 | 88831 | 41690 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107593998 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | ||
| 145210 | 145210 | 41691 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107593998 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | |||
| 125050 | 125050 | 240396 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 122 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005552.307130001 | 2096648.4643 | 37.737311620735895 | -122.42328818262301 | (37.7373116207359, -122.423288182623) | |||
| 62196 | 62196 | 240395 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005177.74113 | 2096695.2803099998 | 37.7374190204687 | -122.42458656083201 | (37.7374190204687, -122.424586560832) | |||
| 87056 | 87056 | 102078 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.737488929995706 | -122.42456464703699 | (37.7374889299957, -122.424564647037) |
| 95064 | 95064 | 41700 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 135 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42150 | 6002619.11270974 | 2096812.53264581 | 37.7375961375204 | -122.43344130209499 | (37.7375961375204, -122.433441302095) | ||
| 74383 | 74383 | 240409 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002196.797259999 | 2096967.0919299999 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | |||
| 136514 | 136514 | 35869 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.40561798198799 | (37.7381266097475, -122.405617981988) | |
| 137431 | 137431 | 35870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.738167912917106 | -122.405598135739 | (37.7381679129171, -122.405598135739) | |
| 120373 | 120373 | 35894 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 225 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | ||
| 27641 | 27641 | 240391 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006743.91028 | 2097051.2853599999 | 37.7384848564878 | -122.41919681678199 | (37.7384848564878, -122.419196816782) | |||
| 110717 | 110717 | 93721 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 143761 | 143761 | 93722 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 180367 | 180367 | 240385 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.738716455307795 | -122.41400861353 | (37.7387164553078, -122.41400861353) | |||
| 169762 | 169762 | 240386 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.738762289236895 | -122.41400415558998 | (37.7387622892369, -122.41400415559) | |||
| 164927 | 164927 | 240387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008249.57192 | 2097137.15027 | 37.7388053020181 | -122.41399702216002 | (37.7388053020181, -122.41399702216) | |||
| 143705 | 143705 | 13408 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 364 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 1553 | 1553 | 207056 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | |||
| 1559 | 1559 | 207057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991827.84816 | 2097768.2699700003 | 37.7396022020835 | -122.47082108403099 | (37.7396022020835, -122.470821084031) | |||
| 89712 | 89712 | 47995 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 118955 | 118955 | 47994 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 128723 | 128723 | 33551 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.740047898701604 | -122.418202822848 | (37.7400478987016, -122.418202822848) | |||
| 76501 | 76501 | 240390 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.740169467433894 | -122.42209730935801 | (37.7401694674339, -122.422097309358) | |||
| 43449 | 43449 | 69150 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.49728998800501 | (37.7402963417492, -122.497289988005) | |
| 182568 | 182568 | 33177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) |
| 183050 | 183050 | 69147 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.50014569422399 | (37.7405848112735, -122.500145694224) | |
| 83362 | 83362 | 63013 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | |
| 92257 | 92257 | 33453 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | |||
| 172123 | 172123 | 240382 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 200 Kingston St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6006224.51109 | 2098080.7337 | 37.7412822264814 | -122.4210657258 | (37.7412822264814, -122.4210657258) | ||||
| 99254 | 99254 | 38032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 102562 | 102562 | 38030 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 108435 | 108435 | 38031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 114634 | 114634 | 38033 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | ||
| 80857 | 80857 | 38028 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | |||
| 128574 | 128574 | 38029 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | ||
| 146231 | 146231 | 34936 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1997 12:00:00 AM | Permit Number 38531 | 6004292.24994663 | 2098281.86304207 | 37.741725367299104 | -122.427761131369 | (37.7417253672991, -122.427761131369) | |||
| 23461 | 23461 | 240416 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.43000177276899 | (37.7417367402568, -122.430001772769) | |||
| 99913 | 99913 | 38034 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | ||
| 90488 | 90488 | 57281 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | Permit Number 14578 | 5992015.46997478 | 2098642.50003897 | 37.7420134642029 | -122.470236020298 | (37.7420134642029, -122.470236020298) | ||
| 71181 | 71181 | 240388 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.742047422761296 | -122.413737549756 | (37.7420474227613, -122.413737549756) | |||
| 97169 | 97169 | 49152 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46274 | 5991742.04430079 | 2098660.96480908 | 37.7420483520093 | -122.47118277506901 | (37.7420483520093, -122.471182775069) | ||
| 66574 | 66574 | 214018 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991736.67899 | 2098669.28572 | 37.742070888761894 | -122.47120193253001 | (37.7420708887619, -122.47120193253) | |||
| 99110 | 99110 | 38000 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40212 | 5992064.31245936 | 2098735.51233127 | 37.742271675931896 | -122.47007391125601 | (37.7422716759319, -122.470073911256) | ||
| 172426 | 172426 | 240394 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.43744228675301 | (37.742482813337, -122.437442286753) | |||
| 5190 | 5190 | 253817 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001018.0 | 2098627.0 | 37.742487269754704 | -122.43910710368601 | (37.7424872697547, -122.439107103686) | ||||
| 50005 | 50005 | 181948 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1813 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987556.2457 | 2098923.5959 | 37.742526463070796 | -122.48567502435301 | (37.7425264630708, -122.485675024353) | |||
| 126995 | 126995 | 9330 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.502255901 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | ||
| 98414 | 98414 | 22550 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 23 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 4 | 2x3 | 6001475.729427099 | 2098645.6307198997 | 37.742564460006896 | -122.437525748228 | (37.7425644600069, -122.437525748228) | ||
| 102768 | 102768 | 88618 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1815 Taraval St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51591 | 5987609.0 | 2098941.0 | 37.7425773238376 | -122.485493894781 | (37.7425773238376, -122.485493894781) | ||
| 93181 | 93181 | 86997 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 248 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323.0 | 2098701.0 | 37.742877960826604 | -122.42768466378 | (37.7428779608266, -122.42768466378) | ||
| 95726 | 95726 | 23598 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) |
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");