Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
68245 | 68245 | 214423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 447 Bright St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993753.592209999 | 2090152.37899 | 37.718802013579705 | -122.463610156194 | (37.7188020135797, -122.463610156194) | |||
176135 | 176135 | 214422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 529 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | |||
47048 | 47048 | 247783 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 274 30th St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004785.28168 | 2098443.27058 | 37.7421964332069 | -122.42606787825198 | (37.7421964332069, -122.426067878252) | |||
43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
64861 | 64861 | 238007 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997631.46598 | 2104146.92887 | 37.757450353356795 | -122.45121467184099 | (37.7574503533568, -122.451214671841) | |||
133065 | 133065 | 196404 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 10th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009690.27769 | 2108658.23097 | 37.770520421914604 | -122.40982875080601 | (37.7705204219146, -122.409828750806) | |||
181071 | 181071 | 196405 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 10th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009655.4576 | 2108693.13255 | 37.770614302125395 | -122.40995165845699 | (37.7706143021254, -122.409951658457) | |||
48023 | 48023 | 196403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 140 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.40771198501899 | (37.7757364574022, -122.407711985019) | |||
148757 | 148757 | 196402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 136 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010324.85595 | 2110562.99084 | 37.775785993859294 | -122.407768059545 | (37.7757859938593, -122.407768059545) | |||
73533 | 73533 | 196401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 403 06th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.40395017576701 | (37.7770436561708, -122.403950175767) | |||
169098 | 169098 | 196399 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011297.10381 | 2111266.2805 | 37.7777714442324 | -122.404454306035 | (37.7777714442324, -122.404454306035) | |||
179102 | 179102 | 196398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011290.67787 | 2111282.0901599997 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | |||
133839 | 133839 | 196397 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011301.22079 | 2111291.73097 | 37.7778415553936 | -122.404441855801 | (37.7778415553936, -122.404441855801) | |||
187101 | 187101 | 196396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | |||
33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
155512 | 155512 | 196383 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 172 Clara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012113.23171 | 2112074.9324 | 37.780037390439794 | -122.40168787361799 | (37.7800373904398, -122.401687873618) | |||
48475 | 48475 | 196394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 497 03rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.781335479998496 | -122.39604324912202 | (37.7813354799985, -122.396043249122) | |||
25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
177545 | 177545 | 196385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013873.09616 | 2112844.01572 | 37.7822471659153 | -122.395653565657 | (37.7822471659153, -122.395653565657) | |||
133506 | 133506 | 196386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | |||
156919 | 156919 | 196387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013895.88765 | 2112864.3036700003 | 37.782304139751794 | -122.39557613855301 | (37.7823041397518, -122.395576138553) | |||
154435 | 154435 | 196388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.782348452967206 | -122.395514731015 | (37.7823484529672, -122.395514731015) | |||
32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
177156 | 177156 | 196391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | |||
57720 | 57720 | 196392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013963.537140001 | 2112927.48749 | 37.7824813907387 | -122.39534652723499 | (37.7824813907387, -122.395346527235) | |||
159092 | 159092 | 196393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013990.372330001 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) |
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");