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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
| 30306 | 30306 | 248645 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004348.66213 | 2104681.30747 | 37.7592999422487 | -122.428022000737 | (37.7592999422487, -122.428022000737) | ||||
| 38653 | 38653 | 176017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009623.1629099995 | 2089154.9429900001 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | ||||
| 40650 | 40650 | 189425 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 736 Arkansas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 7ft | 6012997.735719999 | 2103581.94425 | 37.756766863219106 | -122.39803198109301 | (37.7567668632191, -122.398031981093) | |||
| 47368 | 47368 | 248653 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6005296.42687 | 2097177.8941099998 | 37.738750871460205 | -122.424210521903 | (37.7387508714602, -122.424210521903) | ||||
| 47950 | 47950 | 176025 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6009634.04356 | 2089276.3567700002 | 37.7172988849001 | -122.408655756084 | (37.7172988849001, -122.408655756084) | ||||
| 49696 | 49696 | 248657 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 111 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | ||||
| 54155 | 54155 | 222119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4053 20th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 3ft | 6003326.69183 | 2104161.6671 | 37.7578152622781 | -122.431519370624 | (37.7578152622781, -122.431519370624) | |||
| 54175 | 54175 | 248651 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004132.59499 | 2095830.66152 | 37.7349858929719 | -122.42813852050301 | (37.7349858929719, -122.428138520503) | ||||
| 54591 | 54591 | 248654 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.42491328541901 | (37.7383130275105, -122.424913285419) | ||||
| 55194 | 55194 | 248652 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005286.42848 | 2097142.8356 | 37.7386540441353 | -122.42424259893801 | (37.7386540441353, -122.424242598938) | ||||
| 62845 | 62845 | 176023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009654.67743 | 2089334.9097900002 | 37.71746081504929 | -122.40858856232 | (37.7174608150493, -122.40858856232) | ||||
| 65371 | 65371 | 222118 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4053 20th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6003329.88306 | 2104158.35572 | 37.7578063508916 | -122.431508097635 | (37.7578063508916, -122.431508097635) | |||
| 66336 | 66336 | 189432 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Davidson Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 6014722.019230001 | 2099603.1392 | 37.745937791909206 | -122.391790529623 | (37.7459377919092, -122.391790529623) | |||
| 74105 | 74105 | 176021 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009620.695040001 | 2089243.5370200002 | 37.7172080210075 | -122.40869958183701 | (37.7172080210075, -122.408699581837) | ||||
| 139883 | 139883 | 222942 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 671 Church St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6004320.06266 | 2105000.56533 | 37.760174930454 | -122.428143663721 | (37.760174930454, -122.428143663721) | |||
| 155641 | 155641 | 176020 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6009615.5207400005 | 2089232.9452 | 37.7171786482456 | -122.408716720218 | (37.7171786482456, -122.408716720218) | ||||
| 156791 | 156791 | 248646 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004337.8277 | 2104713.595 | 37.759387983176 | -122.42806177235501 | (37.759387983176, -122.428061772355) | ||||
| 157188 | 157188 | 176019 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009612.43081 | 2089172.96988 | 37.717013795323 | -122.408723171949 | (37.717013795323, -122.408723171949) | ||||
| 157313 | 157313 | 176059 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 265 Ottawa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5998208.53283 | 2089432.6135599997 | 37.7170813919775 | -122.448159469808 | (37.7170813919775, -122.448159469808) | ||||
| 162363 | 162363 | 176024 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009648.362380001 | 2089313.42999 | 37.7174014822691 | -122.40860887622 | (37.7174014822691, -122.40860887622) | ||||
| 163343 | 163343 | 249722 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6000190.26691 | 2117349.57001 | 37.7938476262185 | -122.443313617731 | (37.7938476262185, -122.443313617731) | ||||
| 169087 | 169087 | 248655 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 107 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005056.20315 | 2096946.76695 | 37.7381026814961 | -122.425024662861 | (37.7381026814961, -122.425024662861) | ||||
| 169864 | 169864 | 176022 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009662.72679 | 2089352.75305 | 37.7175102597674 | -122.408561997261 | (37.7175102597674, -122.408561997261) | ||||
| 170804 | 170804 | 249742 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000223.59296 | 2117195.73646 | 37.7934271400971 | -122.44318725311199 | (37.7934271400971, -122.443187253112) | ||||
| 176014 | 176014 | 248656 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 110 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005044.37292 | 2096931.03803 | 37.7380588251561 | -122.42506444708 | (37.7380588251561, -122.42506444708) | ||||
| 185881 | 185881 | 176018 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009605.36223 | 2089158.99044 | 37.7169750147514 | -122.40874661906 | (37.7169750147514, -122.40874661906) | ||||
| 189033 | 189033 | 249723 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) |
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");