Street_Tree_List

Data source: data.sfgov.org

227 rows where qSpecies = 168

View and edit SQL

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
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)
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 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 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)
10492 93427 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2150 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5986487.6789 2098952.531 37.7425435906318 -122.48937188989099 (37.7425435906318, -122.489371889891)
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 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 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 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 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 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 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 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)
11156 93446 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2343 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5985872.427999999 2098863.1876 37.7422623426363 -122.491492641715 (37.7422623426363, -122.491492641715)
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)
11200 93423 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2048 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/20/2015 12:49:00 PM 3 3x3   5986826.7775 2098962.0068 37.7425893979873 -122.488200098519 (37.7425893979873, -122.488200098519)
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 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 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 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 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 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 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 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 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 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)
12217 93451 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2239 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5986220.3256 2098876.0477 37.742317977353395 -122.490290681149 (37.7423179773534, -122.490290681149)
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 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 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)
12639 93455 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2109 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5986657.5666 2098892.2919 37.7423881059963 -122.488780049158 (37.7423881059963, -122.488780049158)
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 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 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 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 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)
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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 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 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 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)
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 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 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)
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 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 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 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)
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)
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)
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 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)
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)
29058 181956 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2453 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5985572.3325 2098853.6272 37.7422185507809 -122.492529560952 (37.7422185507809, -122.492529560952)
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)
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)
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)
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 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)
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)
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 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)
35616 185394 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2300 Sunset Blvd 4 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985078.642000001 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761)
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 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)
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)
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 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)
42841 178684 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 161 Delta St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009805.30528 2088917.07553 37.716321963062 -122.40803845872401 (37.716321963062, -122.408038458724)
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)
43887 72500 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2311 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/10/1996 12:00:00 AM 1     5986050.4379 2098869.9561 37.7422913280707 -122.49087764471001 (37.7422913280707, -122.49087764471)
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)
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 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)
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)
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 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)
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 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 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)
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 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)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 64.757ms · Data source: data.sfgov.org