Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 23498 | 23498 | 176772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 6007351.78047 | 2093548.13266 | 37.72890017978 | -122.41684696742901 | (37.72890017978, -122.416846967429) | |||
| 23542 | 23542 | 176768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 955 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6007502.25565 | 2093569.5745700002 | 37.7289675174267 | -122.416328280725 | (37.7289675174267, -122.416328280725) | |||
| 23730 | 23730 | 219413 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999418.48835 | 2095681.2919599998 | 37.734307911173204 | -122.444426068323 | (37.7343079111732, -122.444426068323) | |||
| 23847 | 23847 | 226860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22961 | 2096323.57705 | 37.7361509008315 | -122.43965349751801 | (37.7361509008315, -122.439653497518) | |||
| 23881 | 23881 | 129298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6006767.5192599995 | 2119403.73147 | 37.799860702966 | -122.420701557924 | (37.799860702966, -122.420701557924) | |||
| 24179 | 24179 | 226965 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 26 Danvers St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5999778.9374 | 2105368.70326 | 37.7609277664162 | -122.44387566164801 | (37.7609277664162, -122.443875661648) | |||
| 24188 | 24188 | 247556 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6000035.32206 | 2108353.94379 | 37.7691391145131 | -122.443203353661 | (37.7691391145131, -122.443203353661) | |||
| 24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
| 24254 | 24254 | 219293 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 480 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998219.47976 | 2094421.4454299998 | 37.7307801864506 | -122.448480709434 | (37.7307801864506, -122.448480709434) | |||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 24753 | 24753 | 129266 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 24 Priest St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6008334.4403800005 | 2117141.01825 | 37.7937360410291 | -122.41511915572399 | (37.7937360410291, -122.415119155724) | |||
| 24785 | 24785 | 129216 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000537.3614300005 | 2117487.89488 | 37.794247216575606 | -122.442122575399 | (37.7942472165756, -122.442122575399) | |||
| 24886 | 24886 | 219309 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998711.42236 | 2092939.4829099998 | 37.7267391799504 | -122.446673405767 | (37.7267391799504, -122.446673405767) | |||
| 25043 | 25043 | 190777 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1250 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6014189.92463 | 2104827.29978 | 37.760252667849706 | -122.393996098953 | (37.7602526678497, -122.393996098953) | |||
| 25101 | 25101 | 206960 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998473.38947 | 2095013.2793400001 | 37.7324197368658 | -122.44764549463899 | (37.7324197368658, -122.447645494639) | ||||
| 25117 | 25117 | 219340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5993976.2548 | 2087899.9330400003 | 37.7126301615391 | -122.462677198595 | (37.7126301615391, -122.462677198595) | |||
| 25137 | 25137 | 129270 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1369 Hyde St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6007506.26777 | 2117001.25195 | 37.793305701954004 | -122.417974800922 | (37.793305701954, -122.417974800922) | |||
| 25718 | 25718 | 176724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Silliman St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005480.83826 | 2092738.2956599998 | 37.7265711308422 | -122.423257411423 | (37.7265711308422, -122.423257411423) | |||
| 26195 | 26195 | 129135 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5999824.8933 | 2119535.0164400004 | 37.7998274397471 | -122.444735000739 | (37.7998274397471, -122.444735000739) | |||
| 26334 | 26334 | 129315 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1847 Leavenworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6007744.83863 | 2118772.65589 | 37.7981829610394 | -122.417274913428 | (37.7981829610394, -122.417274913428) | |||
| 26463 | 26463 | 226989 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 18 Arlington St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6005175.47841 | 2097541.63022 | 37.739742778711204 | -122.424654572944 | (37.7397427787112, -122.424654572944) | |||
| 26630 | 26630 | 206935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000034.8522 | 2094044.21533 | 37.7298480292542 | -122.442177629193 | (37.7298480292542, -122.442177629193) | |||
| 26732 | 26732 | 219280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Paradise Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 6001093.95551 | 2095893.7470200001 | 37.734986718566105 | -122.438648668815 | (37.7349867185661, -122.438648668815) | |||
| 26877 | 26877 | 176791 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 241 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6008533.10117 | 2094294.56275 | 37.731016093010204 | -122.41281579411199 | (37.7310160930102, -122.412815794112) | |||
| 26975 | 26975 | 129323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Florence St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | ||||
| 26978 | 26978 | 176852 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6004182.999 | 2091286.4234200001 | 37.7225112799465 | -122.427640598252 | (37.7225112799465, -122.427640598252) | |||
| 27272 | 27272 | 206957 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998473.21835 | 2095005.05828 | 37.7323971540007 | -122.447645494648 | (37.7323971540007, -122.447645494648) | ||||
| 27303 | 27303 | 129201 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002306.14505 | 2121870.94259 | 37.8063825585658 | -122.43631622670799 | (37.8063825585658, -122.436316226708) | |||
| 27318 | 27318 | 176739 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 318 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007769.14827 | 2092407.95318 | 37.725792959174 | -122.41532341065 | (37.725792959174, -122.41532341065) | |||
| 27332 | 27332 | 176698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004617.240230001 | 2091470.03605 | 37.72303999319411 | -122.42615258897 | (37.7230399931941, -122.42615258897) | ||||
| 27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
| 27530 | 27530 | 249494 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005708.87609 | 2115852.08373 | 37.790049051771 | -122.42411214416401 | (37.790049051771, -122.424112144164) | |||
| 27727 | 27727 | 129285 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1725 Jones St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008285.46318 | 2118399.2200599997 | 37.79718799969079 | -122.41537773598999 | (37.7971879996908, -122.41537773599) | |||
| 27860 | 27860 | 176667 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Santa Rosa Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000731.05105 | 2093595.2382 | 37.7286548942011 | -122.43973861924499 | (37.7286548942011, -122.439738619245) | |||
| 27868 | 27868 | 226847 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 565 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6002862.54514 | 2099747.2239599996 | 37.7456679278515 | -122.43280922866501 | (37.7456679278515, -122.432809228665) | |||
| 27887 | 27887 | 176613 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5998491.328480001 | 2088788.6230099997 | 37.7153293039925 | -122.447135664507 | (37.7153293039925, -122.447135664507) | |||
| 27937 | 27937 | 176651 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 314 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002207.18384 | 2094067.78615 | 37.730036314028 | -122.434669323428 | (37.730036314028, -122.434669323428) | |||
| 28072 | 28072 | 176805 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 472 Gaven St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008072.53583 | 2094580.3018900002 | 37.7317748087483 | -122.41442826236099 | (37.7317748087483, -122.414428262361) | |||
| 28078 | 28078 | 129229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000617.83995 | 2117501.7173200003 | 37.794289755430796 | -122.44184510397 | (37.7942897554308, -122.44184510397) | |||
| 28264 | 28264 | 176811 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008163.14276 | 2093697.53873 | 37.729356020957105 | -122.414052586778 | (37.7293560209571, -122.414052586778) | |||
| 28290 | 28290 | 124056 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5991955.56775 | 2111031.62491 | 37.776027276009 | -122.471345630007 | (37.776027276009, -122.471345630007) | |||
| 28378 | 28378 | 226920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4112 23rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6002387.67518 | 2102409.13417 | 37.75294995968729 | -122.43464156316001 | (37.7529499596873, -122.43464156316) | |||
| 28406 | 28406 | 219344 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991912.69269 | 2089165.54418 | 37.71598616072 | -122.469901542523 | (37.71598616072, -122.469901542523) | |||
| 28529 | 28529 | 129173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2901 Steiner St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001992.763069999 | 2118215.18241 | 37.7963269932617 | -122.437138827596 | (37.7963269932617, -122.437138827596) | |||
| 28788 | 28788 | 129185 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999586.95971 | 2121459.2161 | 37.8050971935371 | -122.445696789672 | (37.8050971935371, -122.445696789672) | |||
| 28808 | 28808 | 129341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6007472.08384 | 2121212.09706 | 37.80486570266171 | -122.418391787764 | (37.8048657026617, -122.418391787764) | |||
| 28909 | 28909 | 176778 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6008224.08958 | 2093491.7864599999 | 37.728794492350396 | -122.41382733896499 | (37.7287944923504, -122.413827338965) | |||
| 29100 | 29100 | 129254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008749.8874699995 | 2117004.3190200003 | 37.7933840364978 | -122.413671993685 | (37.7933840364978, -122.413671993685) | |||
| 29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
| 29238 | 29238 | 176752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Gambier St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6005769.79082 | 2093316.51308 | 37.7281750924071 | -122.422299575881 | (37.7281750924071, -122.422299575881) | |||
| 29588 | 29588 | 176728 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1831 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005368.22996 | 2092645.7174900002 | 37.726310575669295 | -122.423640115208 | (37.7263105756693, -122.423640115208) | |||
| 29615 | 29615 | 219408 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 826 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5999474.92133 | 2095660.53825 | 37.7342541461187 | -122.44422947111799 | (37.7342541461187, -122.444229471118) | |||
| 29666 | 29666 | 226988 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 18 Arlington St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6005176.38711 | 2097549.1244 | 37.73976340735629 | -122.42465196401301 | (37.7397634073563, -122.424651964013) | |||
| 29711 | 29711 | 218145 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5994144.20993 | 2090116.67038 | 37.7187264660332 | -122.462257368104 | (37.7187264660332, -122.462257368104) | ||||
| 29869 | 29869 | 190789 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6012459.01369 | 2105136.91709 | 37.761006457089 | -122.400004286971 | (37.761006457089, -122.400004286971) | |||
| 29956 | 29956 | 176692 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004473.28311 | 2091848.82103 | 37.72407191576529 | -122.426677180615 | (37.7240719157653, -122.426677180615) | ||||
| 29962 | 29962 | 129123 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2495 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001080.52047 | 2118605.3023200002 | 37.7973462632737 | -122.44032336202801 | (37.7973462632737, -122.440323362028) | |||
| 30012 | 30012 | 129133 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5999835.3006 | 2119536.2494799998 | 37.799831419239204 | -122.44469907640301 | (37.7998314192392, -122.444699076403) | |||
| 30337 | 30337 | 176758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 663 Silver Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005749.694519999 | 2093584.4330799999 | 37.728909608285704 | -122.42238807817101 | (37.7289096082857, -122.422388078171) | |||
| 30448 | 30448 | 122000 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3848 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991408.48983 | 2110002.47291 | 37.773169842884 | -122.473163026058 | (37.773169842884, -122.473163026058) | |||
| 30656 | 30656 | 176851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6004177.9913099995 | 2091279.54891 | 37.7224921207944 | -122.427657419158 | (37.7224921207944, -122.427657419158) | |||
| 30727 | 30727 | 129276 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1762 Washington St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6006164.04315 | 2116981.80981 | 37.7931766860951 | -122.422617614837 | (37.7931766860951, -122.422617614837) | |||
| 31157 | 31157 | 206941 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5998788.54531 | 2094148.8010200001 | 37.7300640895797 | -122.446493759872 | (37.7300640895797, -122.446493759872) | |||
| 31245 | 31245 | 219282 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 201 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5999962.0472099995 | 2094329.87548 | 37.7306282360949 | -122.44244982431299 | (37.7306282360949, -122.442449824313) | |||
| 31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
| 31904 | 31904 | 226984 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2323 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6001664.11704 | 2096982.04185 | 37.738007342550794 | -122.436755300925 | (37.7380073425508, -122.436755300925) | |||
| 32036 | 32036 | 176732 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 462 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007785.763719999 | 2091661.92409 | 37.7237454564679 | -122.415213186138 | (37.7237454564679, -122.415213186138) | |||
| 32089 | 32089 | 219321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.45909980971201 | (37.7216008413857, -122.459099809712) | |||
| 32303 | 32303 | 219349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992970.2206 | 2090529.11347 | 37.719791266033 | -122.466345302087 | (37.719791266033, -122.466345302087) | |||
| 32430 | 32430 | 176689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6004476.46951 | 2091852.67463 | 37.72408267705 | -122.426666440004 | (37.72408267705, -122.426666440004) | ||||
| 32651 | 32651 | 219322 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.87033 | 2091157.1990200002 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | |||
| 32661 | 32661 | 176624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Foote Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998633.901980001 | 2088379.60151 | 37.714214369464 | -122.446613458762 | (37.714214369464, -122.446613458762) | |||
| 32893 | 32893 | 176636 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009567.85058 | 2090563.67809 | 37.7208298948579 | -122.40897533376301 | (37.7208298948579, -122.408975333763) | |||
| 32920 | 32920 | 129104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6000393.5421400005 | 2118227.4889 | 37.7962697496128 | -122.442673334618 | (37.7962697496128, -122.442673334618) | |||
| 33141 | 33141 | 176785 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 194 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6009137.47484 | 2093394.32671 | 37.7285781415571 | -122.41066281353999 | (37.7285781415571, -122.41066281354) | |||
| 33330 | 33330 | 129143 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999331.215369999 | 2120442.50933 | 37.8022909867986 | -122.44650862838199 | (37.8022909867986, -122.446508628382) | |||
| 33355 | 33355 | 129290 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1455 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6006103.4711 | 2119303.6940200003 | 37.799548577059205 | -122.42299230206899 | (37.7995485770592, -122.422992302069) | |||
| 33441 | 33441 | 248140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 268 Rutledge St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6009882.82604 | 2099441.40705 | 37.7452238857837 | -122.408512467075 | (37.7452238857837, -122.408512467075) | |||
| 33747 | 33747 | 226990 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002949.15348 | 2097822.0657099998 | 37.740386802104204 | -122.432372276886 | (37.7403868021042, -122.432372276886) | |||
| 33935 | 33935 | 226974 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 233 Arbor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6001270.1389999995 | 2096845.7649599998 | 37.7376107595169 | -122.4381077158 | (37.7376107595169, -122.4381077158) | |||
| 33950 | 33950 | 176781 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008506.492819999 | 2093591.6358299998 | 37.7290845129336 | -122.41285810544399 | (37.7290845129336, -122.412858105444) | |||
| 34113 | 34113 | 129193 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5999321.34267 | 2119401.25907 | 37.799431429569395 | -122.446467838743 | (37.7994314295694, -122.446467838743) | |||
| 34168 | 34168 | 226851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 50 Digby St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6002882.53015 | 2097620.47975 | 37.7398295156191 | -122.43258823826599 | (37.7398295156191, -122.432588238266) | |||
| 34356 | 34356 | 227013 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5549 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001761.53629 | 2097297.86137 | 37.738880045571 | -122.436441072418 | (37.738880045571, -122.436441072418) | |||
| 34410 | 34410 | 129343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 310 Green St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6011372.9134599995 | 2119406.36194 | 37.800126411255995 | -122.40476527089399 | (37.800126411256, -122.404765270894) | |||
| 34424 | 34424 | 206951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998696.40165 | 2093529.6745 | 37.7283588499644 | -122.44676777970501 | (37.7283588499644, -122.446767779705) | |||
| 34438 | 34438 | 176721 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005098.35657 | 2092750.06265 | 37.7265818471717 | -122.42458047420799 | (37.7265818471717, -122.424580474208) | ||||
| 34520 | 34520 | 226931 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6002625.7141 | 2099687.43852 | 37.7454903360096 | -122.43362388225799 | (37.7454903360096, -122.433623882258) | |||
| 34647 | 34647 | 129297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006764.06719 | 2119403.1905 | 37.799859023038 | -122.420713464975 | (37.799859023038, -122.420713464975) | |||
| 34712 | 34712 | 176663 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Lamartine St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6002669.49931 | 2094359.4125400002 | 37.7308632891975 | -122.433091871219 | (37.7308632891975, -122.433091871219) | |||
| 34914 | 34914 | 176818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 695 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009866.42198 | 2091203.0617799999 | 37.722602230178 | -122.407988325128 | (37.722602230178, -122.407988325128) | |||
| 34919 | 34919 | 176670 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Camellia Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003267.33366 | 2094058.1298900002 | 37.730069928882706 | -122.43100356717501 | (37.7300699288827, -122.431003567175) | |||
| 34985 | 34985 | 129161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997429.44136 | 2114454.7075099996 | 37.7857412865759 | -122.452657259939 | (37.7857412865759, -122.452657259939) | |||
| 34986 | 34986 | 129263 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 6009008.56152 | 2117982.3464099998 | 37.796083982049 | -122.41284613813299 | (37.796083982049, -122.412846138133) | |||
| 35124 | 35124 | 226997 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 147 Beacon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6003368.6222 | 2097143.53298 | 37.7385474834888 | -122.430873508099 | (37.7385474834888, -122.430873508099) | |||
| 35227 | 35227 | 226980 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Farnum St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 3ft | 6002461.28051 | 2097299.02865 | 37.73892298731379 | -122.434021768396 | (37.7389229873138, -122.434021768396) | |||
| 35316 | 35316 | 219317 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5995097.23073 | 2091960.8022599998 | 37.7238448414569 | -122.45909664051001 | (37.7238448414569, -122.45909664051) | |||
| 35455 | 35455 | 129147 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000543.90951 | 2121371.39176 | 37.8049106408804 | -122.442378852499 | (37.8049106408804, -122.442378852499) |
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");