Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
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) | |||
9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
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) | ||||
44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
71413 | 71413 | 113506 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 39 | 3x3 | 6011135.08211 | 2090555.5358799999 | 37.7208952054249 | -122.40355728893199 | (37.7208952054249, -122.403557288932) | |||
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) | ||
85741 | 85741 | 114041 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
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) | |||
90640 | 90640 | 114042 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
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) | |||
101800 | 101800 | 114043 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
102861 | 102861 | 112189 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
102986 | 102986 | 112188 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 45 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
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) | |||
123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
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");