Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
28011 | 28011 | 124342 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | |||
54820 | 54820 | 199491 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6010160.462780001 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | |||
59290 | 59290 | 199446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6015650.90558 | 2108071.91419 | 37.7692427658814 | -122.38916976848199 | (37.7692427658814, -122.389169768482) | |||
62727 | 62727 | 199499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6009970.38295 | 2112379.67473 | 37.7807543308744 | -122.40912249520001 | (37.7807543308744, -122.4091224952) | |||
77010 | 77010 | 217431 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2070 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5993239.44153 | 2093011.60748 | 37.7266231206395 | -122.46559496444401 | (37.7266231206395, -122.465594964444) | |||
105609 | 105609 | 28635 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 21 | 5X5 | 5996764.463409999 | 2091686.23626 | 37.723186652559 | -122.45331350914 | (37.723186652559, -122.45331350914) | ||
147475 | 147475 | 124341 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.37991 | 2113683.65327 | 37.783534723234894 | -122.45799531563699 | (37.7835347232349, -122.457995315637) | |||
154136 | 154136 | 119374 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.49165253211099 | (37.7728405660437, -122.491652532111) | |||
165043 | 165043 | 84749 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | ||
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
148908 | 148908 | 118014 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.779984662684704 | -122.49754547051 | (37.7799846626847, -122.49754547051) | |||
174910 | 174910 | 181219 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 519 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6002044.02941 | 2090439.9964599998 | 37.720065958565 | -122.434974017336 | (37.720065958565, -122.434974017336) | |||
186914 | 186914 | 202176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013132.98284 | 2093010.28184 | 37.7277468379346 | -122.396823108819 | (37.7277468379346, -122.396823108819) | |||
41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
54015 | 54015 | 250212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011360.92473 | 2120092.038 | 37.8020084404915 | -122.404855058325 | (37.8020084404915, -122.404855058325) | |||
156998 | 156998 | 181281 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6004496.25142 | 2093004.99255 | 37.727247805938795 | -122.426680076425 | (37.7272478059388, -122.426680076425) | |||
188996 | 188996 | 181266 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6009541.56007 | 2087669.1100400002 | 37.712880535479 | -122.40886209741001 | (37.712880535479, -122.40886209741) | |||
160884 | 160884 | 217455 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996102.296490001 | 2089002.27895 | 37.7157791619582 | -122.455408593627 | (37.7157791619582, -122.455408593627) |
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");