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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 30388 | 30388 | 226889 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 21 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009640.71829 | 2098586.38073 | 37.7428626087272 | -122.409289311345 | (37.7428626087272, -122.409289311345) | |||
| 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) | |||
| 30510 | 30510 | 30812 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 5 | Permit Number 34674 | 6001381.93618 | 2094967.05294 | 37.7324586091634 | -122.43758667648001 | (37.7324586091634, -122.43758667648) | |
| 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) | |||
| 30977 | 30977 | 226957 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4415 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001675.32551 | 2104070.79205 | 37.75747200635521 | -122.437223965526 | (37.7574720063552, -122.437223965526) | |||
| 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) | |||
| 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) | |||
| 33037 | 33037 | 60417 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1409 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1982 12:00:00 AM | 8 | Permit Number 19998 | 6016082.74679 | 2094573.4644900002 | 37.732202770925205 | -122.386734593253 | (37.7322027709252, -122.386734593253) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
| 35096 | 35096 | 103483 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 116 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770307 | 6009546.84586 | 2094694.0586599999 | 37.73216987282029 | -122.409339274108 | (37.7321698728203, -122.409339274108) | |
| 35098 | 35098 | 142469 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 548 VARENNES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010746.4928 | 2119899.9648 | 37.8014466914345 | -122.40696774883999 | (37.8014466914345, -122.40696774884) | |||
| 35180 | 35180 | 68976 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 7 | Permit Number 32966 | 5999654.77227 | 2119511.53893 | 37.7997532672523 | -122.44532199182301 | (37.7997532672523, -122.445321991823) | |
| 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) | |||
| 35617 | 35617 | 129243 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2127 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6003277.29318 | 2117510.20752 | 37.794464246380294 | -122.432643704862 | (37.7944642463803, -122.432643704862) | |||
| 35782 | 35782 | 190765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.751496295539106 | -122.39007361861601 | (37.7514962955391, -122.390073618616) | |||
| 36384 | 36384 | 206940 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5999451.4635 | 2094112.46165 | 37.7300021523805 | -122.444199366316 | (37.7300021523805, -122.444199366316) | |||
| 36439 | 36439 | 226890 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 257 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6009790.06992 | 2099605.20569 | 37.7456684458592 | -122.408844757605 | (37.7456684458592, -122.408844757605) | |||
| 36482 | 36482 | 226955 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 160 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009521.12916 | 2097699.3584 | 37.7404203378164 | -122.409640225031 | (37.7404203378164, -122.409640225031) | |||
| 36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
| 37322 | 37322 | 219374 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 167 Hamerton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001346.700759999 | 2095283.33425 | 37.7333250412114 | -122.437731137293 | (37.7333250412114, -122.437731137293) | ||||
| 37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
| 37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
| 37774 | 37774 | 226848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Farnum St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6002464.70638 | 2097278.29069 | 37.7388662400962 | -122.43400844134399 | (37.7388662400962, -122.434008441344) | |||
| 37929 | 37929 | 176673 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 62 Paulding St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 5999928.39495 | 2093418.54545 | 37.7281240171909 | -122.442500760096 | (37.7281240171909, -122.442500760096) | |||
| 38096 | 38096 | 206933 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6000003.13616 | 2094038.3079799998 | 37.7298300014536 | -122.44228685095301 | (37.7298300014536, -122.442286850953) | |||
| 38573 | 38573 | 176693 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 231 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6004560.89466 | 2091885.9682599998 | 37.7241788667532 | -122.426376964428 | (37.7241788667532, -122.426376964428) | |||
| 38700 | 38700 | 64762 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1988 12:00:00 AM | 8 | Permit Number 25739 | 5991956.18292 | 2111010.7557900003 | 37.7759700106605 | -122.471341981082 | (37.7759700106605, -122.471341981082) | ||
| 38742 | 38742 | 219285 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 111 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6001314.21471 | 2094602.6455299999 | 37.7314541797466 | -122.437794714872 | (37.7314541797466, -122.437794714872) | |||
| 39223 | 39223 | 226882 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2810 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.41041355295201 | (37.7605458378345, -122.410413552952) | |||
| 39238 | 39238 | 176826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 635 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002712.89216 | 2087452.0684200001 | 37.711899721374 | -122.432448688654 | (37.711899721374, -122.432448688654) | |||
| 39518 | 39518 | 129245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008845.28336 | 2117017.82608 | 37.79342648000571 | -122.41334287149401 | (37.7934264800057, -122.413342871494) | |||
| 39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) | |||
| 39860 | 39860 | 42981 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42865 | 6007925.78486 | 2092082.5600700001 | 37.7249083014575 | -122.414758909799 | (37.7249083014575, -122.414758909799) | |
| 40056 | 40056 | 219363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5990950.29751 | 2095356.30121 | 37.7329287603452 | -122.47367934265199 | (37.7329287603452, -122.473679342652) | |||
| 40060 | 40060 | 226881 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 1ft | 6006207.80682 | 2104080.83219 | 37.757756184028395 | -122.42154951882 | (37.7577561840284, -122.42154951882) | |||
| 40280 | 40280 | 227021 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008281.58077 | 2099209.78469 | 37.7444980969188 | -122.414032936584 | (37.7444980969188, -122.414032936584) | |||
| 40444 | 40444 | 226940 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 9 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6003929.09347 | 2096974.1924299998 | 37.738114253060395 | -122.428923598041 | (37.7381142530604, -122.428923598041) | |||
| 40551 | 40551 | 129159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5997408.66924 | 2114451.98586 | 37.785732623419 | -122.452728928703 | (37.785732623419, -122.452728928703) | |||
| 40696 | 40696 | 219275 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1651 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5993370.433230001 | 2104236.7588299997 | 37.7574521115395 | -122.465957429918 | (37.7574521115395, -122.465957429918) | |||
| 40707 | 40707 | 219318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5994210.25958 | 2091948.5213400002 | 37.7237600911452 | -122.46216184119 | (37.7237600911452, -122.46216184119) | |||
| 41354 | 41354 | 184569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3943 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981967.8868 | 2103494.6521 | 37.7547501020315 | -122.505336310147 | (37.7547501020315, -122.505336310147) | |||
| 41828 | 41828 | 190809 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2109 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011813.75397 | 2103701.3128400003 | 37.7570286091033 | -122.402135040812 | (37.7570286091033, -122.402135040812) | |||
| 42201 | 42201 | 176845 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 54 Gambier St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005715.3463 | 2093303.5013700002 | 37.728136293845104 | -122.42248686869101 | (37.7281362938451, -122.422486868691) | |||
| 42520 | 42520 | 176665 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1787 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000762.888230001 | 2093739.1978 | 37.729051986242204 | -122.43963887275801 | (37.7290519862422, -122.439638872758) | |||
| 43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) | |||
| 43606 | 43606 | 176668 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Camellia Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003228.3472 | 2094009.7333099998 | 37.7299348336038 | -122.43113489517799 | (37.7299348336038, -122.431134895178) | |||
| 43812 | 43812 | 176599 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998280.541680001 | 2089346.8494799999 | 37.716850019794606 | -122.44790439957899 | (37.7168500197946, -122.447904399579) |
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");