Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170689 | 170689 | 190840 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014957.07587 | 2110944.72485 | 37.777092378742104 | -122.391770606946 | (37.7770923787421, -122.391770606946) | |||
171100 | 171100 | 190890 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014028.53972 | 2110004.30919 | 37.7744586205966 | -122.394916848253 | (37.7744586205966, -122.394916848253) | |||
172546 | 172546 | 85229 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013312.02436 | 2109319.91751 | 37.7725395680802 | -122.39734742435199 | (37.7725395680802, -122.397347424352) | ||
173223 | 173223 | 191198 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013134.16647 | 2109135.5576299997 | 37.7720234534485 | -122.39794972192499 | (37.7720234534485, -122.397949721925) | |||
173251 | 173251 | 190841 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014902.59214 | 2110893.10566 | 37.776947619367206 | -122.39195547427299 | (37.7769476193672, -122.391955474273) | |||
174965 | 174965 | 190895 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014262.57866 | 2110228.29984 | 37.7750866594644 | -122.394122941124 | (37.7750866594644, -122.394122941124) | |||
175266 | 175266 | 191181 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6012706.66644 | 2108736.31507 | 37.7709034053917 | -122.399400454266 | (37.7709034053917, -122.399400454266) | |||
175327 | 175327 | 32981 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 558 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 7 | Permit Number 37294 | 6013791.869419999 | 2104484.1784 | 37.759288400371204 | -122.39534875755699 | (37.7592884003712, -122.395348757557) | |
176278 | 176278 | 51483 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 47794 | 6014118.18221 | 2110089.57063 | 37.774697713467 | -122.39461272721 | (37.774697713467, -122.39461272721) | |||
176646 | 176646 | 191177 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013063.400640001 | 2109137.8178 | 37.7720257179325 | -122.39819466666701 | (37.7720257179325, -122.398194666667) | |||
177049 | 177049 | 191169 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013574.9944 | 2109626.21147 | 37.773395219943 | -122.39645925121599 | (37.773395219943, -122.396459251216) | |||
177344 | 177344 | 191164 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013682.57668 | 2109729.99621 | 37.7736861758168 | -122.396094380961 | (37.7736861758168, -122.396094380961) | |||
177426 | 177426 | 227038 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 238 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004360.47421 | 2098709.18899 | 37.7429025656093 | -122.42755567166401 | (37.7429025656093, -122.427555671664) | |||
179861 | 179861 | 191203 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013547.7109 | 2109545.07141 | 37.7731709092433 | -122.39654794053499 | (37.7731709092433, -122.396547940535) | |||
180028 | 180028 | 85232 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013368.7851599995 | 2109373.5443 | 37.7726899752046 | -122.397154842615 | (37.7726899752046, -122.397154842615) | ||
180030 | 180030 | 85224 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013220.65574 | 2109233.19851 | 37.77229636981421 | -122.39765739638901 | (37.7722963698142, -122.397657396389) | ||
181313 | 181313 | 190871 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014091.22615 | 2110119.81942 | 37.7747792711826 | -122.39470809312999 | (37.7747792711826, -122.39470809313) | |||
181844 | 181844 | 191171 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013538.71499 | 2109592.42944 | 37.773300443093 | -122.39658237917101 | (37.773300443093, -122.396582379171) | |||
182000 | 182000 | 191184 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6012805.8880199995 | 2108829.45241 | 37.7711646692314 | -122.399063780475 | (37.7711646692314, -122.399063780475) | |||
182233 | 182233 | 190892 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014082.2782 | 2110055.46717 | 37.7746020768646 | -122.39473453857201 | (37.7746020768646, -122.394734538572) | |||
182570 | 182570 | 227034 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009481.322269999 | 2104976.8585200002 | 37.760400505599 | -122.41029156621201 | (37.760400505599, -122.410291566212) | |||
183159 | 183159 | 191194 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013058.71986 | 2109068.39463 | 37.771834836828 | -122.398205986443 | (37.771834836828, -122.398205986443) | |||
183392 | 183392 | 190874 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014038.01567 | 2110068.93569 | 37.774636597347495 | -122.394888596037 | (37.7746365973475, -122.394888596037) | |||
183780 | 183780 | 119659 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401X Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012884.61917 | 2108905.3838400003 | 37.7713775468798 | -122.398796774473 | (37.7713775468798, -122.398796774473) | |||
183890 | 183890 | 83155 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1714 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52368 | 6014530.43704 | 2094836.5062099998 | 37.7328389648403 | -122.392119708481 | (37.7328389648403, -122.392119708481) | |
184238 | 184238 | 190855 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014580.4909 | 2110587.4994799998 | 37.776090605936496 | -122.39304834211201 | (37.7760906059365, -122.393048342112) | |||
185795 | 185795 | 191162 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013718.31553 | 2109764.71694 | 37.773783499535604 | -122.395973187435 | (37.7737834995356, -122.395973187435) | |||
186016 | 186016 | 191201 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013477.11276 | 2109476.26405 | 37.772978050528295 | -122.39678732570101 | (37.7729780505283, -122.396787325701) | |||
186041 | 186041 | 51128 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012773.055380001 | 2108865.31837 | 37.7712613193831 | -122.399179868575 | (37.7712613193831, -122.399179868575) | ||
186155 | 186155 | 190885 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013937.025669999 | 2109920.0269400002 | 37.774222111483795 | -122.395227510053 | (37.7742221114838, -122.395227510053) | |||
186208 | 186208 | 51125 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012869.40685 | 2108957.05013 | 37.7715185632492 | -122.398853021653 | (37.7715185632492, -122.398853021653) | ||
187058 | 187058 | 51130 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012734.14513 | 2108828.51136 | 37.7711580871187 | -122.399311877367 | (37.7711580871187, -122.399311877367) | ||
187257 | 187257 | 190881 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013910.78759 | 2109947.4980099997 | 37.774296081645396 | -122.395320197769 | (37.7742960816454, -122.395320197769) | |||
187426 | 187426 | 85231 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49539 | 6013350.68536 | 2109356.01998 | 37.772640849735396 | -122.39721622315001 | (37.7726408497354, -122.39721622315) | ||
187758 | 187758 | 191205 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013584.80112 | 2109580.32237 | 37.7732697645312 | -122.396422111011 | (37.7732697645312, -122.396422111011) | |||
187963 | 187963 | 190882 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013891.89628 | 2109930.79083 | 37.774249156806 | -122.395384376097 | (37.774249156806, -122.395384376097) | |||
188150 | 188150 | 227035 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009497.84698 | 2104977.4520099997 | 37.7604030614745 | -122.41023445656799 | (37.7604030614745, -122.410234456568) | |||
188200 | 188200 | 190842 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014886.13724 | 2110878.3396 | 37.776906161529205 | -122.39201136443998 | (37.7769061615292, -122.39201136444) |
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");