Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26201 | 26201 | 212832 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1201 Funston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5992025.01275 | 2107217.63828 | 37.765559111278 | -122.47082751866999 | (37.765559111278, -122.47082751867) | |||
| 26751 | 26751 | 186196 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984756.9045 | 2103549.1285 | 37.7550634017723 | -122.495695286455 | (37.7550634017723, -122.495695286455) | |||
| 27653 | 27653 | 186191 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984752.6191 | 2103570.02 | 37.7551205130891 | -122.49571164730499 | (37.7551205130891, -122.495711647305) | |||
| 30906 | 30906 | 212833 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 468 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996396.78511 | 2096388.5906 | 37.7360771087699 | -122.454924099162 | (37.7360771087699, -122.454924099162) | |||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 38506 | 38506 | 185519 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2201 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984858.6139 | 2100160.4269 | 37.7457649124522 | -122.495093683302 | (37.7457649124522, -122.495093683302) | |||
| 39842 | 39842 | 183135 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2315 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.141 | 2099420.9741 | 37.7437324991665 | -122.49516182260099 | (37.7437324991665, -122.495161822601) | |||
| 40066 | 40066 | 184721 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1630 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982537.7064 | 2103994.8819 | 37.7561571061486 | -122.503402789254 | (37.7561571061486, -122.503402789254) | |||
| 40595 | 40595 | 185530 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2201 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984911.0151 | 2100096.2189 | 37.7455916823633 | -122.49490775682699 | (37.7455916823633, -122.494907756827) | |||
| 41633 | 41633 | 185634 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2100 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985067.4201 | 2100372.3359 | 37.746358979048296 | -122.49438729000201 | (37.7463589790483, -122.494387290002) | |||
| 45002 | 45002 | 52035 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1451 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2005 12:00:00 AM | 1 | Permit Number 48247 | 6000914.194 | 2110330.7938 | 37.774617124205 | -122.44030518181002 | (37.774617124205, -122.44030518181) | ||
| 47763 | 47763 | 186107 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1901 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984859.3561 | 2101642.6122 | 37.7498346320289 | -122.495200398918 | (37.7498346320289, -122.495200398918) | |||
| 49901 | 49901 | 187069 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985177.211 | 2096899.8078 | 37.7368307770453 | -122.49375180463001 | (37.7368307770453, -122.49375180463) | |||
| 54294 | 54294 | 187072 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985184.617000001 | 2096917.4415 | 37.7368796277559 | -122.493727498225 | (37.7368796277559, -122.493727498225) | |||
| 68940 | 68940 | 234843 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005925.31783 | 2106426.47013 | 37.764180822918796 | -122.422693171361 | (37.7641808229188, -122.422693171361) | |||
| 69400 | 69400 | 140757 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2303 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000331.3271 | 2112998.0313 | 37.7819074748635 | -122.442512966292 | (37.7819074748635, -122.442512966292) | |||
| 71923 | 71923 | 183061 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2595 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983026.5279 | 2097492.8315 | 37.7383329997375 | -122.50123139183 | (37.7383329997375, -122.50123139183) | |||
| 72838 | 72838 | 234841 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005926.24374 | 2106419.53529 | 37.76416183372571 | -122.42268947605 | (37.7641618337257, -122.42268947605) | |||
| 75956 | 75956 | 183684 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1323 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983353.1911 | 2106127.4738 | 37.762060508953205 | -122.50074030741501 | (37.7620605089532, -122.500740307415) | |||
| 137863 | 137863 | 138343 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2250 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001783.0488 | 2114314.9363 | 37.7856060025516 | -122.437585027866 | (37.7856060025516, -122.437585027866) | |||
| 150237 | 150237 | 183060 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2595 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983027.0823 | 2097502.8119 | 37.738360435752604 | -122.501230213026 | (37.7383604357526, -122.501230213026) | |||
| 154788 | 154788 | 234842 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005925.78637 | 2106423.26838 | 37.7641720581045 | -122.422691323269 | (37.7641720581045, -122.422691323269) | |||
| 158999 | 158999 | 186404 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1801 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984797.7578 | 2102308.2226 | 37.7516586088355 | -122.495462490222 | (37.7516586088355, -122.495462490222) | |||
| 164654 | 164654 | 186192 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984807.2585 | 2103565.1989 | 37.7551104753081 | -122.49552233563 | (37.7551104753081, -122.49552233563) | |||
| 165116 | 165116 | 183136 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2315 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.4792 | 2099404.7372 | 37.7436879368421 | -122.49515945610901 | (37.7436879368421, -122.495159456109) | |||
| 183905 | 183905 | 187068 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985184.8913 | 2096895.1448 | 37.736818423021205 | -122.493724907332 | (37.7368184230212, -122.493724907332) | |||
| 184454 | 184454 | 186104 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1901 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984870.6903 | 2101670.318 | 37.749911368138 | -122.49516324816003 | (37.749911368138, -122.49516324816) | |||
| 185391 | 185391 | 69306 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1518 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 1 | Permit Number 33385 | 5986858.656 | 2104895.6313 | 37.7588833876571 | -122.48852587956199 | (37.7588833876571, -122.488525879562) |
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");