Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||
| 10303 | 10303 | 93436 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2404 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985728.5988 | 2098924.1036 | 37.7424211954642 | -122.491994435754 | (37.7424211954642, -122.491994435754) | ||
| 10611 | 10611 | 93426 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2150 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986519.4905 | 2098952.531 | 37.7425454476092 | -122.489261896232 | (37.7425454476092, -122.489261896232) | ||
| 10719 | 10719 | 93437 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2408 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985715.4003 | 2098924.442 | 37.7424213531218 | -122.492040096469 | (37.7424213531218, -122.492040096469) | ||
| 10782 | 10782 | 93456 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2039 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:33:00 PM | 3 | 3x3 | 5986815.2712 | 2098896.6914 | 37.7424093879903 | -122.488235084702 | (37.7424093879903, -122.488235084702) | ||
| 10804 | 10804 | 93408 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1440 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:17:00 PM | 3 | 3x3 | 5988695.7955 | 2099025.5303 | 37.7428726808967 | -122.48174230877899 | (37.7428726808967, -122.481742308779) | ||
| 10945 | 10945 | 93434 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986059.5753 | 2098939.671 | 37.742483280315 | -122.490851179477 | (37.742483280315, -122.490851179477) | ||
| 10956 | 10956 | 93428 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2222 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:36:00 PM | 3 | 3x3 | 5986281.7492 | 2098944.9165 | 37.7425106597816 | -122.490083364444 | (37.7425106597816, -122.490083364444) | ||
| 11010 | 11010 | 93431 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2240 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986207.6348 | 2098941.1939 | 37.742496110202296 | -122.49033935278798 | (37.7424961102023, -122.490339352788) | ||
| 11014 | 11014 | 93432 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2244 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986188.6832 | 2098942.886 | 37.7424996493843 | -122.49040500535 | (37.7424996493843, -122.49040500535) | ||
| 11158 | 11158 | 93435 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2302 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986039.9468 | 2098937.3019999997 | 37.742475628974205 | -122.490918873767 | (37.7424756289742, -122.490918873767) | ||
| 11253 | 11253 | 93439 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2545 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985279.5976 | 2098843.1362 | 37.7421726252091 | -122.49354096012199 | (37.7421726252091, -122.493540960122) | ||
| 11256 | 11256 | 93430 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2226 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986248.2454 | 2098943.2244 | 37.742504057158996 | -122.490199084637 | (37.742504057159, -122.490199084637) | ||
| 11517 | 11517 | 93438 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2414 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985694.7566 | 2098925.7957 | 37.7424238632874 | -122.492111574827 | (37.7424238632874, -122.492111574827) | ||
| 11519 | 11519 | 93424 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986662.1353 | 2098956.0844 | 37.7425635298153 | -122.488768940253 | (37.7425635298153, -122.488768940253) | ||
| 11729 | 11729 | 93414 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1722 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:10:00 PM | 3 | 3x3 | 5987827.66 | 2098999.0640000002 | 37.7427494893985 | -122.484742100445 | (37.7427494893985, -122.484742100445) | ||
| 11867 | 11867 | 93415 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1716 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 06:26:00 PM | 3 | 3x3 | 5987861.1638 | 2098998.3872 | 37.7427495822889 | -122.48462620565901 | (37.7427495822889, -122.484626205659) | ||
| 11939 | 11939 | 93441 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2453 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985552.0272 | 2098851.9351 | 37.7422127174882 | -122.492599644801 | (37.7422127174882, -122.492599644801) | ||
| 12074 | 12074 | 93453 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2139 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986521.8595 | 2098886.5388 | 37.7423643889255 | -122.489248854134 | (37.7423643889255, -122.489248854134) | ||
| 12101 | 12101 | 93425 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2122 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986588.0209 | 2098955.4076 | 37.7425573460454 | -122.489025152899 | (37.7425573460454, -122.489025152899) | ||
| 12150 | 12150 | 93452 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2149 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2015 01:35:00 PM | 3 | 3x3 | 5986481.2489 | 2098884.5082 | 37.742356442825105 | -122.489389122116 | (37.7423564428251, -122.489389122116) | ||
| 12231 | 12231 | 93450 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2239 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986205.0967 | 2098876.0477 | 37.7423170879313 | -122.49034333731599 | (37.7423170879313, -122.490343337316) | ||
| 12449 | 12449 | 93447 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2337 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985896.456 | 2098863.5261 | 37.742264676187 | -122.491409586353 | (37.742264676187, -122.491409586353) | ||
| 12625 | 12625 | 93444 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2401 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985736.1286 | 2098858.7036 | 37.74224206476121 | -122.491963586408 | (37.7422420647612, -122.491963586408) | ||
| 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) |
| 12949 | 12949 | 93454 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986642.3376 | 2098891.6151 | 37.742385358930996 | -122.488832656 | (37.742385358931, -122.488832656) | ||
| 12982 | 12982 | 93443 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2409 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985719.2076 | 2098858.0267 | 37.742239217096795 | -122.492022043353 | (37.7422392170968, -122.492022043353) | ||
| 13132 | 13132 | 93433 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2306 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986025.3947 | 2098937.9789 | 37.7424766373979 | -122.490969239699 | (37.7424766373979, -122.490969239699) | ||
| 13160 | 13160 | 91380 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1421 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:27:00 PM | 3 | 3x3 | Permit Number 52077 | 5988771.9062 | 2098963.627 | 37.742707136361105 | -122.48147460973699 | (37.7427071363611, -122.481474609737) | |
| 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) | ||||
| 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) | |||
| 17827 | 17827 | 17125 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1967 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5997619.3207 | 2109172.1957 | 37.7712477652106 | -122.451619154414 | (37.7712477652106, -122.451619154414) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20032 | 20032 | 17103 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1745 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998656.2538 | 2109314.8969 | 37.7716989147196 | -122.44804265122801 | (37.7716989147196, -122.448042651228) | |||
| 21215 | 21215 | 17119 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1931 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997738.0959 | 2109188.8584 | 37.7713003179936 | -122.451209509969 | (37.7713003179936, -122.451209509969) | |||
| 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) | |||
| 22104 | 22104 | 16924 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 508 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 12 | 3X4 | 6004451.24438 | 2110184.3203 | 37.774415694158 | -122.42805938013399 | (37.774415694158, -122.428059380134) | ||
| 22112 | 22112 | 17000 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 940 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002487.5182 | 2109913.8953 | 37.77356187754221 | -122.43483292856399 | (37.7735618775422, -122.434832928564) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 25018 | 25018 | 181957 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2535 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985299.9029 | 2098842.7977 | 37.7421728835811 | -122.493470726805 | (37.7421728835811, -122.493470726805) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 28292 | 28292 | 181330 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2343 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985852.7996 | 2098862.8492 | 37.7422602664155 | -122.49156048482901 | (37.7422602664155, -122.491560484829) | |||
| 29077 | 29077 | 91140 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 342 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52025 | 5989366.26045 | 2113048.7976 | 37.7814157473958 | -122.48045031235 | (37.7814157473958, -122.48045031235) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 58090 | 58090 | 178683 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009800.07713 | 2088901.3026400001 | 37.7162783612237 | -122.408055418121 | (37.7162783612237, -122.408055418121) | |||
| 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) | |
| 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) | |
| 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) | |||
| 63225 | 63225 | 178682 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 583 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002865.41308 | 2090226.6105799999 | 37.71952665220171 | -122.432119544876 | (37.7195266522017, -122.432119544876) | |||
| 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) | |||
| 63888 | 63888 | 30697 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 3 | Permit Number 34612 | 6005370.1769 | 2110115.0914 | 37.774277555648496 | -122.42487568971599 | (37.7742775556485, -122.424875689716) | |
| 66471 | 66471 | 181329 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2319 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985969.5551 | 2098866.9103 | 37.742278239613796 | -122.491157084664 | (37.7422782396138, -122.491157084664) | |||
| 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) | ||||
| 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) | |||
| 70845 | 70845 | 93449 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2301x Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986031.0 | 2098812.3 | 37.7421318842811 | -122.490940612353 | (37.7421318842811, -122.490940612353) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||||
| 85518 | 85518 | 8412 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1590X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004120.4992681 | 2114020.0804586997 | 37.784929023116796 | -122.429477092496 | (37.7849290231168, -122.429477092496) | |||
| 87801 | 87801 | 18262 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003118.209290001 | 2114097.1727299998 | 37.785083900253 | -122.43295020031799 | (37.785083900253, -122.432950200318) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");