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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76939 | 76939 | 225183 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007749.18821 | 2106563.04323 | 37.7646585535855 | -122.416394585035 | (37.7646585535855, -122.416394585035) | |||
148331 | 148331 | 190003 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1750 22nd St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6012781.6725699995 | 2103797.8962 | 37.7573477838951 | -122.398794366977 | (37.7573477838951, -122.398794366977) | ||||
149755 | 149755 | 206029 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5998304.86283 | 2094699.93665 | 37.731549739012706 | -122.448205573546 | (37.7315497390127, -122.448205573546) | |||
151815 | 151815 | 201673 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010274.35746 | 2109764.89142 | 37.773591771276706 | -122.4078864553 | (37.7735917712767, -122.4078864553) | ||||
154165 | 154165 | 246301 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3998 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6002344.4551 | 2105927.1578 | 37.7626071523851 | -122.435042615882 | (37.7626071523851, -122.435042615882) | |||
155078 | 155078 | 32061 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35437 | 6004606.11173 | 2105983.62755 | 37.762890365909 | -122.4272243812 | (37.762890365909, -122.4272243812) | |
158983 | 158983 | 206028 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5998324.94212 | 2094699.61096 | 37.7315499926202 | -122.448136132397 | (37.7315499926202, -122.448136132397) | |||
166068 | 166068 | 225181 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.17494 | 2106512.16868 | 37.7645190318645 | -122.41638065094801 | (37.7645190318645, -122.416380650948) | |||
176930 | 176930 | 225167 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Hoffman Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000621.34497 | 2101755.16217 | 37.7510538776544 | -122.44070294699699 | (37.7510538776544, -122.440702946997) | |||
182738 | 182738 | 117701 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983015.82317 | 2113078.8166099996 | 37.7811270768141 | -122.502421605789 | (37.7811270768141, -122.502421605789) | |||
183184 | 183184 | 225180 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007753.3624 | 2106482.72591 | 37.7644382556423 | -122.416374458236 | (37.7644382556423, -122.416374458236) | |||
188264 | 188264 | 206032 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5997524.38886 | 2094711.3028099998 | 37.7315362986421 | -122.450904629644 | (37.7315362986421, -122.450904629644) |
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");