Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25604 | 25604 | 250134 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | ||||
31115 | 31115 | 189330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | ||||
37585 | 37585 | 189333 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016146.37557 | 2096749.3676 | 37.738180885651104 | -122.38666628881701 | (37.7381808856511, -122.386666288817) | ||||
40944 | 40944 | 189323 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 301x Cashmere St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016365.09613 | 2096197.7024299998 | 37.736678230916795 | -122.38587161279499 | (37.7366782309168, -122.385871612795) | ||||
41450 | 41450 | 189322 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6016409.152290001 | 2096168.4415799999 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | ||||
43126 | 43126 | 189335 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.38669889463301 | (37.7381987371688, -122.386698894633) | ||||
55018 | 55018 | 189324 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6016254.7178 | 2096666.0363099999 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | ||||
59302 | 59302 | 250133 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5999242.46646 | 2117532.2796099996 | 37.7942952053215 | -122.446606235406 | (37.7942952053215, -122.446606235406) | ||||
60010 | 60010 | 189329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016170.50674 | 2096734.9149900002 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | ||||
60126 | 60126 | 205301 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.45773749420799 | (37.7441389922109, -122.457737494208) | |||
65522 | 65522 | 205300 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995637.606269999 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | |||
67725 | 67725 | 189321 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016453.45941 | 2096140.5163099999 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | ||||
67884 | 67884 | 189332 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016155.51714 | 2096746.8738900002 | 37.7381745445247 | -122.38663450768298 | (37.7381745445247, -122.386634507683) | ||||
72110 | 72110 | 189326 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | ||||
125889 | 125889 | 189327 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6016185.549980001 | 2096725.46158 | 37.7381174132775 | -122.386529175505 | (37.7381174132775, -122.386529175505) | ||||
153230 | 153230 | 189331 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016158.581590001 | 2096743.10155 | 37.7381643560956 | -122.38662364926701 | (37.7381643560956, -122.386623649267) | ||||
166453 | 166453 | 189325 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016204.94299 | 2096703.88094 | 37.73805923075761 | -122.386460619275 | (37.7380592307576, -122.386460619275) | ||||
173471 | 173471 | 189328 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016180.048909999 | 2096728.46226 | 37.7381253480046 | -122.386548404801 | (37.7381253480046, -122.386548404801) | ||||
184299 | 184299 | 189334 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016143.045059999 | 2096752.0834599999 | 37.73818815846639 | -122.386677993501 | (37.7381881584664, -122.386677993501) |
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");