Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4515 | 4515 | 225797 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008067.53952 | 2103885.7722400003 | 37.75732528104621 | -122.41510396797301 | (37.7573252810462, -122.415103967973) | |||
7849 | 7849 | 23269 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006584.636609999 | 2113380.90993 | 37.7833132240722 | -122.42090655840201 | (37.7833132240722, -122.420906558402) | |||
34034 | 34034 | 128825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011989.53481 | 2115248.11567 | 37.7887433063148 | -122.40233897468399 | (37.7887433063148, -122.402338974684) | |||
40753 | 40753 | 192274 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.770763532946795 | -122.412138720645 | (37.7707635329468, -122.412138720645) | |||
40849 | 40849 | 225810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002901.372830001 | 2107162.40051 | 37.766030436082794 | -122.433204705528 | (37.7660304360828, -122.433204705528) | |||
42728 | 42728 | 192205 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009311.714459999 | 2108971.0789 | 37.7713582069357 | -122.411160311315 | (37.7713582069357, -122.411160311315) | |||
53360 | 53360 | 225386 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.751568879815395 | -122.42636408974501 | (37.7515688798154, -122.426364089745) | |||
54845 | 54845 | 192324 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011702.91759 | 2107830.29721 | 37.7683596900813 | -122.40280873732999 | (37.7683596900813, -122.40280873733) | |||
55477 | 55477 | 225792 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007807.819130001 | 2105426.09185 | 37.761540045560295 | -122.416111269835 | (37.7615400455603, -122.416111269835) | |||
69649 | 69649 | 192333 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007912.3493800005 | 2110528.44514 | 37.7755557890086 | -122.416111106161 | (37.7755557890086, -122.416111106161) | |||
70126 | 70126 | 192356 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | |||
71246 | 71246 | 128812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008015.3478 | 2113733.84894 | 37.7843628498196 | -122.415981852889 | (37.7843628498196, -122.415981852889) | |||
72951 | 72951 | 128809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | |||
115102 | 115102 | 2681 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | ||
118104 | 118104 | 128815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6008510.99254 | 2112773.43009 | 37.781753624263295 | -122.41419911600201 | (37.7817536242633, -122.414199116002) | |||
134588 | 134588 | 192304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009910.49486 | 2105936.61453 | 37.7630598260768 | -122.40887496583001 | (37.7630598260768, -122.40887496583) | |||
136363 | 136363 | 225813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6002885.55761 | 2107343.69078 | 37.7665273178175 | -122.43327236244 | (37.7665273178175, -122.43327236244) | |||
137763 | 137763 | 192260 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009216.21335 | 2108451.1310400004 | 37.7699251948176 | -122.411453915683 | (37.7699251948176, -122.411453915683) | |||
141574 | 141574 | 33477 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
146501 | 146501 | 75946 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011842.29348 | 2118770.98259 | 37.7984080370505 | -122.403096308158 | (37.7984080370505, -122.403096308158) | ||
150960 | 150960 | 218967 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 140 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.46482279396099 | (37.7503985047832, -122.464822793961) | |||
151429 | 151429 | 192339 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007610.66005 | 2110846.20818 | 37.776411323063606 | -122.41717724703301 | (37.7764113230636, -122.417177247033) | |||
151652 | 151652 | 192231 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009620.79732 | 2108551.27729 | 37.7702228578355 | -122.410061533137 | (37.7702228578355, -122.410061533137) | |||
155375 | 155375 | 192351 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008765.23275 | 2109539.84577 | 37.772889245185794 | -122.413090847292 | (37.7728892451858, -122.413090847292) | |||
161289 | 161289 | 192251 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009321.461680001 | 2108343.14872 | 37.769634603179 | -122.41108223395901 | (37.769634603179, -122.411082233959) | |||
165124 | 165124 | 225801 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4201 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001928.34635 | 2105251.90853 | 37.7607294461137 | -122.43643345245 | (37.7607294461137, -122.43643345245) | |||
166498 | 166498 | 128820 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6008600.12871 | 2112713.96294 | 37.7815953480768 | -122.413886537756 | (37.7815953480768, -122.413886537756) | |||
174186 | 174186 | 225782 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007716.52666 | 2105576.00343 | 37.761946534627 | -122.416437632899 | (37.761946534627, -122.416437632899) | |||
174637 | 174637 | 192342 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007873.4377 | 2110478.3105900004 | 37.775415943530604 | -122.41624215986099 | (37.7754159435306, -122.416242159861) | |||
175214 | 175214 | 192301 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011807.32161 | 2102351.9134 | 37.753323095606106 | -122.402062424168 | (37.7533230956061, -122.402062424168) | |||
179125 | 179125 | 124030 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991790.3652800005 | 2114364.58828 | 37.78516912121479 | -122.47216010553801 | (37.7851691212148, -122.472160105538) | |||
181015 | 181015 | 192314 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011714.34761 | 2107590.0026599998 | 37.767700533789395 | -122.402752300399 | (37.7677005337894, -122.402752300399) | |||
186614 | 186614 | 247293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1187 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999369.2896 | 2108822.0623 | 37.7703864492561 | -122.445540779928 | (37.7703864492561, -122.445540779928) |
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");