Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17474 | 17474 | 5669 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1411 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005264.89314 | 2100092.7159 | 37.746752529107596 | -122.42452683054701 | (37.7467525291076, -122.424526830547) | |||
25786 | 25786 | 196352 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011956.0756 | 2105144.27438 | 37.76099860510921 | -122.401744258403 | (37.7609986051092, -122.401744258403) | ||||
27717 | 27717 | 196349 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011979.46515 | 2105146.30626 | 37.761005489419205 | -122.40166350647499 | (37.7610054894192, -122.401663506475) | ||||
30690 | 30690 | 135882 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6007964.86831 | 2120685.23293 | 37.803446794585795 | -122.41664910307199 | (37.8034467945858, -122.416649103072) | |||
36140 | 36140 | 135880 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 3573 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997686.8627 | 2115746.51973 | 37.789303006579104 | -122.45185988682199 | (37.7893030065791, -122.451859886822) | |||
40421 | 40421 | 196353 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6011962.814119999 | 2105133.05123 | 37.7609681648715 | -122.40172016377599 | (37.7609681648715, -122.401720163776) | ||||
42652 | 42652 | 196357 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6011913.72494 | 2105132.82627 | 37.7609648076872 | -122.40188992698401 | (37.7609648076872, -122.401889926984) | ||||
43191 | 43191 | 196350 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6011973.312390001 | 2105136.40204 | 37.7609779512911 | -122.401684090158 | (37.7609779512911, -122.401684090158) | ||||
45232 | 45232 | 214374 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1670 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993737.50266 | 2104155.61578 | 37.757250482639606 | -122.46468207522601 | (37.7572504826396, -122.464682075226) | |||
46029 | 46029 | 214375 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 40 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001152.10793 | 2095216.80224 | 37.7331312930803 | -122.43839913213199 | (37.7331312930803, -122.438399132132) | |||
46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
47804 | 47804 | 102094 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 646 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768455 | 5993542.90087 | 2111432.9430400003 | 37.7772208817879 | -122.465883837162 | (37.7772208817879, -122.465883837162) | |
60082 | 60082 | 249703 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999691.6374699995 | 2117215.06978 | 37.793449877667 | -122.445029242728 | (37.793449877667, -122.445029242728) | ||||
73227 | 73227 | 196347 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6011990.16114 | 2105143.23972 | 37.7609976662368 | -122.401626297942 | (37.7609976662368, -122.401626297942) | ||||
90786 | 90786 | 37728 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1228 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768579 | 6009213.61732255 | 2101997.11746506 | 37.752203798813795 | -122.411006967934 | (37.7522037988138, -122.411006967934) |
92295 | 92295 | 81880 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 315 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50646 | 6004264.94687094 | 2091428.0663806 | 37.7229048353865 | -122.427367408132 | (37.7229048353865, -122.427367408132) | |
95012 | 95012 | 82350 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 315 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50646 | 6004264.94687094 | 2091428.0663806 | 37.7229048353865 | -122.427367408132 | (37.7229048353865, -122.427367408132) | |
119557 | 119557 | 16584 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 745X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5993146.002730001 | 2114812.03373 | 37.7864760417982 | -122.46750261028299 | (37.7864760417982, -122.467502610283) | |||
124579 | 124579 | 83218 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 3124 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52347 | 6004253.45017179 | 2119849.79530606 | 37.8009434640556 | -122.429433004812 | (37.8009434640556, -122.429433004812) | ||
130984 | 130984 | 214373 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1550 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5991561.65041 | 2104917.18173 | 37.7592158610322 | -122.472262461655 | (37.7592158610322, -122.472262461655) | ||||
133885 | 133885 | 237964 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1459 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009329.478069999 | 2100729.5018700003 | 37.748729704821 | -122.410516798727 | (37.748729704821, -122.410516798727) | |||
142067 | 142067 | 82613 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 2655 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52234 | 6008939.6637933 | 2103006.46843661 | 37.7549598834989 | -122.41202566923799 | (37.7549598834989, -122.412025669238) | ||
144537 | 144537 | 82361 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1163 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768585 | 6007677.84129717 | 2102891.68819405 | 37.754573846019895 | -122.416381291371 | (37.7545738460199, -122.416381291371) |
147035 | 147035 | 237965 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 447 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000681.71243 | 2101388.64307 | 37.7500509420016 | -122.44046790648899 | (37.7500509420016, -122.440467906489) | |||
151507 | 151507 | 196348 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011983.2298099995 | 2105140.07548 | 37.7609885911574 | -122.401650048127 | (37.7609885911574, -122.401650048127) | ||||
155612 | 155612 | 249707 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999697.96101 | 2117191.03981 | 37.793384258626205 | -122.445005634599 | (37.7933842586262, -122.445005634599) | ||||
155723 | 155723 | 67670 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1783 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 7 | Permit Number 31272 | 6014117.152419999 | 2095094.3646099998 | 37.7335240360099 | -122.393566589946 | (37.7335240360099, -122.393566589946) | |
157981 | 157981 | 196355 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011948.055430001 | 2105132.5844400004 | 37.7609660595651 | -122.401771175125 | (37.7609660595651, -122.401771175125) | ||||
161376 | 161376 | 196354 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6011952.75605 | 2105133.25565 | 37.760968164877795 | -122.40175496482 | (37.7609681648778, -122.40175496482) | ||||
168969 | 168969 | 135879 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 3351 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998772.77052 | 2115570.5893200003 | 37.788882083379896 | -122.448090116767 | (37.7888820833799, -122.448090116767) | |||
170186 | 170186 | 135881 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6007959.30516 | 2120736.41676 | 37.803587019598204 | -122.416671982741 | (37.8035870195982, -122.416671982741) | |||
173352 | 173352 | 102010 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1490United Sta Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768407 | 6007074.44657 | 2117422.83586 | 37.7944389538357 | -122.419498858593 | (37.7944389538357, -122.419498858593) | |
174273 | 174273 | 196356 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6011943.684880001 | 2105131.53346 | 37.760962929905894 | -122.40178621716001 | (37.7609629299059, -122.40178621716) | ||||
177422 | 177422 | 237963 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1000 San Jose Ave | 106 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005052.98208 | 2096959.6805599998 | 37.7381379574049 | -122.42503671826799 | (37.7381379574049, -122.425036718268) | ||||
180497 | 180497 | 135883 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6007965.36294 | 2120676.16554 | 37.8034219256369 | -122.416646748657 | (37.8034219256369, -122.416646748657) | |||
182794 | 182794 | 135878 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 3351 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998783.4836099995 | 2115572.1389 | 37.7888869505171 | -122.448053162718 | (37.7888869505171, -122.448053162718) | |||
183745 | 183745 | 196351 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6011965.48 | 2105145.22305 | 37.7610017347515 | -122.40171179916901 | (37.7610017347515, -122.401711799169) | ||||
184623 | 184623 | 101712 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 3337 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5998802.75246 | 2115574.21948 | 37.788893764689604 | -122.447986645277 | (37.7888937646896, -122.447986645277) |
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");