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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
93885 | 93885 | 18250 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003354.45468 | 2114131.31985 | 37.7851910566456 | -122.432135305453 | (37.7851910566456, -122.432135305453) | |||
95995 | 95995 | 18257 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1855 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003300.7323900005 | 2114129.45265 | 37.785182883793794 | -122.432321034429 | (37.7851828837938, -122.432321034429) | |||
96882 | 96882 | 55827 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 154 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 10 | 3x3 | Permit Number 11876 | 5992447.89997 | 2114435.52315 | 37.785401918703606 | -122.469890426632 | (37.7854019187036, -122.469890426632) | |
98507 | 98507 | 18266 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003196.88425 | 2114105.80464 | 37.7851120634301 | -122.43267862671301 | (37.7851120634301, -122.432678626713) | |||
101570 | 101570 | 93445 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2343 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985970.8 | 2098880.2 | 37.7423148023054 | -122.49115375806299 | (37.7423148023054, -122.491153758063) | ||
103208 | 103208 | 18224 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1675 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004164.0306229 | 2114246.6470389 | 37.7855535827521 | -122.429342650039 | (37.7855535827521, -122.429342650039) | |||
112954 | 112954 | 109113 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 3301x 19TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778467 | 6007480.0 | 2104949.0 | 37.760211624256 | -122.41721125604201 | (37.760211624256, -122.417211256042) | |
114048 | 114048 | 18265 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003117.8494065 | 2114102.4449837 | 37.785098356117004 | -122.432951822199 | (37.785098356117, -122.432951822199) | |||
115725 | 115725 | 18264 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003157.167280001 | 2114102.73742 | 37.785101389107496 | -122.432815815695 | (37.7851013891075, -122.432815815695) | |||
118975 | 118975 | 18268 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003251.63015 | 2114115.07604 | 37.7851406249551 | -122.43248988562401 | (37.7851406249551, -122.432489885624) | |||
120388 | 120388 | 93418 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1850 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:30:00 PM | 3 | 3x3 | 5987496.0 | 2098972.0 | 37.742655857366294 | -122.485886885578 | (37.7426558573663, -122.485886885578) | ||
122182 | 122182 | 93442 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2441 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:39:00 PM | 3 | 3x3 | 5985592.0 | 2098836.3 | 37.742172124856204 | -122.49246028206998 | (37.7421721248562, -122.49246028207) | ||
122318 | 122318 | 18258 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1855 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003321.44909 | 2114132.20192 | 37.785191607243206 | -122.43224955752501 | (37.7851916072432, -122.432249557525) | |||
127772 | 127772 | 93440 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2545 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985345.0 | 2098863.0 | 37.7422309915573 | -122.49331628538499 | (37.7422309915573, -122.493316285385) | ||
127916 | 127916 | 23888 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1750X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.43264662292299 | (37.7845200030062, -122.432646622923) | |||
142199 | 142199 | 212835 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 401 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997377.5580400005 | 2097039.2762900002 | 37.7379199482423 | -122.451580107737 | (37.7379199482423, -122.451580107737) | |||
143362 | 143362 | 93448 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2319X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986046.0 | 2098887.0 | 37.7423378667916 | -122.490894243278 | (37.7423378667916, -122.490894243278) | ||
145761 | 145761 | 8413 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1590X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004120.4992681 | 2114020.0804586997 | 37.784929023116796 | -122.429477092496 | (37.7849290231168, -122.429477092496) | |||
146776 | 146776 | 139148 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1865 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003273.137 | 2114121.8047 | 37.7851603197126 | -122.43241595943 | (37.7851603197126, -122.43241595943) | |||
148476 | 148476 | 139150 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003125.8113 | 2114100.7582 | 37.785094176231105 | -122.432924156018 | (37.7850941762311, -122.432924156018) | |||
148492 | 148492 | 139132 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003396.2273 | 2114143.489 | 37.7852268383201 | -122.431991654473 | (37.7852268383201, -122.431991654473) | |||
150054 | 150054 | 139139 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003434.4937 | 2113953.4325 | 37.784707160370296 | -122.43184568933998 | (37.7847071603703, -122.43184568934) | |||
153017 | 153017 | 139131 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003318.4189 | 2114130.7336 | 37.78518740379629 | -122.432259936138 | (37.7851874037963, -122.432259936138) | |||
160567 | 160567 | 139412 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1500 GEARY BLVD | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004126.3357 | 2114029.8613 | 37.784956209303395 | -122.429457598073 | (37.7849562093034, -122.429457598073) | |||
161191 | 161191 | 184192 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1426 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5984302.3594 | 2105559.8646 | 37.7605576926871 | -122.497415645594 | (37.7605576926871, -122.497415645594) | |||
170649 | 170649 | 247388 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002209.9073 | 2109723.8575 | 37.7730243156057 | -122.435779625251 | (37.7730243156057, -122.435779625251) | |||
171566 | 171566 | 234855 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007577.520219999 | 2098081.02135 | 37.7413591949664 | -122.41638750560301 | (37.7413591949664, -122.416387505603) | |||
174573 | 174573 | 139154 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003238.0594 | 2114116.0648 | 37.7851425702811 | -122.432536906804 | (37.7851425702811, -122.432536906804) | |||
175065 | 175065 | 244282 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 563 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004300.7385 | 2110098.3052 | 37.7741710014741 | -122.42857387592699 | (37.7741710014741, -122.428573875927) | |||
178980 | 178980 | 35843 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 425 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 13 | Permit Number 39070 | 6002146.05039 | 2091115.78994 | 37.721927328560206 | -122.434669664286 | (37.7219273285602, -122.434669664286) | |
179998 | 179998 | 139149 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1865 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003298.6479 | 2114126.9069 | 37.7851757756125 | -122.43232806423201 | (37.7851757756125, -122.432328064232) | |||
181063 | 181063 | 246079 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 663 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998980.117000001 | 2108420.232 | 37.769260899787 | -122.446858004242 | (37.769260899787, -122.446858004242) | |||
182029 | 182029 | 234858 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 115 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007085.582140001 | 2098738.0087099997 | 37.743135459435 | -122.41813502591002 | (37.743135459435, -122.41813502591) | |||
182107 | 182107 | 234866 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3781 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001808.66537 | 2106354.74749 | 37.7637507715923 | -122.436926328595 | (37.7637507715923, -122.436926328595) | |||
182921 | 182921 | 234863 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 116 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.4928 | 2098718.4405900002 | 37.7430793606347 | -122.418279172852 | (37.7430793606347, -122.418279172852) | |||
185748 | 185748 | 212847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1269 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.86214 | 2106863.98273 | 37.7647858787024 | -122.45893544780701 | (37.7647858787024, -122.458935447807) | |||
186707 | 186707 | 244545 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1921 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997768.4306 | 2109193.5582 | 37.771314959230295 | -122.45110492040001 | (37.7713149592303, -122.4511049204) | |||
188608 | 188608 | 139128 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1601 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004473.6733 | 2114291.0091 | 37.7856929151772 | -122.428274539531 | (37.7856929151772, -122.428274539531) | |||
25462 | 25462 | 250940 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987097.72783 | 2114420.3103099996 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | |||
26085 | 26085 | 121888 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 10 17th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5990543.39906 | 2115002.75523 | 37.786849107740395 | -122.476520812684 | (37.7868491077404, -122.476520812684) | |||
53633 | 53633 | 250941 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987099.00691 | 2114408.0109900003 | 37.785015739640606 | -122.48839372709699 | (37.7850157396406, -122.488393727097) | |||
57339 | 57339 | 183425 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2419 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989496.7834 | 2098879.0494 | 37.7425170290149 | -122.4789620354 | (37.7425170290149, -122.4789620354) | |||
69116 | 69116 | 250942 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987099.1476 | 2114396.50261 | 37.7849841491372 | -122.48839239429199 | (37.7849841491372, -122.488392394292) | |||
72379 | 72379 | 250724 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987063.6250599995 | 2114433.2112 | 37.7850828677123 | -122.488517988217 | (37.7850828677123, -122.488517988217) | |||
125568 | 125568 | 250943 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987098.9521 | 2114387.30266 | 37.784958877305 | -122.488392394293 | (37.784958877305, -122.488392394293) | |||
136460 | 136460 | 250723 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987051.3666 | 2114432.8618400004 | 37.7850811931768 | -122.48856037238501 | (37.7850811931768, -122.488560372385) | |||
166626 | 166626 | 250938 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 239 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987099.7017 | 2114350.08641 | 37.7848567358866 | -122.48838706491101 | (37.7848567358866, -122.488387064911) | |||
174475 | 174475 | 250944 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987098.95404 | 2114369.2776099998 | 37.784909385797796 | -122.48839106242501 | (37.7849093857978, -122.488391062425) | |||
47982 | 47982 | 212845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 459 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993232.298140001 | 2090226.8914 | 37.7189765558014 | -122.465417457153 | (37.7189765558014, -122.465417457153) | |||
63346 | 63346 | 234845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 452 Oak St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004779.43654 | 2110228.96496 | 37.7745568400539 | -122.426927281183 | (37.7745568400539, -122.426927281183) | |||
71229 | 71229 | 234851 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6009775.07981 | 2105635.7822 | 37.7622262228849 | -122.409322091662 | (37.7622262228849, -122.409322091662) | |||
73108 | 73108 | 234850 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 18th St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 2ft | 6009776.57488 | 2105514.32334 | 37.7618928082166 | -122.40930834911998 | (37.7618928082166, -122.40930834912) | |||
136606 | 136606 | 212846 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 375 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993227.98035 | 2089685.02025 | 37.7174884593132 | -122.465393040574 | (37.7174884593132, -122.465393040574) | |||
157808 | 157808 | 234844 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 471 Oak St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004727.493290001 | 2110160.10241 | 37.7743648231001 | -122.427102057227 | (37.7743648231001, -122.427102057227) | |||
181414 | 181414 | 234853 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6009779.5176 | 2105520.26331 | 37.7619092828952 | -122.40929859056101 | (37.7619092828952, -122.409298590561) | |||
188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) | |||
13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13249 | 13249 | 187612 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
22233 | 22233 | 16926 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 514 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X3 | 6004391.58115 | 2110176.00513 | 37.774389487009 | -122.42826517381201 | (37.774389487009, -122.428265173812) | |||
96576 | 96576 | 115405 | Planning Code 138.1 required 4 | Podocarpus macrophyllus :: Yew Pine 168 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969.0 | 2101168.0 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | ||
101836 | 101836 | 92072 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 3001 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/18/2009 12:00:00 AM | Permit Number 52188 | 5999733.7 | 2116663.4 | 37.791937538515604 | -122.444844029888 | (37.7919375385156, -122.444844029888) | ||||
24600 | 24600 | 234864 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Beaver St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001880.22394 | 2106835.6082900004 | 37.7650751645184 | -122.43671325313998 | (37.7650751645184, -122.43671325314) | |||
26992 | 26992 | 212838 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 200 Thrift St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5994980.89281 | 2089655.7396 | 37.717509000710294 | -122.45933194993299 | (37.7175090007103, -122.459331949933) | |||
28162 | 28162 | 186644 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984678.2391 | 2105602.2274 | 37.76069603285129 | -122.496118794235 | (37.7606960328513, -122.496118794235) | |||
28979 | 28979 | 181504 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984912.3363 | 2105486.7577 | 37.76039269442371 | -122.49530065358499 | (37.7603926944237, -122.495300653585) | |||
29398 | 29398 | 212839 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5994040.72446 | 2088804.9905 | 37.7151189471444 | -122.46251998093 | (37.7151189471444, -122.46251998093) | |||
31080 | 31080 | 185629 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985036.4592 | 2100328.3844 | 37.746236488209796 | -122.49449110816799 | (37.7462364882098, -122.494491108168) | |||
33293 | 33293 | 186732 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.9467 | 2106397.7058 | 37.762891830958296 | -122.49549023544701 | (37.7628918309583, -122.495490235447) | |||
35036 | 35036 | 212841 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994040.99289 | 2088811.375 | 37.7151364929198 | -122.46251951595801 | (37.7151364929198, -122.462519515958) | |||
35353 | 35353 | 234848 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005792.82845 | 2103474.22766 | 37.7560671816819 | -122.42294157491999 | (37.7560671816819, -122.42294157492) | |||
37473 | 37473 | 184978 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985013.0088 | 2096731.1461 | 37.7363580691948 | -122.494307087101 | (37.7363580691948, -122.494307087101) | |||
38450 | 38450 | 181510 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.096 | 2105522.4031 | 37.7604875665076 | -122.495480496405 | (37.7604875665076, -122.495480496405) | |||
40541 | 40541 | 234849 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005763.2044 | 2103470.66995 | 37.756055741406996 | -122.423043772075 | (37.756055741407, -122.423043772075) | |||
41538 | 41538 | 184980 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984983.2794 | 2096716.9095 | 37.736317239467 | -122.494408823427 | (37.736317239467, -122.494408823427) | |||
43734 | 43734 | 184345 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1251 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984653.0421 | 2106395.6187 | 37.7628729870585 | -122.496264477961 | (37.7628729870585, -122.496264477961) | |||
46924 | 46924 | 212844 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5994040.98422 | 2088821.4693599998 | 37.7151642091297 | -122.462520277695 | (37.7151642091297, -122.462520277695) | |||
49722 | 49722 | 185649 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985036.6757 | 2100513.5002 | 37.746744778509495 | -122.494504003519 | (37.7467447785095, -122.494504003519) | |||
50110 | 50110 | 181518 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984884.7668 | 2105589.5167 | 37.7606732277268 | -122.495403580994 | (37.7606732277268, -122.495403580994) | |||
56749 | 56749 | 234865 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 152 Beaver St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6001951.81755 | 2106805.77476 | 37.7649973174046 | -122.43646349341299 | (37.7649973174046, -122.436463493413) | |||
57195 | 57195 | 117697 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 4049 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5982884.20475 | 2113074.25287 | 37.781106811569295 | -122.50287659442301 | (37.7811068115693, -122.502876594423) | |||
58154 | 58154 | 195951 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6013796.32813 | 2092612.6576200002 | 37.7266919421623 | -122.39450206474 | (37.7266919421623, -122.39450206474) | |||
60069 | 60069 | 186693 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984710.8996 | 2105238.1471 | 37.7596982830602 | -122.49597897832399 | (37.7596982830602, -122.495978978324) | |||
60963 | 60963 | 212843 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5994040.90601 | 2088817.74043 | 37.7151539658718 | -122.46252027770001 | (37.7151539658718, -122.4625202777) | |||
62788 | 62788 | 186734 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.1357 | 2106411.4914 | 37.7629296348625 | -122.495494057173 | (37.7629296348625, -122.495494057173) | |||
64254 | 64254 | 212842 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994041.05729 | 2088814.44589 | 37.715144928561294 | -122.462519515984 | (37.7151449285613, -122.462519515984) | |||
66894 | 66894 | 186651 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984693.4179 | 2105580.4538 | 37.7606371377004 | -122.49606469199 | (37.7606371377004, -122.49606469199) | |||
69092 | 69092 | 212837 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 200 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995022.27605 | 2089654.8730900001 | 37.717509000709995 | -122.459188845314 | (37.71750900071, -122.459188845314) | |||
69316 | 69316 | 186690 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984746.4911 | 2105269.5514 | 37.759786595015704 | -122.495858203478 | (37.7597865950157, -122.495858203478) | |||
69360 | 69360 | 186861 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985166.3388 | 2096333.6885 | 37.735275728405 | -122.49374768930299 | (37.735275728405, -122.493747689303) | |||
72632 | 72632 | 185344 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985013.8462 | 2096976.5182 | 37.7370318443686 | -122.494322273015 | (37.7370318443686, -122.494322273015) | |||
73670 | 73670 | 135656 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1920 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001020.2424800005 | 2121027.2609 | 37.8039928872331 | -122.440705754666 | (37.8039928872331, -122.440705754666) | |||
84095 | 84095 | 185636 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985071.7503 | 2100410.0086 | 37.7464626714536 | -122.49437509338999 | (37.7464626714536, -122.49437509339) | |||
97218 | 97218 | 122540 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 188 Winfield St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 3x3 | 6006859.0 | 2098426.0 | 37.742265997424504 | -122.418896364118 | (37.7422659974245, -122.418896364118) | |||
123303 | 123303 | 234847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005800.09169 | 2103473.84487 | 37.756066540467295 | -122.422916428967 | (37.7560665404673, -122.422916428967) | |||
132650 | 132650 | 212840 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5994040.889169999 | 2088808.5139 | 37.7151286310473 | -122.462519667047 | (37.7151286310473, -122.462519667047) | |||
135191 | 135191 | 135658 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5997134.258640001 | 2115099.71452 | 37.7874953863614 | -122.453725096057 | (37.7874953863614, -122.453725096057) | |||
135263 | 135263 | 135660 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 525 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5997107.47515 | 2114429.48514 | 37.785653579297204 | -122.45376934359699 | (37.7856535792972, -122.453769343597) | |||
137028 | 137028 | 184981 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985000.4471 | 2096704.3477 | 37.7362837528235 | -122.494348542747 | (37.7362837528235, -122.494348542747) |
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");