Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, DBH, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3693 | 3693 | 252877 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
5068 | 5068 | 253206 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2253 09th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
78601 | 78601 | 92035 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
78981 | 78981 | 113860 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
84894 | 84894 | 105492 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07TH AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773490 | 5993962.3 | 2104771.9 | 37.7589555970933 | -122.463949378571 | (37.7589555970933, -122.463949378571) | ||
89710 | 89710 | 92040 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
90554 | 90554 | 114400 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
92339 | 92339 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010511.0 | 2109243.0 | 37.77217202356729 | -122.407031076357 | (37.7721720235673, -122.407031076357) | ||||
92750 | 92750 | 113861 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
95756 | 95756 | 92036 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
97315 | 97315 | 113859 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
97794 | 97794 | 92038 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
99243 | 99243 | 122535 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 199x Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6007478.0 | 2099565.0 | 37.7454282725128 | -122.41683672388399 | (37.7454282725128, -122.416836723884) | |||
109893 | 109893 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
113582 | 113582 | 114403 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
115215 | 115215 | 92034 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
116196 | 116196 | 92033 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
119339 | 119339 | 121341 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 401X Cargo Way | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 3x3 | 6017217.0 | 2098844.0 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | |||
121824 | 121824 | 92039 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
128237 | 128237 | 92037 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
128978 | 128978 | 122678 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 701x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6008711.0 | 2098131.0 | 37.741560100881 | -122.412471846631 | (37.741560100881, -122.412471846631) | |||
141326 | 141326 | 113862 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
141824 | 141824 | 121089 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) |
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");