Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189121 | 189121 | 214450 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 45 Dorantes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994111.5037 | 2100039.81972 | 37.7459711108718 | -122.463090021601 | (37.7459711108718, -122.463090021601) | |||
| 189068 | 189068 | 244980 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | |||
| 189052 | 189052 | 139053 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1470 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999716.3669 | 2113930.9987 | 37.784434089571704 | -122.444707517048 | (37.7844340895717, -122.444707517048) | |||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
| 188866 | 188866 | 238006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 120 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002226.03876 | 2096243.0070099998 | 37.7360100427193 | -122.434759628851 | (37.7360100427193, -122.434759628851) | |||
| 188851 | 188851 | 244107 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1950 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997179.2314 | 2108813.7603 | 37.7702383812245 | -122.453115554339 | (37.7702383812245, -122.453115554339) | |||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 188674 | 188674 | 181914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987457.4265 | 2098985.8656 | 37.742691680738 | -122.48602127745 | (37.742691680738, -122.48602127745) | |||
| 188651 | 188651 | 185046 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2767 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985833.5409 | 2096575.126 | 37.7359776633696 | -122.491458724203 | (37.7359776633696, -122.491458724203) | |||
| 188640 | 188640 | 184708 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984043.3081 | 2104133.2508 | 37.7566254238897 | -122.498206207845 | (37.7566254238897, -122.498206207845) | |||
| 188317 | 188317 | 81230 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1615 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2005 12:00:00 AM | 2 | 3x3 | Permit Number 49855 | 5989003.1653 | 2104324.8882 | 37.757441181357 | -122.48106746320101 | (37.757441181357, -122.481067463201) | |
| 188289 | 188289 | 178905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999575.27021 | 2086527.1037599999 | 37.7091815546459 | -122.443226763913 | (37.7091815546459, -122.443226763913) | |||
| 188281 | 188281 | 178950 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 609 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007192.0962 | 2091723.76737 | 37.723881882739704 | -122.417269780083 | (37.7238818827397, -122.417269780083) | |||
| 188263 | 188263 | 135895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007001.276269999 | 2115550.37651 | 37.7892935232365 | -122.419619122234 | (37.7892935232365, -122.419619122234) | |||
| 188063 | 188063 | 142262 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004599.612000001 | 2110681.6144 | 37.77578953520371 | -122.42758158520701 | (37.7757895352037, -122.427581585207) | |||
| 187927 | 187927 | 246220 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1375 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999535.8083 | 2107910.8735 | 37.767894059626606 | -122.444899283084 | (37.7678940596266, -122.444899283084) | |||
| 187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) | |||
| 187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 187570 | 187570 | 244239 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 253 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005546.7389 | 2110177.0116 | 37.774457544735604 | -122.424269333697 | (37.7744575447356, -122.424269333697) | |||
| 187343 | 187343 | 214392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994371.91106 | 2098648.34768 | 37.7421654749467 | -122.46208868315 | (37.7421654749467, -122.46208868315) | |||
| 187269 | 187269 | 49212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | |
| 187198 | 187198 | 182078 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1432 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989005.6943 | 2105539.1436 | 37.7607753463395 | -122.48114762795 | (37.7607753463395, -122.48114762795) | |||
| 187101 | 187101 | 196396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | |||
| 187060 | 187060 | 178958 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007547.64809 | 2091871.91329 | 37.7243086569025 | -122.41605117804 | (37.7243086569025, -122.41605117804) | |||
| 186573 | 186573 | 196411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009748.505890001 | 2111160.13618 | 37.7773933332614 | -122.40980396908002 | (37.7773933332614, -122.40980396908) | |||
| 186494 | 186494 | 182276 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985061.2024 | 2105018.6781 | 37.759116193094 | -122.494751291704 | (37.759116193094, -122.494751291704) | |||
| 186123 | 186123 | 140190 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 288 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997399.4185 | 2109598.1459999997 | 37.7724047190533 | -122.45241054385599 | (37.7724047190533, -122.452410543856) | |||
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 186044 | 186044 | 185736 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5987568.4406 | 2100856.1259 | 37.7478333870661 | -122.485774665371 | (37.7478333870661, -122.485774665371) | |||
| 186001 | 186001 | 95591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821001 | (37.7648163177268, -122.48948400821) |
| 185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
| 185705 | 185705 | 178890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002959.70968 | 2090965.8257900001 | 37.721561719087795 | -122.431846349732 | (37.7215617190878, -122.431846349732) | |||
| 185641 | 185641 | 138955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 721 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004476.9169 | 2110918.2976 | 37.7764324685086 | -122.428022888756 | (37.7764324685086, -122.428022888756) | |||
| 185541 | 185541 | 244063 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1670 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998595.6913 | 2109011.0161 | 37.7708610734694 | -122.448230254318 | (37.7708610734694, -122.448230254318) | |||
| 185222 | 185222 | 142763 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | |||
| 185181 | 185181 | 47469 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.785415601023395 | -122.445403484856 | (37.7854156010234, -122.445403484856) | |
| 185028 | 185028 | 43836 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43458 | 5985569.2648 | 2097041.677 | 37.737243241151496 | -122.492406765684 | (37.7372432411515, -122.492406765684) | |
| 185001 | 185001 | 47520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 250 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45392 | 6000896.21512 | 2093538.05114 | 37.7285072713869 | -122.43916354146099 | (37.7285072713869, -122.439163541461) | |
| 184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
| 184820 | 184820 | 245887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 204 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001309.3147 | 2109461.0534 | 37.772251523616 | -122.438876043486 | (37.772251523616, -122.438876043486) | |||
| 184779 | 184779 | 142759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010846.8046 | 2120020.1312 | 37.801782251607 | -122.406629096352 | (37.801782251607, -122.406629096352) | |||
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 184613 | 184613 | 178887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.720641554351296 | -122.429099297695 | (37.7206415543513, -122.429099297695) | |||
| 184583 | 184583 | 214454 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 808 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000441.91889 | 2095870.2821900002 | 37.7348851751926 | -122.44090130146601 | (37.7348851751926, -122.440901301466) | |||
| 184575 | 184575 | 182425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1538 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988098.2611 | 2104825.7625 | 37.758763800953005 | -122.484233676535 | (37.758763800953, -122.484233676535) | |||
| 184353 | 184353 | 196416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010037.74833 | 2110859.1244200002 | 37.776583030628295 | -122.408782138683 | (37.7765830306283, -122.408782138683) | |||
| 184333 | 184333 | 178913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5993781.9303 | 2086773.16178 | 37.709525120851396 | -122.463267128695 | (37.7095251208514, -122.463267128695) | ||||
| 184326 | 184326 | 214428 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1455 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994568.849330001 | 2105618.5919 | 37.7613153310709 | -122.46191305814 | (37.7613153310709, -122.46191305814) | |||
| 184229 | 184229 | 218417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994252.951119999 | 2100616.68956 | 37.7475631968785 | -122.462642758156 | (37.7475631968785, -122.462642758156) | |||
| 184051 | 184051 | 178910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | ||||
| 183985 | 183985 | 178917 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | ||||
| 183961 | 183961 | 139417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1701 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004046.3972 | 2114236.4215 | 37.78551884556639 | -122.429748897639 | (37.7855188455664, -122.429748897639) | |||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 183435 | 183435 | 245195 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000874.4772 | 2109202.1258 | 37.7715158240845 | -122.440361608185 | (37.7715158240845, -122.440361608185) | |||
| 183255 | 183255 | 83569 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2579 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50370 | 5987984.0904 | 2097769.4524 | 37.7393824087044 | -122.48411106317499 | (37.7393824087044, -122.484111063175) | |
| 183104 | 183104 | 142768 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 668 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007546.5879 | 2113634.4027 | 37.7840634287439 | -122.417596552478 | (37.7840634287439, -122.417596552478) | |||
| 183069 | 183069 | 237990 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005158.74512 | 2096696.1692 | 37.7374203883407 | -122.424652302187 | (37.7374203883407, -122.424652302187) | |||
| 183024 | 183024 | 185612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2101 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985702.4651 | 2100891.7117 | 37.7478221885491 | -122.492229646849 | (37.7478221885491, -122.492229646849) | |||
| 182993 | 182993 | 183558 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1610 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987922.2884 | 2097634.497 | 37.7390082581786 | -122.484314849379 | (37.7390082581786, -122.484314849379) | |||
| 182867 | 182867 | 41338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | ||
| 182838 | 182838 | 238031 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3896 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002524.05826 | 2102994.76083 | 37.75456569247171 | -122.43421178796001 | (37.7545656924717, -122.43421178796) | |||
| 182779 | 182779 | 31302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.42548090783501 | (37.7779765092875, -122.425480907835) | |
| 182711 | 182711 | 91520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | |
| 182703 | 182703 | 41337 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.7 | 2113122.5903 | 37.7820168986492 | -122.456587081702 | (37.7820168986492, -122.456587081702) | ||
| 182510 | 182510 | 43851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.737130827494504 | -122.49349719028 | (37.7371308274945, -122.49349719028) | |
| 182499 | 182499 | 178943 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005019.44035 | 2094085.37748 | 37.730243869436 | -122.424948247481 | (37.730243869436, -122.424948247481) | |||
| 182392 | 182392 | 71214 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2131 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988191.5983 | 2100799.6289 | 37.7477145531771 | -122.483615701045 | (37.7477145531771, -122.483615701045) | ||
| 182343 | 182343 | 178937 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004445.3973900005 | 2091822.37508 | 37.723997724407795 | -122.426771694853 | (37.7239977244078, -122.426771694853) | ||||
| 182335 | 182335 | 178911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993783.22919 | 2086769.82188 | 37.709516025103895 | -122.46326239735201 | (37.7095160251039, -122.463262397352) | ||||
| 182223 | 182223 | 214385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.46662305770501 | (37.7518191170825, -122.466623057705) | |||
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 182219 | 182219 | 63055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 3 | Permit Number 29651 | 6010016.44472 | 2110878.7775 | 37.7766358001278 | -122.408857221277 | (37.7766358001278, -122.408857221277) | |
| 181756 | 181756 | 245991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1250 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999788.9734 | 2108484.4317 | 37.769483351344 | -122.44406483418899 | (37.769483351344, -122.444064834189) | |||
| 181390 | 181390 | 46205 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2005 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | |
| 181219 | 181219 | 237985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 124 Marsily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004244.2289 | 2095153.5322200002 | 37.7331329640029 | -122.427704333181 | (37.7331329640029, -122.427704333181) | |||
| 181207 | 181207 | 92543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 137 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52887 | 6010552.68366 | 2094065.4210599998 | 37.7305000701252 | -122.40581758561001 | (37.7305000701252, -122.40581758561) | |
| 181205 | 181205 | 139523 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 705 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999605.1618 | 2110921.5795 | 37.7761646531155 | -122.444875844748 | (37.7761646531155, -122.444875844748) | |||
| 181182 | 181182 | 138874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005562.0898 | 2110802.7178 | 37.7761764489655 | -122.424260742604 | (37.7761764489655, -122.424260742604) | |||
| 181071 | 181071 | 196405 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 10th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009655.4576 | 2108693.13255 | 37.770614302125395 | -122.40995165845699 | (37.7706143021254, -122.409951658457) | |||
| 180921 | 180921 | 52459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 584@ BALBOA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48570 | 5992242.76591 | 2111511.4032400004 | 37.777361226341895 | -122.470387093473 | (37.7773612263419, -122.470387093473) | |
| 180512 | 180512 | 139392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005058.4753 | 2111113.4947 | 37.7770013168736 | -122.426025011181 | (37.7770013168736, -122.426025011181) | |||
| 180505 | 180505 | 79189 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5988574.1949 | 2099905.7282 | 37.745282400553 | -122.482227237552 | (37.745282400553, -122.482227237552) | |||
| 180326 | 180326 | 38857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 8 | Permit Number 40684 | 5989293.1114 | 2104890.3622 | 37.759010671995505 | -122.48010610913401 | (37.7590106719955, -122.480106109134) | |
| 180063 | 180063 | 83723 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986042.1421 | 2100161.1312 | 37.7458360633129 | -122.491001322638 | (37.7458360633129, -122.491001322638) | |||
| 179925 | 179925 | 196414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 72 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010005.6719 | 2110890.8659900003 | 37.7766683888663 | -122.40889534086901 | (37.7766683888663, -122.408895340869) | |||
| 179574 | 179574 | 36161 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 59 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 2 | Permit Number 39242 | 5997481.3111 | 2113388.5898 | 37.7828169808275 | -122.45240084560699 | (37.7828169808275, -122.452400845607) | |
| 179548 | 179548 | 73527 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.48362900134701 | (37.747912746917, -122.483629001347) | ||
| 179446 | 179446 | 92292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2551 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52738 | 5989839.8453 | 2098004.8092 | 37.7401365078293 | -122.47771195140801 | (37.7401365078293, -122.477711951408) |
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 179405 | 179405 | 95827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) |
| 179376 | 179376 | 182553 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2545 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986583.8092 | 2105694.5347 | 37.7610609151296 | -122.48953516150299 | (37.7610609151296, -122.489535161503) | |||
| 179369 | 179369 | 214414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 659 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997734.91386 | 2094962.2515599998 | 37.732237393940395 | -122.45019488919901 | (37.7322373939404, -122.450194889199) | ||||
| 179234 | 179234 | 182064 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988016.8067 | 2105885.598 | 37.7616690776633 | -122.48459312008 | (37.7616690776633, -122.48459312008) | |||
| 179211 | 179211 | 92327 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1347 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52759 | 5986769.8307 | 2106074.1568 | 37.7621141110413 | -122.488919709577 | (37.7621141110413, -122.488919709577) |
| 179102 | 179102 | 196398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011290.67787 | 2111282.0901599997 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | |||
| 179096 | 179096 | 31300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | |
| 179082 | 179082 | 183831 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2246 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989808.8015 | 2100066.0373 | 37.7457943024947 | -122.477969938421 | (37.7457943024947, -122.477969938421) | |||
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) |
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");