Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
| 44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 65 | 65 | 226926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
| 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) | |||
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 6044 | 6044 | 107491 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6011446.048280001 | 2119975.7461599996 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | ||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
| 8632 | 8632 | 99720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007185.20399 | 2119756.67852 | 37.8008533386708 | -122.41928126041701 | (37.8008533386708, -122.419281260417) | |||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
| 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) | ||
| 10717 | 10717 | 25296 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 158 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000552.574130001 | 2091731.5353 | 37.723527432941204 | -122.44022202823 | (37.7235274329412, -122.44022202823) | |||
| 11045 | 11045 | 27100 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 675 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005860.0759 | 2093589.7540900002 | 37.728930444682206 | -122.422006859139 | (37.7289304446822, -122.422006859139) | |||
| 11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
| 11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
| 12269 | 12269 | 106828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | |||
| 14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 15377 | 15377 | 25938 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6012867.3394 | 2097145.5573099998 | 37.739086658519895 | -122.39803142710899 | (37.7390866585199, -122.398031427109) | ||
| 15925 | 15925 | 25939 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6012857.31615 | 2097153.53613 | 37.7391080084261 | -122.39806664277201 | (37.7391080084261, -122.398066642772) | ||
| 16907 | 16907 | 16140 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 370 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999741.99698 | 2094725.2386 | 37.7317012657937 | -122.44323895423099 | (37.7317012657937, -122.443238954231) | |||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 17854 | 17854 | 4283 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001860.11761 | 2100274.84005 | 37.7470597321331 | -122.436313221179 | (37.7470597321331, -122.436313221179) | ||
| 17954 | 17954 | 16098 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | ||
| 18293 | 18293 | 4370 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001204.190330001 | 2096097.5771700002 | 37.7355526592134 | -122.438282146497 | (37.7355526592134, -122.438282146497) | ||
| 18654 | 18654 | 16099 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000036.69943 | 2094718.89433 | 37.7317006461483 | -122.442219656332 | (37.7317006461483, -122.442219656332) | |||
| 18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
| 19631 | 19631 | 16102 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000017.68556 | 2094719.9660099999 | 37.7317025050652 | -122.442285467815 | (37.7317025050652, -122.442285467815) | |||
| 21152 | 21152 | 4284 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001863.40945 | 2100279.02786 | 37.747071417908 | -122.43630213795299 | (37.747071417908, -122.436302137953) | ||
| 21395 | 21395 | 16100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000028.57256 | 2094720.41703 | 37.7317043639536 | -122.442247861742 | (37.7317043639536, -122.442247861742) | |||
| 21593 | 21593 | 16127 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 330 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999874.93833 | 2094721.1240700001 | 37.7316975479954 | -122.442779055318 | (37.7316975479954, -122.442779055318) | |||
| 22554 | 22554 | 17779 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1777 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005479.2802 | 2115475.38688 | 37.789001770571296 | -122.424879716433 | (37.7890017705713, -122.424879716433) | |||
| 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) | |||
| 23567 | 23567 | 137685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 720 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000552.856000001 | 2111474.7278 | 37.7777374972355 | -122.441637228704 | (37.7777374972355, -122.441637228704) | |||
| 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) | |||
| 24727 | 24727 | 129157 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5997198.13027 | 2114418.3589 | 37.785628226512706 | -122.45345490104499 | (37.7856282265127, -122.453454901045) | |||
| 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) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 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) | |||
| 24920 | 24920 | 226888 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007787.28925 | 2099470.27806 | 37.745185579151396 | -122.415760542322 | (37.7451855791514, -122.415760542322) | |||
| 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) | |||
| 25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
| 25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
| 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) | |||
| 26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
| 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) | |||
| 26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
| 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) | |||
| 26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
| 26965 | 26965 | 66051 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1632 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1990 12:00:00 AM | 12 | Permit Number 29090 | 6002925.71156 | 2121006.29112 | 37.8040436368686 | -122.434110258988 | (37.8040436368686, -122.434110258988) | ||
| 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) | |||
| 27010 | 27010 | 61931 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1407 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1985 12:00:00 AM | 11 | Permit Number 21986 | 6011381.98525 | 2120211.6051 | 37.8023379197065 | -122.404790601229 | (37.8023379197065, -122.404790601229) | ||
| 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) | ||||
| 27285 | 27285 | 118936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.21349 | 2109713.8297599996 | 37.7717754261179 | -122.508777876355 | (37.7717754261179, -122.508777876355) | |||
| 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) | ||||
| 27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
| 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) | |||
| 27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
| 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) | |||
| 28070 | 28070 | 190826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6016386.63874 | 2108737.40916 | 37.771110828636296 | -122.38667129537 | (37.7711108286363, -122.38667129537) | |||
| 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) | |||
| 28089 | 28089 | 94904 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3701 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5997050.00292 | 2115323.90542 | 37.788106124051 | -122.454032799976 | (37.788106124051, -122.454032799976) | |||
| 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) | |||
| 28768 | 28768 | 110918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014775.51071 | 2113108.67341 | 37.7830240119856 | -122.392550107818 | (37.7830240119856, -122.392550107818) |
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");