Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167443 | 167443 | 67430 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.774633233377706 | -122.4782759878 | (37.7746332333777, -122.4782759878) | |
| 181483 | 181483 | 120833 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989987.953 | 2110566.55394 | 37.7746363029346 | -122.478118044214 | (37.7746363029346, -122.478118044214) | |||
| 73706 | 73706 | 120866 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990027.965580001 | 2110538.28947 | 37.774561018937796 | -122.477977567474 | (37.7745610189378, -122.477977567474) | |||
| 63557 | 63557 | 120865 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990028.78526 | 2110554.03114 | 37.7746042888084 | -122.47797588313801 | (37.7746042888084, -122.477975883138) | |||
| 161170 | 161170 | 67435 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2632 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 6 | Permit Number 30937 | 5990433.164530001 | 2112001.81298 | 37.7786029615899 | -122.47668286606199 | (37.7786029615899, -122.476682866062) | |
| 74043 | 74043 | 67428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.774932181016204 | -122.47517347719901 | (37.7749321810162, -122.475173477199) | |
| 36077 | 36077 | 37655 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1521 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40065 | 5990857.78217 | 2110597.46577 | 37.774771629499796 | -122.475111419797 | (37.7747716294998, -122.475111419797) | |
| 41126 | 41126 | 67427 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1515 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30929 | 5990869.16638 | 2110599.51462 | 37.7747779148712 | -122.475072189476 | (37.7747779148712, -122.475072189476) | |
| 41730 | 41730 | 122013 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1502 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5990886.70839 | 2110660.9525099997 | 37.774947623169204 | -122.475015994442 | (37.7749476231692, -122.475015994442) | |||
| 156740 | 156740 | 67426 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1502 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30928 | 5990903.71531 | 2110660.74638 | 37.7749480428024 | -122.474957149423 | (37.7749480428024, -122.474957149423) | |
| 56606 | 56606 | 219177 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991107.88095 | 2106214.54011 | 37.7627517902819 | -122.473926451152 | (37.7627517902819, -122.473926451152) | |||
| 140863 | 140863 | 36113 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.764722731307394 | -122.47182229152901 | (37.7647227313074, -122.471822291529) | ||
| 32337 | 32337 | 219178 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991732.81966 | 2106918.29037 | 37.7647202794542 | -122.471816321464 | (37.7647202794542, -122.471816321464) | |||
| 87737 | 87737 | 36126 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39222 | 5993608.5123809995 | 2106430.08869154 | 37.76348815576279 | -122.46529338011999 | (37.7634881557628, -122.46529338012) | ||
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 178475 | 178475 | 219179 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.46366964095199 | (37.7551443576498, -122.463669640952) | |||
| 117935 | 117935 | 48637 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | ||
| 138636 | 138636 | 48636 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) |
| 40773 | 40773 | 123610 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994873.21088 | 2114645.23418 | 37.7861176222016 | -122.46151484664301 | (37.7861176222016, -122.461514846643) | |||
| 44241 | 44241 | 64733 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1988 12:00:00 AM | 8 | Permit Number 25692 | 5994873.94035 | 2114654.72726 | 37.786143729617294 | -122.461513011375 | (37.7861437296173, -122.461513011375) | ||
| 85155 | 85155 | 1635 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 819 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2014 12:00:00 AM | 3 | 4X4 | 5995645.06873 | 2110681.65476 | 37.775279084646 | -122.458557415767 | (37.775279084646, -122.458557415767) | ||
| 106928 | 106928 | 108370 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 823 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774572 | 5995757.2341599995 | 2113775.59974 | 37.783780682228 | -122.458393411251 | (37.783780682228, -122.458393411251) | |
| 3093 | 3093 | 124473 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.774772198948796 | -122.456257787006 | (37.7747721989488, -122.456257787006) | |
| 123137 | 123137 | 67115 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1000 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30534 | 5998132.38450691 | 2106832.35950645 | 37.764852539386894 | -122.449675814605 | (37.7648525393869, -122.449675814605) | ||
| 157193 | 157193 | 228478 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 99 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998158.0059 | 2106821.83124 | 37.7648250972209 | -122.44958643847299 | (37.7648250972209, -122.449586438473) | |||
| 136455 | 136455 | 228479 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998955.25722 | 2107101.1921200003 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | |||
| 91318 | 91318 | 44081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 122875 | 122875 | 44082 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 169842 | 169842 | 219181 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999211.06214 | 2094946.2543900001 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | |||
| 122853 | 122853 | 87378 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3x3 | Permit Number 50360 | 5999753.9 | 2102061.4 | 37.7518452950477 | -122.44372464805299 | (37.7518452950477, -122.443724648053) | ||
| 68617 | 68617 | 228483 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.44363115936198 | (37.751787354827, -122.443631159362) | |||
| 167422 | 167422 | 78131 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2040 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53996 | 6000457.66404 | 2121004.4785 | 37.8038982794373 | -122.442650952296 | (37.8038982794373, -122.442650952296) |
| 70201 | 70201 | 32479 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 81 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 8 | Permit Number 36987 | 6000177.30918 | 2105965.99025 | 37.762590484284395 | -122.44254075744499 | (37.7625904842844, -122.442540757445) | |
| 56576 | 56576 | 228499 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 38 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000241.54312 | 2106649.97851 | 37.764472207742294 | -122.442367702717 | (37.7644722077423, -122.442367702717) | |||
| 154443 | 154443 | 245065 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | |||
| 132848 | 132848 | 95250 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001050.95383 | 2119955.94053 | 37.8010530753849 | -122.440522591565 | (37.8010530753849, -122.440522591565) | |
| 130008 | 130008 | 95251 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001052.92994 | 2119937.28939 | 37.801001976825 | -122.440514414928 | (37.801001976825, -122.440514414928) | |
| 161401 | 161401 | 228484 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000983.78885 | 2101507.81072 | 37.750395343677795 | -122.439431853304 | (37.7503953436778, -122.439431853304) | |||
| 87419 | 87419 | 32861 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | ||
| 18938 | 18938 | 10354 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.771092330601604 | -122.439069286514 | (37.7710923306016, -122.439069286514) | ||
| 153340 | 153340 | 32442 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 11 | Permit Number 36965 | 6001246.93122 | 2105801.18273 | 37.7621988754027 | -122.43882951888901 | (37.7621988754027, -122.438829518889) | |
| 84002 | 84002 | 32443 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36965 | 6001261.23901245 | 2105800.41566985 | 37.762197583242795 | -122.438779978808 | (37.7621975832428, -122.438779978808) | ||
| 18351 | 18351 | 10343 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 940 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001599.8151 | 2109085.1313 | 37.7712358586189 | -122.437844249148 | (37.7712358586189, -122.437844249148) | |||
| 113736 | 113736 | 32823 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 37181 | 6001484.39499205 | 2102303.82093127 | 37.75260947422421 | -122.43775772935 | (37.7526094742242, -122.43775772935) | ||
| 56243 | 56243 | 228489 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001576.285680001 | 2101774.2319 | 37.751160574113605 | -122.437402036675 | (37.7511605741136, -122.437402036675) | |||
| 143377 | 143377 | 32828 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.43724693926201 | (37.7511683628484, -122.437246939262) | ||
| 114509 | 114509 | 37417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1406 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 39895 | 6001966.85277742 | 2099994.31437339 | 37.746295538854795 | -122.435924071348 | (37.7462955388548, -122.435924071348) | ||
| 18989 | 18989 | 10323 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 774 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2009 12:00:00 AM | 3 | 3X3 | 6002445.3097 | 2109202.4042 | 37.771605902741705 | -122.43492804083999 | (37.7716059027417, -122.43492804084) | ||
| 120939 | 120939 | 10320 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 758 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1992 12:00:00 AM | 25 | 3X3 | 6002531.73322 | 2109228.96362 | 37.771683734938996 | -122.43463099668699 | (37.771683734939, -122.434630996687) | ||
| 152814 | 152814 | 247323 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 752 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002559.2743 | 2109218.8363 | 37.771657491274205 | -122.434535006264 | (37.7716574912742, -122.434535006264) | |||
| 51149 | 51149 | 228500 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1230 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002502.463830001 | 2101939.70334 | 37.7516675300559 | -122.434211046008 | (37.7516675300559, -122.434211046008) | |||
| 6152 | 6152 | 34989 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2447 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38568 | 6002987.46694 | 2116484.72723 | 37.7916321004801 | -122.433573216253 | (37.7916321004801, -122.433573216253) | ||
| 115984 | 115984 | 10311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 657 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1999 12:00:00 AM | 8 | 3X3 | 6003004.4895 | 2109163.37188 | 37.7715304629462 | -122.43299101798401 | (37.7715304629462, -122.432991017984) | ||
| 17937 | 17937 | 25490 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.9780099997 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | ||
| 19533 | 19533 | 25491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069334998 | (37.7717244144917, -122.43292069335) | ||
| 23175 | 23175 | 25492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.43286102333299 | (37.7717331028377, -122.432861023333) | ||
| 91292 | 91292 | 50559 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/2003 12:00:00 AM | Permit Number 47181 | 6003055.27396348 | 2109235.82329281 | 37.7717322771379 | -122.43282052857 | (37.7717322771379, -122.43282052857) | ||
| 60791 | 60791 | 228485 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4158 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002879.00201 | 2100672.89334 | 37.7482105324925 | -122.432818439532 | (37.7482105324925, -122.432818439532) | |||
| 85140 | 85140 | 10309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 629 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2011 12:00:00 AM | 3 | 3X3 | 6003124.536169999 | 2109214.79731 | 37.7716784730152 | -122.43257944422399 | (37.7716784730152, -122.432579444224) | ||
| 21953 | 21953 | 29956 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.43228248973699 | (37.7719405092432, -122.432282489737) | ||
| 72860 | 72860 | 228438 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003321.74278 | 2109274.9224400003 | 37.7718547433349 | -122.43190158878599 | (37.7718547433349, -122.431901588786) | |||
| 117982 | 117982 | 91221 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003327.2605 | 2109254.11842 | 37.7717979333979 | -122.431881016883 | (37.7717979333979, -122.431881016883) | ||
| 161698 | 161698 | 228439 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.43181286889099 | (37.7718652941806, -122.431812868891) | |||
| 105139 | 105139 | 91222 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 6003354.82967 | 2109257.95569 | 37.7718100324239 | -122.43178592736099 | (37.7718100324239, -122.431785927361) | |||
| 80126 | 80126 | 91203 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2009 12:00:00 AM | 3 | 6003365.215480001 | 2109356.0742599997 | 37.772080030656 | -122.43175700892999 | (37.772080030656, -122.43175700893) | |||
| 61878 | 61878 | 244232 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003376.0691 | 2109331.3272 | 37.77201269653779 | -122.431717698222 | (37.7720126965378, -122.431717698222) | |||
| 115423 | 115423 | 91202 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2009 12:00:00 AM | 3 | 6003384.38178 | 2109395.5915599996 | 37.772189621885 | -122.43169353309601 | (37.772189621885, -122.431693533096) | |||
| 100253 | 100253 | 91223 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 577 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6003385.59355 | 2109287.85508 | 37.7718938726453 | -122.431681648151 | (37.7718938726453, -122.431681648151) | ||
| 47551 | 47551 | 244231 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.772022330462796 | -122.43161454270799 | (37.7720223304628, -122.431614542708) | |||
| 21724 | 21724 | 10299 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.43139282162599 | (37.7719205287291, -122.431392821626) | |||
| 23042 | 23042 | 10300 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303002 | (37.772060883831, -122.43134154303) | |||
| 106323 | 106323 | 91201 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 542 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003536.88264 | 2109349.2972 | 37.772071151994204 | -122.43116271492399 | (37.7720711519942, -122.431162714924) | ||
| 46354 | 46354 | 244230 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 546 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003542.3247 | 2109354.0057 | 37.7720843887684 | -122.43114422654699 | (37.7720843887684, -122.431144226547) | |||
| 26787 | 26787 | 228493 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | |||
| 139543 | 139543 | 10297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 540 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003554.89128 | 2109371.3672 | 37.7721327712956 | -122.43110199714701 | (37.7721327712956, -122.431101997147) | ||
| 146861 | 146861 | 228492 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003450.5613 | 2103629.24333 | 37.756360373235204 | -122.431052978634 | (37.7563603732352, -122.431052978634) | |||
| 161281 | 161281 | 244228 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 500 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003580.1475 | 2109359.8483 | 37.7721025743544 | -122.431013811567 | (37.7721025743544, -122.431013811567) | |||
| 87935 | 87935 | 63738 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 614 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1987 12:00:00 AM | Permit Number 24409 | 6003616.13531823 | 2109713.3650038997 | 37.773075283639706 | -122.430914560979 | (37.7730752836397, -122.430914560979) | ||
| 130323 | 130323 | 228477 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003665.88299 | 2100131.59167 | 37.74676884190679 | -122.43005882127599 | (37.7467688419068, -122.430058821276) | |||
| 89783 | 89783 | 91200 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 482 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003865.9067400005 | 2109457.56257 | 37.7723870617714 | -122.43003231905001 | (37.7723870617714, -122.43003231905) | ||
| 3015 | 3015 | 244496 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 478 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | Width 0ft | 6003878.5797 | 2109399.3843 | 37.7722280361906 | -122.429984331292 | (37.7722280361906, -122.429984331292) | ||
| 51365 | 51365 | 140195 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 801 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003913.9155 | 2111095.4696 | 37.7768870709162 | -122.429983110687 | (37.7768870709162, -122.429983110687) | |||
| 58955 | 58955 | 37026 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.746789273196796 | -122.429947677166 | (37.7467892731968, -122.429947677166) | ||
| 94224 | 94224 | 91199 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 460 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6003924.61561 | 2109422.82576 | 37.7722950077597 | -122.429826761418 | (37.7722950077597, -122.429826761418) | ||
| 153625 | 153625 | 244495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 462 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003934.2301 | 2109407.8865 | 37.7722545326532 | -122.42979243828199 | (37.7722545326532, -122.429792438282) | |||
| 108051 | 108051 | 91198 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6003949.90821 | 2109426.34577 | 37.7723061050967 | -122.429739523154 | (37.7723061050967, -122.429739523154) | ||
| 3016 | 3016 | 244492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | ||
| 2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
| 135498 | 135498 | 228476 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.42960322110599 | (37.7434561594686, -122.429603221106) | |||
| 144411 | 144411 | 91216 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6003988.48556 | 2109346.1480900003 | 37.7720880862632 | -122.429600359958 | (37.7720880862632, -122.429600359958) | ||
| 94475 | 94475 | 91197 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003996.812969999 | 2109443.98025 | 37.772357180985 | -122.429578533241 | (37.772357180985, -122.429578533241) | ||
| 21394 | 21394 | 10288 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 447 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6003998.901740001 | 2109366.95645 | 37.77214581071579 | -122.429565813827 | (37.7721458107158, -122.429565813827) | ||
| 2952 | 2952 | 244491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.42954388259199 | (37.7722877948852, -122.429543882592) | ||
| 121398 | 121398 | 60428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30410 | 6003803.88116194 | 2098922.41171053 | 37.7434565282269 | -122.429495418306 | (37.7434565282269, -122.429495418306) | ||
| 129356 | 129356 | 91196 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 430 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | 3x3 | 6004046.01956 | 2109450.8286599996 | 37.772378771061 | -122.42940881154199 | (37.772378771061, -122.429408811542) | ||
| 23089 | 23089 | 24920 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 430 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6004056.545 | 2109425.8569 | 37.772310800612104 | -122.429370621982 | (37.7723108006121, -122.429370621982) | |||
| 95037 | 95037 | 91195 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 422 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 1 | 3x3 | 6004087.9204 | 2109490.98672 | 37.772491407466205 | -122.429266736662 | (37.7724914074662, -122.429266736662) | ||
| 2982 | 2982 | 244493 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.772325546907794 | -122.42924796682699 | (37.7723255469078, -122.429247966827) | ||
| 5146 | 5146 | 228435 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 178 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004070.0 | 2107898.0 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | |||
| 3025 | 3025 | 228441 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 419 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) |
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");