Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109026 | 109026 | 94201 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1227 Pierce St | 2 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086.0 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | |||
| 178126 | 178126 | 224454 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 4090 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6003124.6046 | 2104168.08557 | 37.7578214298263 | -122.432218730236 | (37.7578214298263, -122.432218730236) | |||
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 105735 | 105735 | 105666 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 145561 | 145561 | 105665 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 112585 | 112585 | 117548 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 2 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 121639 | 121639 | 117546 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 126638 | 126638 | 117550 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 4 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 104967 | 104967 | 108502 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2300 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.49065574130199 | (37.7441266056665, -122.490655741302) | ||||
| 23642 | 23642 | 176313 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6010259.13784 | 2090270.57035 | 37.7200637812891 | -122.40656510840799 | (37.7200637812891, -122.406565108408) | |||
| 24910 | 24910 | 113499 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | 3x3 | 6011193.56936 | 2090563.5306400002 | 37.7209204242214 | -122.403355677147 | (37.7209204242214, -122.403355677147) | |||
| 28478 | 28478 | 176327 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6009212.31958 | 2089948.46975 | 37.7191207387124 | -122.41016088932699 | (37.7191207387124, -122.410160889327) | |||
| 30294 | 30294 | 176308 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6010842.734619999 | 2090461.59096 | 37.7206209176161 | -122.404561241708 | (37.7206209176161, -122.404561241708) | |||
| 36490 | 36490 | 176307 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6010889.97096 | 2090468.7148799999 | 37.7206431182563 | -122.404398460825 | (37.7206431182563, -122.404398460825) | |||
| 36977 | 36977 | 186970 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1650x Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5986025.4295 | 2095869.2083 | 37.734050611594604 | -122.49074337328301 | (37.7340506115946, -122.490743373283) | |||
| 37371 | 37371 | 176317 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009952.88344 | 2090194.2340000002 | 37.7198370388417 | -122.40761835123199 | (37.7198370388417, -122.407618351232) | |||
| 40506 | 40506 | 176323 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6009342.20287 | 2090002.90208 | 37.719277477945 | -122.40971577078399 | (37.719277477945, -122.409715770784) | |||
| 42868 | 42868 | 176330 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009184.10476 | 2089961.98667 | 37.7191562718235 | -122.41025937136801 | (37.7191562718235, -122.410259371368) | |||
| 44683 | 44683 | 176302 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6011513.54745 | 2090660.92357 | 37.721205711656204 | -122.40225644658301 | (37.7212057116562, -122.402256446583) | |||
| 46745 | 46745 | 176303 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6011115.33526 | 2090539.9745900002 | 37.7208513742667 | -122.40362445389799 | (37.7208513742667, -122.403624453898) | |||
| 53330 | 53330 | 186974 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1600x Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5986249.0864 | 2095869.2083 | 37.7340636742344 | -122.489970132524 | (37.7340636742344, -122.489970132524) | |||
| 58856 | 58856 | 185127 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5989015.4133 | 2095969.6432 | 37.734500589899504 | -122.480413539116 | (37.7345005898995, -122.480413539116) | |||
| 62350 | 62350 | 176309 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010760.4946 | 2090426.07331 | 37.720518796898 | -122.404843021812 | (37.720518796898, -122.404843021812) | |||
| 62801 | 62801 | 176326 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009300.414580001 | 2090007.1642099998 | 37.719286839006706 | -122.40986051846701 | (37.7192868390067, -122.409860518467) | |||
| 64522 | 64522 | 176312 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010340.9019 | 2090322.69069 | 37.720211467072296 | -122.406286146812 | (37.7202114670723, -122.406286146812) | |||
| 64735 | 64735 | 176318 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6009900.75619 | 2090162.07565 | 37.71974582058 | -122.40779627129 | (37.71974582058, -122.40779627129) | |||
| 66989 | 66989 | 176322 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009482.932019999 | 2090051.6391099999 | 37.7194191850237 | -122.40923275838699 | (37.7194191850237, -122.409232758387) | |||
| 70430 | 70430 | 176306 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6010916.0273400005 | 2090472.38873 | 37.7206546619672 | -122.40430865004299 | (37.7206546619672, -122.404308650043) | |||
| 72173 | 72173 | 176321 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009491.13352 | 2090035.22052 | 37.7193745624679 | -122.409203250746 | (37.7193745624679, -122.409203250746) | |||
| 73572 | 73572 | 176297 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011769.33402 | 2090739.1089 | 37.7214346673524 | -122.401377752274 | (37.7214346673524, -122.401377752274) | |||
| 73620 | 73620 | 176316 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009975.17316 | 2090196.6271099998 | 37.7198448575227 | -122.40754147176001 | (37.7198448575227, -122.40754147176) | |||
| 75997 | 75997 | 176325 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009306.38792 | 2090008.2878700001 | 37.7192902591068 | -122.40983995006701 | (37.7192902591068, -122.409839950067) | |||
| 77295 | 77295 | 113498 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | 3x3 | 6011210.15679 | 2090562.2005 | 37.7209176983622 | -122.403298245537 | (37.7209176983622, -122.403298245537) | |||
| 77566 | 77566 | 106463 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 79746 | 79746 | 23414 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X VAN NESS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
| 81628 | 81628 | 6104 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 84076 | 84076 | 6103 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 84752 | 84752 | 106462 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 88594 | 88594 | 112580 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
| 93222 | 93222 | 6106 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 94353 | 94353 | 6101 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 106367 | 106367 | 1854 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 111282 | 111282 | 6100 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 114256 | 114256 | 106577 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 114463 | 114463 | 111293 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005565.0 | 2097823.0 | 37.7405373480538 | -122.42332776776699 | (37.7405373480538, -122.423327767767) | ||||
| 115347 | 115347 | 106464 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 122644 | 122644 | 110235 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2346x CASTRO ST | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 6002664.5 | 2098664.4 | 37.742683511585206 | -122.43341667357402 | (37.7426835115852, -122.433416673574) | ||||
| 128785 | 128785 | 106466 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 130335 | 130335 | 176324 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 43 | Width 0ft | 6009336.81226 | 2089985.3560799998 | 37.719228998190204 | -122.409733166348 | (37.7192289981902, -122.409733166348) | |||
| 131007 | 131007 | 176299 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6011728.48955 | 2090724.05613 | 37.7213910565415 | -122.40151788376998 | (37.7213910565415, -122.40151788377) | |||
| 132300 | 132300 | 185059 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5988840.8776 | 2095965.7184 | 37.7344796690595 | -122.481016672562 | (37.7344796690595, -122.481016672562) | |||
| 138313 | 138313 | 1855 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 142725 | 142725 | 112581 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
| 152100 | 152100 | 176311 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010356.570719999 | 2090296.4274 | 37.7201402299675 | -122.40623013522499 | (37.7201402299675, -122.406230135225) | |||
| 152213 | 152213 | 176314 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | Width 0ft | 6010185.666130001 | 2090251.18564 | 37.720006444117296 | -122.406817710885 | (37.7200064441173, -122.406817710885) | |||
| 153553 | 153553 | 176310 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.720253166839704 | -122.40584244467199 | (37.7202531668397, -122.405842444672) | |||
| 156596 | 156596 | 176329 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009197.90265 | 2089964.9760099999 | 37.719165253359 | -122.41021188808399 | (37.719165253359, -122.410211888084) | |||
| 158228 | 158228 | 176328 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009200.77281 | 2089956.05158 | 37.7191409096134 | -122.41020133724899 | (37.7191409096134, -122.410201337249) | |||
| 158945 | 158945 | 176305 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6010925.6651800005 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) | |||
| 161257 | 161257 | 176304 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011109.46654 | 2090529.17456 | 37.7208213917675 | -122.403643980895 | (37.7208213917675, -122.403643980895) | |||
| 161444 | 161444 | 176333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 12x Canyon Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.708378134509296 | -122.43222153339899 | (37.7083781345093, -122.432221533399) | |||
| 162770 | 162770 | 176300 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011702.065830001 | 2090731.87272 | 37.7214110448664 | -122.401609772869 | (37.7214110448664, -122.401609772869) | |||
| 166075 | 166075 | 113501 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6011166.56458 | 2090559.11661 | 37.720906795881795 | -122.403448714702 | (37.7209067958818, -122.403448714702) | |||
| 166853 | 166853 | 176331 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6009160.31915 | 2089943.1989099998 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | |||
| 174476 | 174476 | 176315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.40725921596399 | (37.7198648386596, -122.407259215964) | |||
| 177490 | 177490 | 176319 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.40830326229602 | (37.7196313144016, -122.408303262296) | |||
| 178932 | 178932 | 176320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | |||
| 183209 | 183209 | 176298 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6011748.91192 | 2090731.5823400002 | 37.7214128614948 | -122.40144781756399 | (37.7214128614948, -122.401447817564) | |||
| 184493 | 184493 | 176301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011617.09806 | 2090687.60598 | 37.7212847557703 | -122.40190037442899 | (37.7212847557703, -122.401900374429) | |||
| 185034 | 185034 | 176332 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | |||
| 1680 | 1680 | 251668 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995349.0 | 2100852.0 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | ||||
| 28658 | 28658 | 187032 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984967.607000001 | 2097835.0603 | 37.73938646460329 | -122.494545412715 | (37.7393864646033, -122.494545412715) | |||
| 41295 | 41295 | 187029 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576933999 | (37.7394074439231, -122.49461576934) | |||
| 43878 | 43878 | 187030 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984957.5185 | 2097843.1311 | 37.7394080343891 | -122.49458088860901 | (37.7394080343891, -122.494580888609) | |||
| 58693 | 58693 | 218793 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998053.08406 | 2095010.8668400003 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | |||
| 72098 | 72098 | 187038 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | |||
| 78735 | 78735 | 94388 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | ||
| 83515 | 83515 | 94380 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 84196 | 84196 | 94383 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87589 | 87589 | 94384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87626 | 87626 | 94379 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 95304 | 95304 | 94385 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 100408 | 100408 | 94381 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 110217 | 110217 | 94377 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 116794 | 116794 | 94386 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 120294 | 120294 | 113893 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5x STORRIE ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 60 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 125326 | 125326 | 94378 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 127453 | 127453 | 94387 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 131781 | 131781 | 187031 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984966.2618 | 2097842.7948 | 37.7394076227298 | -122.494550633787 | (37.7394076227298, -122.494550633787) | |||
| 143608 | 143608 | 94382 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 144910 | 144910 | 113889 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 90 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 182619 | 182619 | 187037 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984959.5362 | 2097794.0341 | 37.7392733453171 | -122.49457029390899 | (37.7392733453171, -122.494570293909) | |||
| 80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
| 31769 | 31769 | 224212 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005187.142969999 | 2097371.8747799997 | 37.739277327390795 | -122.42460216947501 | (37.7392773273908, -122.424602169475) | ||||
| 34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) |
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");