Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
| 27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
| 28609 | 28609 | 227574 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.43384779545299 | (37.764968555288, -122.433847795453) | |||
| 35827 | 35827 | 227133 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5999502.6369199995 | 2100390.28597 | 37.7472424869628 | -122.44447345808999 | (37.7472424869628, -122.44447345809) | |||
| 38084 | 38084 | 207023 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997061.0236599995 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | |||
| 38228 | 38228 | 227149 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007719.361409999 | 2095678.5372900001 | 37.734770477458795 | -122.41572699582301 | (37.7347704774588, -122.415726995823) | |||
| 47223 | 47223 | 207040 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996029.169869999 | 2093727.8612799998 | 37.728750294270604 | -122.456002788314 | (37.7287502942706, -122.456002788314) | |||
| 54346 | 54346 | 227582 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000368.64642 | 2106819.9498400004 | 37.7649461504603 | -122.44194028911501 | (37.7649461504603, -122.441940289115) | |||
| 55628 | 55628 | 227559 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.2761699995 | 2104538.3206 | 37.758702584674204 | -122.44048780488001 | (37.7587025846742, -122.44048780488) | |||
| 61434 | 61434 | 227118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.743898754514106 | -122.42235811905701 | (37.7438987545141, -122.422358119057) | |||
| 116434 | 116434 | 227156 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3458 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007201.92693 | 2104423.1326599997 | 37.758752066271704 | -122.41813569949801 | (37.7587520662717, -122.418135699498) | |||
| 129668 | 129668 | 207044 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 755 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | |||
| 131491 | 131491 | 227124 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.74872258759179 | -122.435779604843 | (37.7487225875918, -122.435779604843) | |||
| 132209 | 132209 | 207033 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.74914077145029 | -122.46651646199301 | (37.7491407714503, -122.466516461993) | |||
| 133679 | 133679 | 207045 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998977.59415 | 2096753.4397599997 | 37.737226608721706 | -122.446027465895 | (37.7372266087217, -122.446027465895) | |||
| 134344 | 134344 | 206998 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 223 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994252.21923 | 2105280.12164 | 37.7603677459862 | -122.462983582339 | (37.7603677459862, -122.462983582339) | |||
| 136194 | 136194 | 227101 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003382.77934 | 2099193.25446 | 37.744176348274294 | -122.43097080757799 | (37.7441763482743, -122.430970807578) | |||
| 137913 | 137913 | 176893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 La Grande Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005229.89136 | 2092027.9096099997 | 37.7246064008395 | -122.42407442931601 | (37.7246064008395, -122.424074429316) | |||
| 153496 | 153496 | 227150 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.203290001 | 2095640.9266099997 | 37.7346933830922 | -122.41411375505301 | (37.7346933830922, -122.414113755053) | |||
| 157266 | 157266 | 207035 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.749137613916396 | -122.46664505153299 | (37.7491376139164, -122.466645051533) | |||
| 169335 | 169335 | 176907 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006492.037819999 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | |||
| 170816 | 170816 | 227585 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003798.52213 | 2108785.73673 | 37.7705385756322 | -122.430217470683 | (37.7705385756322, -122.430217470683) | |||
| 172822 | 172822 | 207034 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993127.0368800005 | 2101215.11136 | 37.7491414027515 | -122.466579558421 | (37.7491414027515, -122.466579558421) | |||
| 174051 | 174051 | 176889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.42694318119499 | (37.7235644112504, -122.426943181195) | |||
| 180853 | 180853 | 227108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007939.95228 | 2098099.81155 | 37.741431163228604 | -122.41513566820299 | (37.7414311632286, -122.415135668203) | |||
| 187437 | 187437 | 119231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4327 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982159.48772 | 2110285.61161 | 37.7734074014784 | -122.505176976845 | (37.7734074014784, -122.505176976845) |
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");