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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54816 | 54816 | 57900 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.77501283944979 | -122.438279288937 | (37.7750128394498, -122.438279288937) | ||
| 157293 | 157293 | 60204 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1982 12:00:00 AM | 8 | 4x4 | Permit Number 19750 | 6012229.2906 | 2107053.9352 | 37.766257350909704 | -122.400933496957 | (37.7662573509097, -122.400933496957) | |
| 117733 | 117733 | 62050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120.0 | 2108416.0 | 37.769767186200795 | -122.41524321981701 | (37.7697671862008, -122.415243219817) | ||
| 156017 | 156017 | 63197 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 472 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23738 | 5984415.8334099995 | 2112620.0121299997 | 37.7799494956437 | -122.49754445897301 | (37.7799494956437, -122.497544458973) | |
| 18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
| 142933 | 142933 | 63531 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.41562041035299 | (37.7581133535123, -122.415620410353) | ||
| 146236 | 146236 | 63542 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | Permit Number 24157 | 6008220.818199201 | 2104530.13411616 | 37.7591031640479 | -122.414619465951 | (37.7591031640479, -122.414619465951) | ||
| 125170 | 125170 | 63543 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.43881084154499 | (37.7786186676026, -122.438810841545) | ||
| 160212 | 160212 | 63573 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1500@Polk Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 49344 | 6006306.38676 | 2118003.57118 | 37.795990216032294 | -122.422197721351 | (37.7959902160323, -122.422197721351) | |
| 82313 | 82313 | 64622 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1988 12:00:00 AM | Permit Number 25527 | 6006698.09280064 | 2104074.24597744 | 37.75776573278821 | -122.41985343647801 | (37.7577657327882, -122.419853436478) | ||
| 123673 | 123673 | 65048 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.41263312174401 | (37.7385429081789, -122.412633121744) | ||
| 116426 | 116426 | 65602 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.9135900002 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | |
| 101992 | 101992 | 66205 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1990 12:00:00 AM | Permit Number 29289 | 6010420.85602386 | 2100006.0506029 | 37.746804390663 | -122.406691826217 | (37.746804390663, -122.406691826217) | |||
| 54785 | 54785 | 66435 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776442 | 6005832.64379623 | 2096619.46427693 | 37.7372478105316 | -122.422316867971 | (37.7372478105316, -122.422316867971) | |
| 31101 | 31101 | 66988 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1445 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1992 12:00:00 AM | 12 | Permit Number 30339 | 6006117.71616 | 2118619.27503 | 37.7976701397196 | -122.422894339811 | (37.7976701397196, -122.422894339811) | ||
| 105088 | 105088 | 67713 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.782433074017504 | -122.392684800601 | (37.7824330740175, -122.392684800601) | ||
| 91227 | 91227 | 67800 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31444 | 6001831.31402978 | 2100620.67337741 | 37.7480076719463 | -122.43643756932501 | (37.7480076719463, -122.436437569325) | ||
| 95230 | 95230 | 67807 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | ||
| 87568 | 87568 | 67821 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 669 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1993 12:00:00 AM | Permit Number 31477 | 6014155.20534869 | 2104021.00071857 | 37.7580368157249 | -122.394059730987 | (37.7580368157249, -122.394059730987) | ||
| 86818 | 86818 | 68587 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 32485 | 6003450.61209517 | 2097770.88653532 | 37.7402746975659 | -122.430634780555 | (37.7402746975659, -122.430634780555) | ||
| 93469 | 93469 | 69068 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.76177273191679 | -122.471616117782 | (37.7617727319168, -122.471616117782) | ||
| 68713 | 68713 | 69181 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1335 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 12 | Permit Number 33220 | 5982114.4178 | 2105957.0803 | 37.761519851873295 | -122.505012044902 | (37.7615198518733, -122.505012044902) | |
| 188342 | 188342 | 70057 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014037.2583099995 | 2095146.8497099997 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | ||
| 145218 | 145218 | 71944 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1342 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 50253 | 6008035.06455956 | 2100432.68279191 | 37.7478420534954 | -122.414971880187 | (37.7478420534954, -122.414971880187) | ||
| 73423 | 73423 | 72214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014033.56934 | 2095149.8862 | 37.7336718422767 | -122.39385944784901 | (37.7336718422767, -122.393859447849) | ||
| 145835 | 145835 | 80165 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 141713 | 141713 | 82360 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 164545 | 164545 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/28/2005 12:00:00 AM | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | ||
| 80153 | 80153 | 82685 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 35 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52459 | 6012802.99497586 | 2089176.16957459 | 37.7172007679129 | -122.397695078281 | (37.7172007679129, -122.397695078281) | ||
| 163040 | 163040 | 82715 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 11 | 3x3 | Permit Number 52465 | 6016442.9825 | 2093699.9014 | 37.7298240779238 | -122.385428311894 | (37.7298240779238, -122.385428311894) | |
| 137872 | 137872 | 82840 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52465 | 6016423.5899 | 2093711.7525 | 37.729855545757 | -122.38549618052299 | (37.729855545757, -122.385496180523) | |
| 29943 | 29943 | 83166 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1089 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52361 | 6015096.6014 | 2089812.1317 | 37.719074451264 | -122.389811494874 | (37.719074451264, -122.389811494874) | |
| 47070 | 47070 | 83362 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51120 | 5982822.4546 | 2100126.935 | 37.745553538391206 | -122.50213183404101 | (37.7455535383912, -122.502131834041) | |
| 114868 | 114868 | 83791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | ||
| 101513 | 101513 | 83941 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 60 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.41460830425899 | (37.7696248364946, -122.414608304259) | ||
| 127065 | 127065 | 84127 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 88 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50980 | 6010360.09243836 | 2089687.02520781 | 37.7184671339256 | -122.406175049692 | (37.7184671339256, -122.406175049692) | ||
| 75251 | 75251 | 84928 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1500@Polk Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 6 | Permit Number 49344 | 6006295.343780001 | 2118001.00844 | 37.79598255651371 | -122.422235750095 | (37.7959825565137, -122.422235750095) | ||
| 103766 | 103766 | 85491 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641.0 | 2101716.0 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | |||
| 6671 | 6671 | 87391 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.43605331890801 | (37.800247665053, -122.436053318908) | |
| 6292 | 6292 | 87392 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002333.63287 | 2119648.2941900003 | 37.800281314083705 | -122.43606195061199 | (37.8002813140837, -122.436061950612) | |
| 145082 | 145082 | 88286 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51287 | 6007754.0 | 2106536.0 | 37.7645845697556 | -122.416376026653 | (37.7645845697556, -122.416376026653) | ||
| 124789 | 124789 | 88372 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306.0 | 2109414.0 | 37.77257404455771 | -122.411211370961 | (37.7725740445577, -122.411211370961) | ||
| 97141 | 97141 | 88373 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306.0 | 2109414.0 | 37.77257404455771 | -122.411211370961 | (37.7725740445577, -122.411211370961) | ||
| 140792 | 140792 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6007547.0 | 2093670.0 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | |||||
| 44829 | 44829 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 107188 | 107188 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 90667 | 90667 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 109559 | 109559 | 98644 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008222.0 | 2104509.0 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | |||
| 112993 | 112993 | 99104 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006000.9 | 2104423.0 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | ||||
| 121741 | 121741 | 99249 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 435 Paul Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2012 12:00:00 AM | 3x3 | Permit Number 769233 | 6012286.9 | 2091380.6 | 37.7232249352354 | -122.399633675727 | (37.7232249352354, -122.399633675727) | ||
| 87848 | 87848 | 100205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091.0 | 2104064.0 | 37.757533730328205 | -122.43232751517901 | (37.7575337303282, -122.432327515179) | |
| 87668 | 87668 | 103568 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.76430954658429 | -122.45314559026801 | (37.7643095465843, -122.453145590268) | |||
| 87190 | 87190 | 106452 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 56 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 3 | Permit Number 772906 | 6014092.7 | 2093830.3 | 37.7300518134974 | -122.393562691323 | (37.7300518134974, -122.393562691323) | ||
| 173453 | 173453 | 106777 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/03/2014 12:00:00 AM | 5 | Permit Number 773142 | 6012265.00001 | 2102937.69671 | 37.7549570630325 | -122.400520812589 | (37.7549570630325, -122.400520812589) | ||
| 118491 | 118491 | 106781 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/03/2014 12:00:00 AM | Permit Number 773142 | 6012276.4 | 2102941.5 | 37.7549681417933 | -122.400481655091 | (37.7549681417933, -122.400481655091) | |||
| 113940 | 113940 | 107411 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006068.0 | 2104353.0 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | ||||
| 120475 | 120475 | 108220 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 105965 | 105965 | 108221 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 129363 | 129363 | 108222 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 145642 | 145642 | 108223 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118122 | 118122 | 108224 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 100434 | 100434 | 108225 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 142472 | 142472 | 108226 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118194 | 118194 | 108227 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 106980 | 106980 | 108282 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 96207 | 96207 | 108286 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 80952 | 80952 | 109314 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 116911 | 116911 | 109315 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 53611 | 53611 | 109316 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 81156 | 81156 | 109317 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 127307 | 127307 | 110182 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 339 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 776744 | 6006513.8 | 2097161.9 | 37.7387756178582 | -122.420000276005 | (37.7387756178582, -122.420000276005) | ||
| 34945 | 34945 | 113776 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | |||
| 69093 | 69093 | 114917 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 86 Carr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 8 | Permit 774770 | 6012955.87899 | 2090602.59506 | 37.721125958889104 | -122.397266597771 | (37.7211259588891, -122.397266597771) | ||
| 59569 | 59569 | 115612 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012209.3182 | 2107055.3618 | 37.7662601539356 | -122.401002678345 | (37.7662601539356, -122.401002678345) | |||
| 172140 | 172140 | 115615 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.40148722008699 | (37.766226213653, -122.401487220087) | |||
| 110007 | 110007 | 115616 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 107827 | 107827 | 115617 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110112 | 110112 | 115632 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012114.0 | 2107494.0 | 37.7674592382642 | -122.40136319642001 | (37.7674592382642, -122.40136319642) | ||||
| 98438 | 98438 | 117606 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 128524 | 128524 | 117607 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 164340 | 164340 | 117703 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983084.790030001 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) | |||
| 24481 | 24481 | 117708 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983029.04687 | 2113077.7485700003 | 37.7811249212832 | -122.50237578006501 | (37.7811249212832, -122.502375780065) | |||
| 44646 | 44646 | 119965 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 518 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5987217.06494 | 2112373.1551 | 37.7794354929176 | -122.48783573328801 | (37.7794354929176, -122.487835733288) | |||
| 122229 | 122229 | 123216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.46706267834298 | (37.7760886204879, -122.467062678343) | |||
| 159970 | 159970 | 124330 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995934.0004900005 | 2113471.95009 | 37.782957097905395 | -122.457759890544 | (37.7829570979054, -122.457759890544) | |||
| 129978 | 129978 | 136740 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1920 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6000976.885419999 | 2121020.42839 | 37.8039716578185 | -122.44085530385 | (37.8039716578185, -122.44085530385) | |||
| 151347 | 151347 | 136741 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000055.17715 | 2118534.1134099998 | 37.797092364871794 | -122.44386618458701 | (37.7970923648718, -122.443866184587) | |||
| 26722 | 26722 | 136742 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000053.33945 | 2118542.13589 | 37.79711428765071 | -122.443873120143 | (37.7971142876507, -122.443873120143) | |||
| 109031 | 109031 | 136743 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6000050.877859999 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | |||
| 178056 | 178056 | 136744 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.44389766175101 | (37.7972226334754, -122.443897661751) | |||
| 37691 | 37691 | 136745 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2908 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000044.84961 | 2118592.59728 | 37.797252356970205 | -122.44390612438801 | (37.7972523569702, -122.443906124388) | |||
| 35806 | 35806 | 136746 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.44391313370501 | (37.7972879782152, -122.443913133705) | |||
| 27899 | 27899 | 136747 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2859 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999233.55999 | 2118349.36625 | 37.796538199022606 | -122.446695870812 | (37.7965381990226, -122.446695870812) | |||
| 157611 | 157611 | 136748 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.80559494132721 | -122.43493757052299 | (37.8055949413272, -122.434937570523) | |||
| 175537 | 175537 | 136749 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1360 Jones St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008500.72583 | 2117239.96883 | 37.794017078290295 | -122.41455079677701 | (37.7940170782903, -122.414550796777) | |||
| 153492 | 153492 | 136750 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6007528.1043 | 2119564.5184299997 | 37.8003450211571 | -122.41808104771299 | (37.8003450211571, -122.418081047713) | |||
| 65216 | 65216 | 136751 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837521999 | (37.8003111329029, -122.41833837522) | |||
| 136649 | 136649 | 141332 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1324 HAYES ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6001489.2623 | 2110460.5875 | 37.7750062304087 | -122.43832521117099 | (37.7750062304087, -122.438325211171) | |||
| 162786 | 162786 | 143059 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.40702659346701 | (37.8026814253217, -122.407026593467) | |||
| 51116 | 51116 | 179953 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Peabody St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009701.772480001 | 2086128.1297 | 37.708658289510204 | -122.408199733244 | (37.7086582895102, -122.408199733244) |
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");