Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23859 | 23859 | 223337 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 21 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002002.72042 | 2096679.5859400001 | 37.737196106421706 | -122.435562951888 | (37.7371961064217, -122.435562951888) | |||
27063 | 27063 | 233956 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002403.3233199995 | 2096434.7165299999 | 37.7365464964208 | -122.434160386288 | (37.7365464964208, -122.434160386288) | |||
27928 | 27928 | 231945 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002666.1416 | 2096136.6991599998 | 37.7357431221521 | -122.433230424364 | (37.7357431221521, -122.433230424364) | |||
29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
30330 | 30330 | 233958 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 19 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002544.64531 | 2096274.1188599998 | 37.73611355200129 | -122.433660302082 | (37.7361135520013, -122.433660302082) | |||
35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
43309 | 43309 | 231938 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002328.37989 | 2096518.1207400002 | 37.7367712513805 | -122.43442545876499 | (37.7367712513805, -122.434425458765) | |||
45661 | 45661 | 233955 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002401.2653 | 2096437.12023 | 37.736552979622104 | -122.434167673516 | (37.7365529796221, -122.434167673516) | |||
46775 | 46775 | 224477 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 23 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002584.32363 | 2096230.7970099999 | 37.735996851473296 | -122.43352002314501 | (37.7359968514733, -122.433520023145) | |||
50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
51612 | 51612 | 234910 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 1 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002382.22186 | 2096459.02703 | 37.73661204979621 | -122.43423508039301 | (37.7366120497962, -122.434235080393) | |||
54645 | 54645 | 245788 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 59 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002650.36065 | 2096519.5995200002 | 37.736793583358605 | -122.433312337306 | (37.7367935833586, -122.433312337306) | |||
62808 | 62808 | 231942 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002659.32372 | 2096145.42523 | 37.735766695166504 | -122.433254619725 | (37.7357666951665, -122.433254619725) | |||
68761 | 68761 | 220550 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 37 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002449.94428 | 2096771.92833 | 37.737475048229705 | -122.43402329543801 | (37.7374750482297, -122.434023295438) | |||
71023 | 71023 | 240631 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 57 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002629.35658 | 2096548.6301400003 | 37.7368721031581 | -122.433387031387 | (37.7368721031581, -122.433387031387) | |||
71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
71556 | 71556 | 227504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002174.41423 | 2096447.2518799999 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | |||
73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
131366 | 131366 | 237944 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 26 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 2ft | 6002164.0262 | 2096336.8178599998 | 37.736264104808 | -122.43498073797701 | (37.736264104808, -122.434980737977) | |||
132003 | 132003 | 231941 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002655.75902 | 2096147.9144099997 | 37.7357733276597 | -122.43326712208 | (37.7357733276597, -122.43326712208) | |||
134638 | 134638 | 233923 | Undocumented 2 | Persea americana :: Avocado 113 | 20 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002185.25785 | 2096400.06868 | 37.736438982481395 | -122.43491185351299 | (37.7364389824814, -122.434911853513) | |||
136411 | 136411 | 234911 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 3 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002388.89555 | 2096450.4938299998 | 37.736588998379105 | -122.434211396756 | (37.7365889983791, -122.434211396756) | |||
136660 | 136660 | 238536 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002355.478619999 | 2096490.80035 | 37.736697774076 | -122.434329814067 | (37.736697774076, -122.434329814067) | |||
149582 | 149582 | 231939 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002331.25514 | 2096517.0119 | 37.7367683699712 | -122.434415438526 | (37.7367683699712, -122.434415438526) | |||
155248 | 155248 | 231944 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002664.28784 | 2096138.10096 | 37.7357468660117 | -122.43323693366001 | (37.7357468660117, -122.43323693366) | |||
155846 | 155846 | 231943 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002661.77062 | 2096140.53935 | 37.7357534184718 | -122.43324581083901 | (37.7357534184718, -122.433245810839) | |||
159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
160401 | 160401 | 227015 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.43518606040399 | (37.7375161085743, -122.435186060404) | |||
161192 | 161192 | 233957 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 15 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002524.54294 | 2096295.7854099998 | 37.7361719027113 | -122.43373135214199 | (37.7361719027113, -122.433731352142) | |||
164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
165645 | 165645 | 227016 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002117.32476 | 2096797.30121 | 37.7375258338607 | -122.43517513003201 | (37.7375258338607, -122.435175130032) | |||
166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
174735 | 174735 | 236183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002335.35488 | 2096511.4177599999 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | |||
177217 | 177217 | 245789 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 13 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 2ft | 6002510.68516 | 2096313.6496700002 | 37.736220167514404 | -122.433780540537 | (37.7362201675144, -122.433780540537) | |||
180684 | 180684 | 226835 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 27 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002073.33297 | 2096755.10087 | 37.7374074632877 | -122.43532421245199 | (37.7374074632877, -122.435324212452) | |||
183893 | 183893 | 240363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 19 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | |||
184761 | 184761 | 231940 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002651.97591 | 2096151.4784799998 | 37.735782899162395 | -122.433280456348 | (37.7357828991624, -122.433280456348) | |||
187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) |
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");