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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72613 | 72613 | 212834 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2622 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991449.17538 | 2097558.9485400002 | 37.7390055522499 | -122.472115105035 | (37.7390055522499, -122.472115105035) | |||
| 89147 | 89147 | 93429 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2222 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986343.0 | 2098927.0 | 37.742465042516706 | -122.489870262796 | (37.7424650425167, -122.489870262796) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 124086 | 124086 | 3 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2X 12th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.57585 | 2114853.19204 | 37.7865283500331 | -122.471139790973 | (37.7865283500331, -122.471139790973) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 34940 | 34940 | 244280 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 575 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004261.3266 | 2110092.3934 | 37.77415253865129 | -122.42870978718099 | (37.7741525386513, -122.428709787181) | |||
| 60571 | 60571 | 30701 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 241 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | Permit Number 34613 | 6005368.9614 | 2110093.8196 | 37.7742190797874 | -122.42487838067 | (37.7742190797874, -122.42487838067) | |
| 60903 | 60903 | 135662 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1430 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004430.55292 | 2120513.3454 | 37.802775426403606 | -122.42886748667101 | (37.8027754264036, -122.428867486671) | |||
| 76677 | 76677 | 244964 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 250 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005290.5596 | 2110104.7594 | 37.774244689119 | -122.42515036540199 | (37.774244689119, -122.425150365402) | |||
| 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) | |||
| 53954 | 53954 | 47883 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1422 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 5 | Permit Number 45630 | 5982178.8025 | 2105387.2339 | 37.7599590039895 | -122.504747143589 | (37.7599590039895, -122.504747143589) | |
| 55292 | 55292 | 234854 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007573.33331 | 2098019.6233599996 | 37.7411903742509 | -122.41639763464799 | (37.7411903742509, -122.416397634648) | |||
| 63869 | 63869 | 121932 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 344 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990915.4532 | 2113093.93697 | 37.7816295951245 | -122.475094208069 | (37.7816295951245, -122.475094208069) | |||
| 71138 | 71138 | 30700 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34612 | 6005310.6159 | 2110107.7982 | 37.7742541659126 | -122.425081203232 | (37.7742541659126, -122.425081203232) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 148572 | 148572 | 135659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5997134.75197 | 2115094.07357 | 37.7874799260983 | -122.453722981751 | (37.7874799260983, -122.453722981751) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18858 | 18858 | 17137 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2045 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997217.7067 | 2109114.9444 | 37.7710675601361 | -122.453004213188 | (37.7710675601361, -122.453004213188) | |||
| 19296 | 19296 | 17136 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2041 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997241.2054 | 2109118.3624 | 37.7710782917307 | -122.45292317759301 | (37.7710782917307, -122.452923177593) | |||
| 19523 | 19523 | 16915 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 484 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004711.24143 | 2110219.61063 | 37.7745272991249 | -122.42716251506 | (37.7745272991249, -122.42716251506) | |||
| 21894 | 21894 | 17095 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1661 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999030.0966 | 2109360.6125 | 37.7718458009941 | -122.446752800648 | (37.7718458009941, -122.446752800648) | |||
| 22581 | 22581 | 16398 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006124.74935 | 2114015.2727900003 | 37.7850290954547 | -122.422542679726 | (37.7850290954547, -122.422542679726) | ||
| 22586 | 22586 | 16396 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006093.31996 | 2114011.54372 | 37.7850170832184 | -122.422651150523 | (37.7850170832184, -122.422651150523) | ||
| 22735 | 22735 | 16395 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006070.4864 | 2114008.23449 | 37.7850067086413 | -122.42272991225201 | (37.7850067086413, -122.422729912252) | ||
| 22771 | 22771 | 16397 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006110.1202 | 2114012.78935 | 37.785021451230705 | -122.422593115487 | (37.7850214512307, -122.422593115487) | ||
| 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) | |||
| 24985 | 24985 | 30698 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34612 | 6005345.2585 | 2110114.4836 | 37.7742744792738 | -122.42496184383499 | (37.7742744792738, -122.424961843835) | |
| 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) | |||
| 27987 | 27987 | 139151 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003144.9445 | 2114104.5849 | 37.7851057685851 | -122.43285823467801 | (37.7851057685851, -122.432858234678) | |||
| 49392 | 49392 | 49889 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1430@ OCTAVIA Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 6 | Permit Number 46660 | 6004450.34869 | 2120515.08924 | 37.8027813349583 | -122.42879910759599 | (37.8027813349583, -122.428799107596) | |
| 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) | |||
| 91939 | 91939 | 122722 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1385 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007219.0 | 2107431.0 | 37.76701193031621 | -122.41828991357599 | (37.7670119303162, -122.418289913576) | |||
| 93139 | 93139 | 18222 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1643X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6004309.242075901 | 2114268.2781924 | 37.7856211964399 | -122.428841803498 | (37.7856211964399, -122.428841803498) | ||
| 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) | |||
| 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) | |||
| 150305 | 150305 | 234860 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 2 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000574.359 | 2100517.55086 | 37.7476530184698 | -122.44077666170799 | (37.7476530184698, -122.440776661708) | ||||
| 159891 | 159891 | 234861 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 60 Zircon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002321.72608 | 2098705.6175700002 | 37.7427772324719 | -122.434604832164 | (37.7427772324719, -122.434604832164) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 39854 | 39854 | 55830 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 170 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 7 | Permit Number 11879 | 5992452.285209999 | 2114337.35562 | 37.7851326311765 | -122.469868105299 | (37.7851326311765, -122.469868105299) | ||
| 52703 | 52703 | 234862 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007596.66098 | 2097957.46338 | 37.741021008521 | -122.41631257406 | (37.741021008521, -122.41631257406) | |||
| 53631 | 53631 | 244281 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 565 Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004280.5399 | 2110094.8567 | 37.7741603896423 | -122.42864350060499 | (37.7741603896423, -122.428643500605) | |||
| 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) | |||
| 59264 | 59264 | 52753 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 59@ ROLPH Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2006 12:00:00 AM | 7 | Permit Number 48796 | 6000913.35841 | 2088160.63266 | 37.713743072553 | -122.438719109114 | (37.713743072553, -122.438719109114) | |
| 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) | |||
| 72690 | 72690 | 39956 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 370 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 7 | Permit Number 41218 | 6009202.76969 | 2088674.77745 | 37.7156229083553 | -122.41010402697901 | (37.7156229083553, -122.410104026979) | |
| 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) | |||
| 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) | |||
| 156075 | 156075 | 135657 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5997133.32261 | 2115106.1258900003 | 37.7875129366126 | -122.453728797662 | (37.7875129366126, -122.453728797662) | |||
| 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) | |||
| 170730 | 170730 | 212836 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 410 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.20141 | 2091321.95288 | 37.7220730592142 | -122.46011172240101 | (37.7220730592142, -122.460111722401) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 12731 | 12731 | 38212 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 108 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40335 | 6011170.868009999 | 2092548.53605 | 37.726369572089894 | -122.403573737557 | (37.7263695720899, -122.403573737557) |
| 23297 | 23297 | 17101 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1711 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 5998684.4523 | 2109317.8876 | 37.771708738288105 | -122.447945326623 | (37.7717087382881, -122.447945326623) | |||
| 30095 | 30095 | 139152 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003164.7154 | 2114107.1359 | 37.7851138943196 | -122.432790015912 | (37.7851138943196, -122.432790015912) | |||
| 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) | |||
| 56065 | 56065 | 139135 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003465.1068 | 2114153.0556 | 37.785257010462 | -122.43175403601299 | (37.785257010462, -122.431754036013) | |||
| 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) | |||
| 61982 | 61982 | 234857 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 125 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007057.29918 | 2098677.05689 | 37.74296650740129 | -122.418228500567 | (37.7429665074013, -122.418228500567) | |||
| 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) | |||
| 76142 | 76142 | 234859 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 6000570.21064 | 2100519.3738 | 37.7476577875765 | -122.44079113720801 | (37.7476577875765, -122.440791137208) | ||||
| 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) | |||
| 167550 | 167550 | 135661 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3130 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5999056.0318599995 | 2119564.3251400003 | 37.7998640079851 | -122.447397647785 | (37.7998640079851, -122.447397647785) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 49412 | 49412 | 139153 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003212.5485 | 2114113.5137 | 37.785134118902 | -122.432624984211 | (37.785134118902, -122.432624984211) | |||
| 68838 | 68838 | 106982 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1737-1795 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 6003656.2329 | 2114175.7467 | 37.7853301466286 | -122.431094418652 | (37.7853301466286, -122.431094418652) | ||||
| 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) | |
| 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) | |||
| 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) | |||
| 2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
| 26169 | 26169 | 234856 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6008485.30896 | 2095795.27692 | 37.735134047297294 | -122.413087094406 | (37.7351340472973, -122.413087094406) | |||
| 6315 | 6315 | 18251 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003359.8742 | 2114137.1113 | 37.7852072657709 | -122.432116969328 | (37.7852072657709, -122.432116969328) | |||
| 8545 | 8545 | 8434 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 12 | 3X3 | 6003465.1068 | 2113959.1725 | 37.784724656301705 | -122.4317401882 | (37.7847246563017, -122.4317401882) | ||
| 17530 | 17530 | 16968 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 767 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003330.7652 | 2109962.2092 | 37.7737423751934 | -122.431919463762 | (37.7737423751934, -122.431919463762) | |||
| 17619 | 17619 | 17030 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1159 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001449.2469 | 2109707.3473 | 37.772935745446404 | -122.438409655481 | (37.7729357454464, -122.438409655481) | |||
| 18537 | 18537 | 17028 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1140 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001519.83997 | 2109777.5071900003 | 37.7731324020756 | -122.438170492981 | (37.7731324020756, -122.438170492981) | |||
| 19579 | 19579 | 17029 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1153 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001512.0667 | 2109715.9891 | 37.772963046680395 | -122.438192973878 | (37.7729630466804, -122.438192973878) |
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");