Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1882 | 1882 | 227046 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009320.74588 | 2104897.8286599996 | 37.760174505071895 | -122.410841346058 | (37.7601745050719, -122.410841346058) | |||
26548 | 26548 | 227032 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2851 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009394.98612 | 2104975.20837 | 37.76039113467 | -122.410590047609 | (37.76039113467, -122.410590047609) | |||
29581 | 29581 | 191178 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013045.03802 | 2109118.1209400003 | 37.7719706119713 | -122.398256802631 | (37.7719706119713, -122.398256802631) | |||
40480 | 40480 | 191196 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013094.16111 | 2109098.81981 | 37.771920351561 | -122.39808552672599 | (37.771920351561, -122.398085526726) | |||
40737 | 40737 | 88768 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51687 | 6013512.4253 | 2109511.33019 | 37.7730762996632 | -122.39666763312701 | (37.7730762996632, -122.396667633127) | |
42319 | 42319 | 191167 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013629.16381 | 2109678.37452 | 37.7735414622978 | -122.39627552692 | (37.7735414622978, -122.39627552692) | |||
54369 | 54369 | 191166 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013646.66643 | 2109696.02085 | 37.773590889053004 | -122.396216219322 | (37.773590889053, -122.396216219322) | |||
65636 | 65636 | 190888 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013991.92655 | 2109970.2198799998 | 37.774362983093795 | -122.395041112957 | (37.7743629830938, -122.395041112957) | |||
73291 | 73291 | 227045 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 691 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009312.22316 | 2105039.82895 | 37.7605639276988 | -122.410880851495 | (37.7605639276988, -122.410880851495) | |||
74586 | 74586 | 191179 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013027.66646 | 2109104.07615 | 37.771931080493204 | -122.39831590696801 | (37.7719310804932, -122.398315906968) | |||
118392 | 118392 | 191153 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014300.13588 | 2110263.57014 | 37.7751855911885 | -122.393995491012 | (37.7751855911885, -122.393995491012) | |||
123439 | 123439 | 51120 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012887.75032 | 2108975.98412 | 37.771571573793004 | -122.398790899202 | (37.771571573793, -122.398790899202) | ||
127241 | 127241 | 191161 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013755.54468 | 2109799.4078599997 | 37.773880824184296 | -122.39584683627301 | (37.7738808241843, -122.395846836273) | |||
130297 | 130297 | 227049 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 53 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002595.33861 | 2096033.4537 | 37.735455616991295 | -122.433467841774 | (37.7354556169913, -122.433467841774) | |||
149634 | 149634 | 190877 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013984.28553 | 2110015.29135 | 37.7744863143202 | -122.39507070246701 | (37.7744863143202, -122.395070702467) | |||
151120 | 151120 | 191207 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013692.93226 | 2109684.3718 | 37.773561477613 | -122.396055361178 | (37.773561477613, -122.396055361178) | |||
151925 | 151925 | 227037 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010462.237269999 | 2100563.14483 | 37.7483363647345 | -122.40658798445101 | (37.7483363647345, -122.406587984451) | |||
158928 | 158928 | 191160 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013772.476869999 | 2109816.50902 | 37.773928722073705 | -122.395789463138 | (37.7739287220737, -122.395789463138) | |||
159719 | 159719 | 191155 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014334.63154 | 2110298.17271 | 37.7752825191943 | -122.39387858453001 | (37.7752825191943, -122.39387858453) | |||
161090 | 161090 | 227048 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 53 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002587.0055599995 | 2096042.99913 | 37.7354813537673 | -122.43349733416099 | (37.7354813537673, -122.433497334161) | |||
163998 | 163998 | 51126 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012833.17756 | 2108921.6110400003 | 37.771419236747704 | -122.39897585375 | (37.7714192367477, -122.39897585375) | ||
165714 | 165714 | 190891 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014064.930869999 | 2110039.10887 | 37.774556196138896 | -122.39479340100401 | (37.7745561961389, -122.394793401004) | |||
166787 | 166787 | 190868 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014162.65537 | 2110188.5784299998 | 37.7749720390567 | -122.39446581847 | (37.7749720390567, -122.39446581847) | |||
168457 | 168457 | 91114 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52002 | 6013611.29629 | 2109661.1066900003 | 37.773493054483 | -122.39633612322399 | (37.773493054483, -122.396336123224) | |
169929 | 169929 | 191200 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013165.39711 | 2109177.11194 | 37.772139291512794 | -122.397844607347 | (37.7721392915128, -122.397844607347) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) |
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");