Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
| 24159 | 24159 | 33290 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37451 | 6009219.4283 | 2116994.47406 | 37.7933833601996 | -122.41204664625499 | (37.7933833601996, -122.412046646255) | |
| 24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
| 31906 | 31906 | 220602 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.744229349819896 | -122.43003686791401 | (37.7442293498199, -122.430036867914) | |||
| 32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
| 34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
| 41654 | 41654 | 125506 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | |||
| 48805 | 48805 | 220628 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.44095346395201 | (37.751606143208, -122.440953463952) | |||
| 55076 | 55076 | 125501 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007553.747280001 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | |||
| 63824 | 63824 | 220654 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | |||
| 67240 | 67240 | 125498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | |||
| 72887 | 72887 | 189192 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012099.2034599995 | 2107516.8442700002 | 37.767521137926394 | -122.401415981588 | (37.7675211379264, -122.401415981588) | |||
| 73487 | 73487 | 125479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1133 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009244.74147 | 2117035.03683 | 37.793496155866706 | -122.411961928316 | (37.7934961558667, -122.411961928316) | |||
| 73496 | 73496 | 220620 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 747 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783001 | (37.745417306567, -122.43682864783) | |||
| 75383 | 75383 | 125524 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011207.6846199995 | 2120726.9389400003 | 37.8037431562814 | -122.40543008395201 | (37.8037431562814, -122.405430083952) | |||
| 76753 | 76753 | 125472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6010077.8197800005 | 2116010.1713 | 37.790728826812206 | -122.40900705375401 | (37.7907288268122, -122.409007053754) | |||
| 136912 | 136912 | 250078 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.78854093456471 | -122.425019237271 | (37.7885409345647, -122.425019237271) | |||
| 149175 | 149175 | 249549 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6005525.061919999 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | |||
| 149887 | 149887 | 175169 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266001 | (37.7271890729929, -122.41063996266) | |||
| 152079 | 152079 | 220653 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008119.35429 | 2096079.0254799998 | 37.7358926083592 | -122.41437240636002 | (37.7358926083592, -122.41437240636) | |||
| 155798 | 155798 | 203493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | |||
| 157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
| 160138 | 160138 | 125525 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | |||
| 170184 | 170184 | 220663 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696546999 | (37.7501903863949, -122.42961696547) | |||
| 184201 | 184201 | 220660 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003703.338380001 | 2095523.5259999998 | 37.734118272040604 | -122.429600714704 | (37.7341182720406, -122.429600714704) | |||
| 189070 | 189070 | 203497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.733017974899504 | -122.45086036952299 | (37.7330179748995, -122.450860369523) |
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");