Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120 | 120 | 110194 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2123 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774924 | 6001844.69538 | 2115843.7088 | 37.789807124247496 | -122.43748126425501 | (37.7898071242475, -122.437481264255) | |
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 641 | 641 | 5315 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1820 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1990 12:00:00 AM | 3 | 3X3 | 6001085.4403 | 2114655.5077 | 37.7865014360219 | -122.440022974412 | (37.7865014360219, -122.440022974412) | ||
| 847 | 847 | 107475 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.77116170781979 | -122.445609151717 | (37.7711617078198, -122.445609151717) | |||
| 1049 | 1049 | 110158 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.41456024686501 | (37.7968116091339, -122.414560246865) | ||
| 1174 | 1174 | 5198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001582.4984 | 2110645.9942 | 37.775520613317 | -122.43801597154 | (37.775520613317, -122.43801597154) | ||
| 1537 | 1537 | 107781 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000894.3565 | 2119181.32338 | 37.7989172637699 | -122.441008881075 | (37.7989172637699, -122.441008881075) | |
| 1546 | 1546 | 237042 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779999 | 6010308.84654 | 2103966.51965 | 37.757672694545896 | -122.407358302349 | (37.7576726945459, -122.407358302349) | |
| 1551 | 1551 | 28720 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004463.0033 | 2114982.1337 | 37.787589966374895 | -122.428360731182 | (37.7875899663749, -122.428360731182) | ||
| 1696 | 1696 | 108698 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) |
| 1943 | 1943 | 116843 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2571 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987034.8 | 2097780.1 | 37.7393563293641 | -122.487394029182 | (37.7393563293641, -122.487394029182) | |
| 1965 | 1965 | 123761 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994919.422180001 | 2110746.11008 | 37.7754143312074 | -122.461072248502 | (37.7754143312074, -122.461072248502) | |||
| 1991 | 1991 | 123758 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5994989.32477 | 2110751.87532 | 37.7754341833406 | -122.46083085861 | (37.7754341833406, -122.46083085861) | |||
| 2175 | 2175 | 57807 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2571 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987052.3077 | 2097770.09 | 37.7393298655452 | -122.487332761031 | (37.7393298655452, -122.487332761031) | |
| 2220 | 2220 | 129058 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011338.858519999 | 2117686.82601 | 37.795403078346894 | -122.40476199019501 | (37.7954030783469, -122.404761990195) | |
| 2221 | 2221 | 143495 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011293.9321 | 2117775.1194 | 37.795642999547894 | -122.40492366345501 | (37.7956429995479, -122.404923663455) | |
| 2224 | 2224 | 129056 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011415.91868 | 2117696.60349 | 37.7954342317671 | -122.40449603636299 | (37.7954342317671, -122.404496036363) | |
| 2227 | 2227 | 129057 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011354.55314 | 2117688.13829 | 37.7954075587569 | -122.404707776336 | (37.7954075587569, -122.404707776336) | |
| 2234 | 2234 | 143493 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011305.9671 | 2117702.4892 | 37.795444247241704 | -122.404876903904 | (37.7954442472417, -122.404876903904) | |
| 2236 | 2236 | 129059 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011327.666180001 | 2117687.2461 | 37.7954036062342 | -122.404800747351 | (37.7954036062342, -122.404800747351) | |
| 2238 | 2238 | 143494 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011299.0592 | 2117739.2293 | 37.7955447405749 | -122.40490339453999 | (37.7955447405749, -122.40490339454) | |
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2433 | 2433 | 201610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.9470099998 | 37.7286076240414 | -122.36989747059201 | (37.7286076240414, -122.369897470592) | |
| 2487 | 2487 | 33316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346001 | (37.8026370063559, -122.42893607346) | |
| 2731 | 2731 | 49968 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007921.5580400005 | 2112390.20722 | 37.7806682603601 | -122.416211138647 | (37.7806682603601, -122.416211138647) | |
| 2819 | 2819 | 226293 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 515 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | Width 2ft | Permit Number 50136 | 6003436.56035 | 2095955.2280000001 | 37.7352885184362 | -122.43055384320401 | (37.7352885184362, -122.430553843204) | |
| 2833 | 2833 | 226292 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/1994 12:00:00 AM | 3 | Width 2ft | Permit Number 29820 | 6003335.6733099995 | 2095877.19361 | 37.7350685379825 | -122.430897079359 | (37.7350685379825, -122.430897079359) | |
| 2883 | 2883 | 5188 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 506 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6001711.9462 | 2110180.0726 | 37.774248669965296 | -122.437534808127 | (37.7742486699653, -122.437534808127) | ||
| 2959 | 2959 | 228317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3 | Width 3ft | Permit Number 37770 | 6003543.433130001 | 2108799.0519999997 | 37.7705606845675 | -122.4311007758 | (37.7705606845675, -122.4311007758) | |
| 3091 | 3091 | 225736 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1040 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1985 12:00:00 AM | 5 | Width 4ft | Permit Number 22149 | 6003131.74859 | 2102203.56845 | 37.7524277377741 | -122.432053739685 | (37.7524277377741, -122.432053739685) | |
| 3273 | 3273 | 499 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | |
| 3517 | 3517 | 33317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.42888659453699 | (37.8026433303993, -122.428886594537) | |
| 4342 | 4342 | 53050 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1024 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767676 | 6009180.15933 | 2118047.86674 | 37.79627351507779 | -122.412257006676 | (37.7962735150778, -122.412257006676) |
| 4477 | 4477 | 110155 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.796841105086706 | -122.414334635748 | (37.7968411050867, -122.414334635748) | |
| 4755 | 4755 | 107780 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000893.56163 | 2119195.20013 | 37.7989553203824 | -122.441012627647 | (37.7989553203824, -122.441012627647) | |
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 4857 | 4857 | 94107 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006285.41191 | 2111071.65635 | 37.776955705176896 | -122.42177767860001 | (37.7769557051769, -122.4217776786) | |
| 4911 | 4911 | 107778 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.09266 | 2119225.96368 | 37.7990395913723 | -122.441026839613 | (37.7990395913723, -122.441026839613) | |
| 5251 | 5251 | 14528 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 647 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999145.2065 | 2110546.2822 | 37.775107922491706 | -122.446439942682 | (37.7751079224917, -122.446439942682) | |||
| 5343 | 5343 | 110157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.41443672767599 | (37.7968272906045, -122.414436727676) | ||
| 5379 | 5379 | 14477 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 12 | 3X3 | 5999009.9624 | 2111977.0325 | 37.7790286692875 | -122.44701076292299 | (37.7790286692875, -122.447010762923) | ||
| 5529 | 5529 | 49969 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007906.3079699995 | 2112391.06257 | 37.780669751438296 | -122.416263956709 | (37.7806697514383, -122.416263956709) | ||
| 5544 | 5544 | 94108 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006327.235669999 | 2111080.72521 | 37.7769829645232 | -122.42163364139799 | (37.7769829645232, -122.421633641398) | |
| 5734 | 5734 | 28721 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004471.9612 | 2114982.8802 | 37.7875925229583 | -122.428329791837 | (37.7875925229583, -122.428329791837) | ||
| 5948 | 5948 | 13140 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1997 12:00:00 AM | 18 | 3X3 | 6003874.8006 | 2119664.6973 | 37.8004137877384 | -122.430730076432 | (37.8004137877384, -122.430730076432) | ||
| 6043 | 6043 | 10681 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002358.7398 | 2110530.7348 | 37.7752482530433 | -122.435322523233 | (37.7752482530433, -122.435322523233) | |||
| 6080 | 6080 | 55912 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 801 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770168 | 6007877.21664 | 2120606.58742 | 37.803225923789604 | -122.416946850615 | (37.8032259237896, -122.416946850615) | |
| 6177 | 6177 | 14545 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999282.0507 | 2110078.3239 | 37.7738308435165 | -122.445932905938 | (37.7738308435165, -122.445932905938) | |||
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 6584 | 6584 | 10679 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002427.1981 | 2110540.5146 | 37.775278993428394 | -122.43508641032301 | (37.7752789934284, -122.435086410323) | |||
| 6627 | 6627 | 28722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004480.9191 | 2114982.5069999998 | 37.7875920051185 | -122.42829877265699 | (37.7875920051185, -122.428298772657) | ||
| 6731 | 6731 | 110156 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.41429181903601 | (37.7968393702849, -122.414291819036) | |
| 6832 | 6832 | 14547 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 810 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999284.7278 | 2110047.5378 | 37.7737464656007 | -122.4459214308 | (37.7737464656007, -122.4459214308) | |||
| 6864 | 6864 | 99895 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.5989599996 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | ||
| 6971 | 6971 | 53051 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1024 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51546 | 6009165.99693 | 2118045.4874299997 | 37.7962661873755 | -122.412305843439 | (37.7962661873755, -122.412305843439) | |
| 6985 | 6985 | 10684 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1161 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6002309.8411 | 2110524.4478 | 37.775228213443704 | -122.435491224879 | (37.7752282134437, -122.435491224879) | ||
| 7026 | 7026 | 94109 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.42156263632799 | (37.7769909819764, -122.421562636328) | |
| 7551 | 7551 | 108147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.43273393652399 | (37.800534134189, -122.432733936524) | ||
| 7767 | 7767 | 5249 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1135 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001356.9176 | 2112269.0905 | 37.7799643946727 | -122.438912650424 | (37.7799643946727, -122.438912650424) | ||
| 7929 | 7929 | 5252 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1149 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001343.3807 | 2112375.6934 | 37.7802563289851 | -122.43896712240499 | (37.7802563289851, -122.438967122405) | |||
| 7997 | 7997 | 107779 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.798998111943604 | -122.44102375853599 | (37.7989981119436, -122.441023758536) | |
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 8104 | 8104 | 21713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 3 | 4X4 | 6003349.0279 | 2114538.6375 | 37.786309140387395 | -122.432183179125 | (37.7863091403874, -122.432183179125) | ||
| 8113 | 8113 | 75258 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.41221149286699 | (37.7840518741506, -122.412211492867) | |||
| 8333 | 8333 | 94110 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006363.6521 | 2111083.4813 | 37.7769925854655 | -122.421507861308 | (37.7769925854655, -122.421507861308) | |
| 8352 | 8352 | 5316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1823 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 5 | 2X3 | 6001019.2169 | 2114657.038 | 37.786501867674495 | -122.44025220015699 | (37.7865018676745, -122.440252200157) | ||
| 8528 | 8528 | 28094 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 560 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001682.4646 | 2110397.1642 | 37.7748430729481 | -122.437652340718 | (37.7748430729481, -122.437652340718) | |||
| 9214 | 9214 | 6542 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6017765.684627299 | 2096901.7583544997 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | ||
| 9619 | 9619 | 17809 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004377.7264 | 2115455.3687 | 37.7888845248195 | -122.428689520238 | (37.7888845248195, -122.428689520238) | |||
| 10247 | 10247 | 46477 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10249 | 10249 | 46478 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10662 | 10662 | 109045 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773398 | 6004900.5728400005 | 2093457.84722 | 37.728514095441604 | -122.42531455034799 | (37.7285140954416, -122.425314550348) | |
| 10783 | 10783 | 109058 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.190219999 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) |
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12587 | 12587 | 40943 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 337 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773706 | 6001124.10704 | 2092689.0932900002 | 37.726189192361005 | -122.438314913304 | (37.726189192361, -122.438314913304) | |
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12794 | 12794 | 95013 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.40564982910401 | (37.7118779294401, -122.405649829104) | ||||
| 13338 | 13338 | 187686 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 388 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | 6005900.60365 | 2111761.43845 | 37.7788279713562 | -122.42315789265301 | (37.7788279713562, -122.423157892653) | |||
| 13449 | 13449 | 108720 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.25551 | 2106680.42507 | 37.765205936725295 | -122.40250878917 | (37.7652059367253, -122.40250878917) |
| 13649 | 13649 | 6451 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017878.64833 | 2096818.1638599997 | 37.738465537256495 | -122.38068166932399 | (37.7384655372565, -122.380681669324) | ||
| 13687 | 13687 | 50152 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 13731 | 13731 | 34850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1016 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1997 12:00:00 AM | 8 | Permit Number 38472 | 6015493.82496 | 2104313.14645 | 37.7589132940426 | -122.38945057548099 | (37.7589132940426, -122.389450575481) | ||
| 13805 | 13805 | 25987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1867 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6013610.36867 | 2096507.3445599999 | 37.7373756146805 | -122.39541765280701 | (37.7373756146805, -122.395417652807) | |||
| 13892 | 13892 | 108722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011765.777319999 | 2106711.15345 | 37.765290283256995 | -122.402512604068 | (37.765290283257, -122.402512604068) |
| 13976 | 13976 | 6449 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3X3 | 6017844.2154 | 2096842.4719 | 37.7385303819825 | -122.380802412295 | (37.7385303819825, -122.380802412295) | ||
| 13979 | 13979 | 25990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013804.269309999 | 2096361.3192200002 | 37.736985442024 | -122.39473701982 | (37.736985442024, -122.39473701982) | |||
| 14037 | 14037 | 6456 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2004 12:00:00 AM | 3 | 3X3 | 6017977.7328 | 2096742.9894400002 | 37.738264590924395 | -122.38033385651899 | (37.7382645909244, -122.380333856519) | ||
| 14108 | 14108 | 50151 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14271 | 14271 | 25992 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013845.47996 | 2096331.5621599997 | 37.7369060264874 | -122.39459245198299 | (37.7369060264874, -122.394592451983) | |||
| 14355 | 14355 | 39267 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.7135400004 | 37.7844122333873 | -122.39095143518499 | (37.7844122333873, -122.390951435185) |
| 14386 | 14386 | 108711 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011373.53842 | 2106528.5170299998 | 37.7647668994048 | -122.40385642054 | (37.7647668994048, -122.40385642054) |
| 14541 | 14541 | 25985 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1899 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6013478.7737300005 | 2096605.16178 | 37.737636880348894 | -122.395879493351 | (37.7376368803489, -122.395879493351) | |||
| 14688 | 14688 | 108710 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011387.70807 | 2106529.33414 | 37.764769934605205 | -122.40380746863998 | (37.7647699346052, -122.40380746864) |
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");