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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184721 | 184721 | 101219 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012016.9704 | 2106218.6671 | 37.7639520461846 | -122.401609164037 | (37.7639520461846, -122.401609164037) | |||
| 180131 | 180131 | 43801 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 525 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43431 | 5988746.62136 | 2111728.0872299997 | 37.777753417998206 | -122.48249713450899 | (37.7777534179982, -122.482497134509) | |
| 180126 | 180126 | 58243 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1074 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 16 | Permit Number 19008 | 6015506.93589 | 2104104.58893 | 37.758341366580204 | -122.38939066713999 | (37.7583413665802, -122.38939066714) | ||
| 178877 | 178877 | 59611 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1053 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 11 | Permit Number 19013 | 6015558.09296 | 2104209.88833 | 37.758633332376704 | -122.389221094589 | (37.7586333323767, -122.389221094589) | ||
| 176805 | 176805 | 57127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 468 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 10 | Permit Number 18848 | 6014045.26968 | 2104987.99567 | 37.7606858631895 | -122.39450764863399 | (37.7606858631895, -122.394507648634) | ||
| 176780 | 176780 | 67047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2532 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1992 12:00:00 AM | 8 | Permit Number 30427 | 5988951.1175 | 2098070.1197 | 37.7402642171623 | -122.480789555517 | (37.7402642171623, -122.480789555517) | ||
| 176674 | 176674 | 31878 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3740 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35316 | 5996936.65811 | 2115356.47325 | 37.7881890469296 | -122.454427304671 | (37.7881890469296, -122.454427304671) | ||
| 175774 | 175774 | 31530 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35085 | 6011132.9028199995 | 2101918.55735 | 37.7520955300081 | -122.404364216429 | (37.7520955300081, -122.404364216429) | |
| 175248 | 175248 | 59607 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1069 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 17 | Permit Number 19009 | 6015565.5861599995 | 2104116.66963 | 37.7583777891326 | -122.38918867043999 | (37.7583777891326, -122.38918867044) | ||
| 174514 | 174514 | 49395 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483BRODERICK Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 6 | Permit Number 46348 | 6000704.8967 | 2114113.6763 | 37.7849920360606 | -122.44130066560699 | (37.7849920360606, -122.441300665607) | ||
| 171446 | 171446 | 45471 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44250 | 5987593.6437099995 | 2110560.6661900003 | 37.7744808674341 | -122.48639989849501 | (37.7744808674341, -122.486399898495) | |
| 171296 | 171296 | 52472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1038@ 12th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | Permit Number 48583 | 5992323.330569999 | 2111390.84025 | 37.777034850900606 | -122.470099615521 | (37.7770348509006, -122.470099615521) | |
| 169641 | 169641 | 32813 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 0 | Permit Number 37172 | 6000168.11066279 | 2110698.62439724 | 37.7755845864888 | -122.44291244402201 | (37.7755845864888, -122.442912444022) | ||
| 169158 | 169158 | 38901 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 164 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40715 | 5996940.8515 | 2113271.4959 | 37.7824644937943 | -122.45426213802 | (37.7824644937943, -122.45426213802) | |
| 169032 | 169032 | 66942 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 4 | Permit Number 30268 | 6007235.19224 | 2091579.2151400002 | 37.7234873977973 | -122.41711056590201 | (37.7234873977973, -122.417110565902) | ||
| 168730 | 168730 | 32810 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1763 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37169 | 5999413.3803 | 2110122.477 | 37.77395957486279 | -122.445481792777 | (37.7739595748628, -122.445481792777) |
| 168505 | 168505 | 46656 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 6 | Permit Number 44787 | 5989986.8778099995 | 2113120.4528799998 | 37.781648539642404 | -122.47830854187 | (37.7816485396424, -122.47830854187) | |
| 168492 | 168492 | 31705 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 456 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35207 | 5997530.3227 | 2107475.8595 | 37.766584963572996 | -122.45180460716401 | (37.766584963573, -122.451804607164) | |
| 168458 | 168458 | 59599 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1117 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 14 | Permit Number 19000 | 6015586.46491 | 2103801.69873 | 37.7575141036211 | -122.38909447005699 | (37.7575141036211, -122.389094470057) | ||
| 168454 | 168454 | 96089 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1101 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767146 | 6012237.5036 | 2103271.25294 | 37.7558714019501 | -122.400639334242 | (37.7558714019501, -122.400639334242) | |
| 167145 | 167145 | 58941 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1366 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 13 | Permit Number 18219 | 6011964.85898 | 2102013.4641 | 37.7524025792275 | -122.401493839477 | (37.7524025792275, -122.401493839477) | ||
| 166751 | 166751 | 59610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 19 | Permit Number 19012 | 6015498.92125 | 2104246.5894 | 37.7587308251729 | -122.389428301996 | (37.7587308251729, -122.389428301996) | ||
| 166387 | 166387 | 67337 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 639 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | 9 | Permit Number 30821 | 5993452.94224 | 2111127.09035 | 37.776375902741 | -122.46617279824899 | (37.776375902741, -122.466172798249) | |
| 165854 | 165854 | 58323 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2535 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1978 12:00:00 AM | 11 | Permit Number 17348 | 6004044.87416 | 2117496.37379 | 37.7944697628231 | -122.429986793678 | (37.7944697628231, -122.429986793678) | ||
| 164190 | 164190 | 32221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 615 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 11 | Permit Number 35542 | 6009696.62224 | 2100374.01527 | 37.7477741931343 | -122.409222129314 | (37.7477741931343, -122.409222129314) | |
| 164001 | 164001 | 56674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1371 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5984603.4838 | 2105851.1543 | 37.761375137437604 | -122.496395703433 | (37.7613751374376, -122.496395703433) | ||||
| 159617 | 159617 | 51644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 47930 | 6003258.6697 | 2113006.0531 | 37.7820959261745 | -122.43238629430701 | (37.7820959261745, -122.432386294307) | ||
| 159167 | 159167 | 59612 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1049 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2014 12:00:00 AM | 13 | Permit Number 19014 | 6015555.050530001 | 2104225.77952 | 37.758676797525 | -122.38923272642 | (37.758676797525, -122.38923272642) | ||
| 158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
| 157294 | 157294 | 59707 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1133 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19137 | 6015590.05369 | 2103684.27955 | 37.757191894493296 | -122.38907386028299 | (37.7571918944933, -122.389073860283) | ||
| 156910 | 156910 | 51645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003273.8297 | 2112901.0989 | 37.7818086078686 | -122.43232634946399 | (37.7818086078686, -122.432326349464) | |||
| 156880 | 156880 | 33828 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 7 | Permit Number 37844 | 6015588.22624 | 2103756.71192 | 37.757390677059 | -122.38908523761299 | (37.757390677059, -122.389085237613) | ||
| 156691 | 156691 | 106659 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 492 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x9 | 5993768.84062 | 2112215.6427700003 | 37.7793829957774 | -122.465159109631 | (37.7793829957774, -122.465159109631) | |||
| 155340 | 155340 | 66278 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1990 12:00:00 AM | 18 | Permit Number 29386 | 6002437.3174 | 2116458.1230200003 | 37.7915278222894 | -122.43547482192699 | (37.7915278222894, -122.435474821927) | ||
| 153718 | 153718 | 69330 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2119 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 4 | Permit Number 33413 | 5987433.342 | 2102324.8030000003 | 37.751858106926704 | -122.486349632544 | (37.7518581069267, -122.486349632544) | ||
| 153581 | 153581 | 59603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1109 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 13 | Permit Number 19004 | 6015581.75911 | 2103854.91189 | 37.7576599547603 | -122.38911446017599 | (37.7576599547603, -122.389114460176) | ||
| 153154 | 153154 | 32482 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 89 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 7 | 3x3 | Permit Number 36990 | 6000124.50964 | 2105955.15278 | 37.762557717473896 | -122.442722593195 | (37.7625577174739, -122.442722593195) |
| 150961 | 150961 | 38065 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2613 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 40257 | 5999511.4939 | 2113596.9939 | 37.7835053059124 | -122.445392280392 | (37.7835053059124, -122.445392280392) | |
| 150081 | 150081 | 59706 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1001 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19136 | 6015543.40178 | 2104492.11293 | 37.7594074463272 | -122.389291611327 | (37.7594074463272, -122.389291611327) | ||
| 149106 | 149106 | 101214 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012005.53818 | 2106423.45815 | 37.7645137186686 | -122.40166309997299 | (37.7645137186686, -122.401663099973) | |||
| 146864 | 146864 | 30369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1632 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1974 12:00:00 AM | 14 | Permit Number 14152 | 6013068.70069 | 2104759.9070200003 | 37.7600052436607 | -122.39786918403999 | (37.7600052436607, -122.39786918404) | ||
| 146669 | 146669 | 101221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012019.899180001 | 2106139.93997 | 37.763736042505 | -122.401593500559 | (37.763736042505, -122.401593500559) | |||
| 146082 | 146082 | 58491 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1978 12:00:00 AM | 4x4 | Permit Number 17662 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||
| 145871 | 145871 | 103166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 145248 | 145248 | 61069 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2011 12:00:00 AM | 3x3 | Permit Number 54089 | 6000057.45151415 | 2105676.05314863 | 37.7617875559763 | -122.442934478534 | (37.7617875559763, -122.442934478534) | ||
| 144947 | 144947 | 40139 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 217X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41403 | 6002772.91216813 | 2109249.02186594 | 37.7717524985867 | -122.433798178586 | (37.7717524985867, -122.433798178586) | |
| 144848 | 144848 | 50458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 144610 | 144610 | 70136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.738316654626395 | -122.41408448515101 | (37.7383166546264, -122.414084485151) | ||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 144573 | 144573 | 35413 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 144524 | 144524 | 84799 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49306 | 6003755.0 | 2096568.0 | 37.7369890856012 | -122.42949656641501 | (37.7369890856012, -122.429496566415) | |||
| 143920 | 143920 | 45696 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 143865 | 143865 | 53169 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 143864 | 143864 | 32929 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 3x3 | Permit Number 40482 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | ||
| 143577 | 143577 | 41674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
| 143570 | 143570 | 52276 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 69 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48438 | 6004677.30249487 | 2101602.8265641 | 37.7508657429158 | -122.426666180441 | (37.7508657429158, -122.426666180441) | ||
| 143118 | 143118 | 41675 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
| 143115 | 143115 | 32661 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 143009 | 143009 | 59112 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 671 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | 4x4 | Permit Number 18416 | 5993149.01942 | 2110913.66887 | 37.7757723653318 | -122.46720862222901 | (37.7757723653318, -122.467208622229) | |
| 142845 | 142845 | 117134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 142581 | 142581 | 50461 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 142269 | 142269 | 37049 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
| 142026 | 142026 | 37993 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 141934 | 141934 | 58614 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1052 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1979 12:00:00 AM | 3x3 | Permit Number 17828 | 5998153.64010117 | 2106679.35024276 | 37.764433630662204 | -122.449591270882 | (37.7644336306622, -122.449591270882) | ||
| 141853 | 141853 | 45694 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 141568 | 141568 | 535 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2578X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009729.93179 | 2102266.32124 | 37.7529719120351 | -122.409240459881 | (37.7529719120351, -122.409240459881) | |||
| 141526 | 141526 | 66940 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 633 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 8 | Permit Number 30266 | 6007221.66075 | 2091629.66903 | 37.7236251721365 | -122.417160915365 | (37.7236251721365, -122.417160915365) | ||
| 141275 | 141275 | 33842 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 141177 | 141177 | 45692 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 141126 | 141126 | 38270 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 140257 | 140257 | 32660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 139810 | 139810 | 45701 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 139257 | 139257 | 75814 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | |||
| 138407 | 138407 | 32931 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 135757 | 135757 | 68140 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2520 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 3 | Permit Number 31894 | 6000504.5856 | 2114139.1025 | 37.785050437079796 | -122.441995501898 | (37.7850504370798, -122.441995501898) | |
| 135547 | 135547 | 64458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Chabot Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1988 12:00:00 AM | 7 | Permit Number 25325 | 5997700.9521 | 2111423.6839 | 37.7774344440641 | -122.451499212614 | (37.7774344440641, -122.451499212614) | ||
| 135316 | 135316 | 60501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1988 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1982 12:00:00 AM | 15 | Permit Number 20100 | 6004700.44951 | 2117099.10485 | 37.793416068552396 | -122.427690103237 | (37.7934160685524, -122.427690103237) | ||
| 135179 | 135179 | 59708 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1010 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19138 | 6015489.89793 | 2104400.82935 | 37.7591538347945 | -122.389470280533 | (37.7591538347945, -122.389470280533) | ||
| 134959 | 134959 | 68463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 8 | Permit Number 32325 | 5991519.12103 | 2113131.34732 | 37.781767281646204 | -122.473008553548 | (37.7817672816462, -122.473008553548) | |
| 134840 | 134840 | 59231 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 732 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1980 12:00:00 AM | 14 | Permit Number 18553 | 5994760.56149 | 2110552.22329 | 37.7748728265586 | -122.46160772076401 | (37.7748728265586, -122.461607720764) | ||
| 133382 | 133382 | 54592 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 329 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 13 | 7x6 | Permit Number 10415 | 6014074.3359 | 2105511.64681 | 37.7621253108683 | -122.394443787777 | (37.7621253108683, -122.394443787777) | |
| 130687 | 130687 | 38879 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40702 | 5996216.25426 | 2115095.08483 | 37.7874300029464 | -122.456900851289 | (37.7874300029464, -122.456900851289) | |
| 130428 | 130428 | 59095 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 671 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18396 | 5994079.76607 | 2110941.26812 | 37.775901829120606 | -122.463990963797 | (37.7759018291206, -122.463990963797) | ||
| 129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 129182 | 129182 | 62460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1985 12:00:00 AM | Permit Number 22628 | 5994209.59395504 | 2092281.24653849 | 37.724673635737 | -122.46218826108101 | (37.724673635737, -122.462188261081) | |||
| 128515 | 128515 | 48660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1518 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51136 | 5993396.16596973 | 2105141.2714508 | 37.7599371524818 | -122.465934158818 | (37.7599371524818, -122.465934158818) | ||
| 128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
| 128045 | 128045 | 103161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||||
| 127747 | 127747 | 92232 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49975 | 6015152.0 | 2105524.0 | 37.762219079001795 | -122.390717392856 | (37.7622190790018, -122.390717392856) | |||
| 127577 | 127577 | 97501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 127573 | 127573 | 50460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 126936 | 126936 | 52650 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187@ RIVOLI Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | Permit Number 48734 | 5997369.46824352 | 2105989.04982963 | 37.7624933485057 | -122.452253677885 | (37.7624933485057, -122.452253677885) | |||
| 126870 | 126870 | 32667 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 125728 | 125728 | 108999 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 699X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 773694 | 6011413.0 | 2108471.0 | 37.7701027222045 | -122.403856631371 | (37.7701027222045, -122.403856631371) | |
| 124985 | 124985 | 61872 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3470 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 5 | 3x3 | Permit Number 29807 | 6005234.62338146 | 2103733.09182916 | 37.7567464486869 | -122.424890452857 | (37.7567464486869, -122.424890452857) | |
| 124836 | 124836 | 37755 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1182 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40102 | 6008642.9285748005 | 2101663.94572247 | 37.7512569652384 | -122.41295695053101 | (37.7512569652384, -122.412956950531) | ||
| 124802 | 124802 | 32662 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 124554 | 124554 | 33846 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 124510 | 124510 | 33843 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 124167 | 124167 | 44786 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2818 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43882. Basin expansion 5'9" x 8'7" | 6009323.53333837 | 2103374.60250597 | 37.7559922269102 | -122.410724131124 | (37.7559922269102, -122.410724131124) |
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");