Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123310 | 123310 | 226843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000048.9204 | 2101630.772 | 37.7506797174008 | -122.442673512691 | (37.7506797174008, -122.442673512691) | ||||
124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
125685 | 125685 | 96832 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
130260 | 130260 | 54791 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.711719793993204 | -122.39815894829901 | (37.7117197939932, -122.398158948299) | ||
131920 | 131920 | 31117 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.33216 | 2094320.7757 | 37.7305365079364 | -122.446493035949 | (37.7305365079364, -122.446493035949) | |
133392 | 133392 | 68011 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 4 | Permit Number 31741 | 6007478.84194 | 2121154.66744 | 37.8047083959278 | -122.41836432607501 | (37.8047083959278, -122.418364326075) | ||
134405 | 134405 | 62997 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 6 | Permit Number 776580 | 6000198.89461 | 2121071.17508 | 37.8040666559246 | -122.443551231218 | (37.8040666559246, -122.443551231218) | ||
135078 | 135078 | 176697 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004613.59426 | 2091464.71146 | 37.7230251669629 | -122.426164813475 | (37.7230251669629, -122.426164813475) | ||||
136064 | 136064 | 206915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 382 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999548.48293 | 2094983.7433799999 | 37.7324000228394 | -122.44392653538999 | (37.7324000228394, -122.44392653539) | ||||
136530 | 136530 | 46600 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2425 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | 5 | Permit Number 44728 | 6001248.41305 | 2117934.15473 | 37.795513025858 | -122.439694270995 | (37.795513025858, -122.439694270995) | ||
136870 | 136870 | 206916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 382 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999547.8885699995 | 2094988.6031799999 | 37.7324133328074 | -122.44392893927 | (37.7324133328074, -122.44392893927) | ||||
138216 | 138216 | 129178 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998998.34734 | 2120131.24528 | 37.801417321497794 | -122.447638089651 | (37.8014173214978, -122.447638089651) | ||||
138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
146783 | 146783 | 35594 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.6753599998 | 37.752955146087295 | -122.401332479509 | (37.7529551460873, -122.401332479509) | |
148745 | 148745 | 61250 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1997 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.800048553351296 | -122.41764457883001 | (37.8000485533513, -122.41764457883) | |
149094 | 149094 | 129115 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007304.145280001 | 2119280.40626 | 37.7995523128455 | -122.418835875684 | (37.7995523128455, -122.418835875684) | ||||
149203 | 149203 | 176720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6005093.440280001 | 2092751.8073 | 37.7265863599479 | -122.424597593708 | (37.7265863599479, -122.424597593708) | ||||
149571 | 149571 | 226942 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Fairmount St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 61 | 6004034.48943 | 2097139.1413599998 | 37.7385731303523 | -122.428570945989 | (37.7385731303523, -122.428570945989) | ||||
150004 | 150004 | 247945 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010344.08085 | 2098894.91993 | 37.743749172086794 | -122.406879009554 | (37.7437491720868, -122.406879009554) | ||||
151655 | 151655 | 129180 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5998992.55112 | 2120173.79871 | 37.8015338304744 | -122.447661212108 | (37.8015338304744, -122.447661212108) | ||||
151959 | 151959 | 176688 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004477.9919300005 | 2091866.25637 | 37.7241200555896 | -122.426662143938 | (37.7241200555896, -122.426662143938) | ||||
153922 | 153922 | 176719 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | ||||
155571 | 155571 | 129116 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007272.57871 | 2119275.5487599997 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | ||||
157750 | 157750 | 30806 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 138 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 15 | Permit Number 34671 | 6001325.75026 | 2095385.6774799998 | 37.7336048607826 | -122.437810896383 | (37.7336048607826, -122.437810896383) | |
159523 | 159523 | 34521 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 306 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 11 | Permit Number 38231 | 6006308.04583 | 2092388.1729 | 37.725656419580496 | -122.42037294026301 | (37.7256564195805, -122.420372940263) | ||
161824 | 161824 | 226864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 294 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002870.33579 | 2096200.69977 | 37.735930434733895 | -122.43252901612499 | (37.7359304347339, -122.432529016125) | ||||
166472 | 166472 | 219289 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 212 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6000021.7588599995 | 2094391.55227 | 37.7308009895552 | -122.442247818595 | (37.7308009895552, -122.442247818595) | ||||
167449 | 167449 | 176718 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004890.82087 | 2092414.1622099997 | 37.7256478157716 | -122.42527402599801 | (37.7256478157716, -122.425274025998) | ||||
167693 | 167693 | 38364 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825001 | (37.7566067521127, -122.50598509825) | |
167821 | 167821 | 219239 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 579 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997578.77584 | 2094371.8563299999 | 37.7306073727237 | -122.450692139651 | (37.7306073727237, -122.450692139651) | ||||
169027 | 169027 | 206958 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998473.20462 | 2095007.84782 | 37.7324048126327 | -122.447645742852 | (37.7324048126327, -122.447645742852) | ||||
169303 | 169303 | 129327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007552.17158 | 2119860.88653 | 37.801160127991295 | -122.41801878675899 | (37.8011601279913, -122.418018786759) | ||||
170842 | 170842 | 129329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007555.7240699995 | 2119861.47467 | 37.8011619428155 | -122.41800653528601 | (37.8011619428155, -122.418006535286) | ||||
171348 | 171348 | 190811 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012250.38187 | 2101814.62177 | 37.7518725286982 | -122.400492482145 | (37.7518725286982, -122.400492482145) | ||||
171563 | 171563 | 129328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007553.95221 | 2119861.40094 | 37.8011616406485 | -122.418012661478 | (37.8011616406485, -122.418012661478) | ||||
171687 | 171687 | 219254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 449 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997174.97013 | 2095514.3444599998 | 37.7337212492173 | -122.452170552242 | (37.7337212492173, -122.452170552242) | ||||
173605 | 173605 | 226941 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6004051.37428 | 2097144.63452 | 37.738589168851206 | -122.42851295770399 | (37.7385891688512, -122.428512957704) | ||||
173712 | 173712 | 201343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012739.9825 | 2092614.2530099999 | 37.72663754126479 | -122.39815395433399 | (37.7266375412648, -122.398153954334) | ||||
173736 | 173736 | 57800 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1977 12:00:00 AM | 9 | Permit Number 16735 | 5981352.9647 | 2110030.94394 | 37.7726606704836 | -122.50794790130199 | (37.7726606704836, -122.507947901302) | ||
174096 | 174096 | 219307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 166 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998440.900769999 | 2093236.39067 | 37.727538962329604 | -122.447629950774 | (37.7275389623296, -122.447629950774) | ||||
174140 | 174140 | 49714 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | |
174640 | 174640 | 176690 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004472.37947 | 2091855.23398 | 37.724089473225206 | -122.426680760821 | (37.7240894732252, -122.426680760821) | ||||
175259 | 175259 | 218146 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5994143.80732 | 2090112.0989599999 | 37.7187138908262 | -122.46225842838601 | (37.7187138908262, -122.462258428386) | ||||
175549 | 175549 | 247137 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003179.078430001 | 2100075.39017 | 37.7465869432333 | -122.431738130709 | (37.7465869432333, -122.431738130709) | ||||
179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
179518 | 179518 | 176686 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004486.61146 | 2091862.36635 | 37.7241098617621 | -122.426632070637 | (37.7241098617621, -122.426632070637) | ||||
179802 | 179802 | 129331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.41798625015899 | (37.8011675015458, -122.417986250159) | ||||
180391 | 180391 | 69013 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2183 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 4 | Permit Number 33017 | 5982309.8617 | 2100270.0071 | 37.7459162464128 | -122.50391486605301 | (37.7459162464128, -122.503914866053) | |
183234 | 183234 | 43136 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1730 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42952 | 6006290.853069999 | 2092023.3911599999 | 37.7246538391803 | -122.42040649398199 | (37.7246538391803, -122.420406493982) | |
183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
184997 | 184997 | 219400 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998549.53071 | 2095273.1110200002 | 37.7331375244767 | -122.447400952815 | (37.7331375244767, -122.447400952815) | ||||
186712 | 186712 | 38366 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 6 | Permit Number 40430 | 5981835.1907 | 2104176.6987 | 37.756614999407894 | -122.50584576351999 | (37.7566149994079, -122.50584576352) | ||
187209 | 187209 | 206920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 411 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5997366.58572 | 2095512.9448099998 | 37.7337283808453 | -122.45150798300399 | (37.7337283808453, -122.451507983004) | ||||
187387 | 187387 | 226842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000049.35116 | 2101618.9889599998 | 37.75064738858 | -122.44267117713699 | (37.75064738858, -122.442671177137) | ||||
188832 | 188832 | 129179 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5998993.68481 | 2120160.70419 | 37.801497941247895 | -122.44765634587601 | (37.8014979412479, -122.447656345876) | ||||
14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
32407 | 32407 | 866 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
112118 | 112118 | 878 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
17954 | 17954 | 16098 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | ||
14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
28768 | 28768 | 110918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014775.51071 | 2113108.67341 | 37.7830240119856 | -122.392550107818 | (37.7830240119856, -122.392550107818) | |||
151494 | 151494 | 110917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121001 | (37.7829898170664, -122.39259867121) | |||
164696 | 164696 | 110916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014753.14393 | 2113088.0309200003 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | |||
181098 | 181098 | 110919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.783047040932395 | -122.39252008665001 | (37.7830470409324, -122.39252008665) | |||
50164 | 50164 | 107054 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6003385.0 | 2094496.0 | 37.731278888142704 | -122.43062801306999 | (37.7312788881427, -122.43062801307) | |||
66804 | 66804 | 115308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007523.230690001 | 2116877.91301 | 37.792967998429 | -122.417907360732 | (37.792967998429, -122.417907360732) | |||
80890 | 80890 | 108255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
92163 | 92163 | 108259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
98097 | 98097 | 108256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
105668 | 105668 | 108258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
112717 | 112717 | 108257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
121707 | 121707 | 108254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
168446 | 168446 | 115307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007522.861409999 | 2116889.0118 | 37.792998452176796 | -122.41790942558501 | (37.7929984521768, -122.417909425585) | |||
104644 | 104644 | 106801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 2x3 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
11045 | 11045 | 27100 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 675 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005860.0759 | 2093589.7540900002 | 37.728930444682206 | -122.422006859139 | (37.7289304446822, -122.422006859139) | |||
11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
16907 | 16907 | 16140 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 370 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999741.99698 | 2094725.2386 | 37.7317012657937 | -122.44323895423099 | (37.7317012657937, -122.443238954231) | |||
17854 | 17854 | 4283 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001860.11761 | 2100274.84005 | 37.7470597321331 | -122.436313221179 | (37.7470597321331, -122.436313221179) | ||
18293 | 18293 | 4370 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001204.190330001 | 2096097.5771700002 | 37.7355526592134 | -122.438282146497 | (37.7355526592134, -122.438282146497) | ||
18654 | 18654 | 16099 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000036.69943 | 2094718.89433 | 37.7317006461483 | -122.442219656332 | (37.7317006461483, -122.442219656332) | |||
18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
19631 | 19631 | 16102 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000017.68556 | 2094719.9660099999 | 37.7317025050652 | -122.442285467815 | (37.7317025050652, -122.442285467815) | |||
21152 | 21152 | 4284 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001863.40945 | 2100279.02786 | 37.747071417908 | -122.43630213795299 | (37.747071417908, -122.436302137953) | ||
21395 | 21395 | 16100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000028.57256 | 2094720.41703 | 37.7317043639536 | -122.442247861742 | (37.7317043639536, -122.442247861742) | |||
100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
115088 | 115088 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 3X3 | 5999593.0 | 2099199.0 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) |
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");