Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27769 | 27769 | 215436 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | |||
32139 | 32139 | 215423 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.72611098282629 | -122.46374856183998 | (37.7261109828263, -122.46374856184) | |||
34372 | 34372 | 241223 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.41204096432699 | (37.7642788409211, -122.412040964327) | |||
42264 | 42264 | 246217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | |||
46627 | 46627 | 182665 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2618 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5985884.1902 | 2102331.3321 | 37.7517856167847 | -122.491707219971 | (37.7517856167847, -122.491707219971) | |||
50744 | 50744 | 197985 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 669 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014155.897999999 | 2104063.80675 | 37.758154390328 | -122.394060332116 | (37.758154390328, -122.394060332116) | |||
60020 | 60020 | 241221 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009078.922 | 2106403.19833 | 37.764294343422996 | -122.411784075669 | (37.764294343423, -122.411784075669) | |||
66969 | 66969 | 241217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | |||
128240 | 128240 | 215433 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993594.89235 | 2092910.6701200001 | 37.726366466724 | -122.464358867875 | (37.726366466724, -122.464358867875) | |||
135775 | 135775 | 179965 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 86 Arago St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999606.18552 | 2093002.3803299998 | 37.726962952855104 | -122.443584762453 | (37.7269629528551, -122.443584762453) | ||||
146364 | 146364 | 179967 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | |||
170469 | 170469 | 197997 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6014474.56871 | 2089262.00767 | 37.717529404523795 | -122.391923191299 | (37.7175294045238, -122.391923191299) | |||
175277 | 175277 | 241199 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | |||
178204 | 178204 | 197987 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2 Bridgeview Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6014076.35565 | 2095353.09382 | 37.734232186468894 | -122.39372574026501 | (37.7342321864689, -122.393725740265) | ||||
178543 | 178543 | 197994 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6014370.9162 | 2089321.9827 | 37.717688329142604 | -122.392285665748 | (37.7176883291426, -122.392285665748) | |||
188005 | 188005 | 215430 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993628.724219999 | 2092981.5344200002 | 37.72656299287289 | -122.464247056069 | (37.7265629928729, -122.464247056069) |
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");