Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8512 | 8512 | 35248 | Permitted Site 1 | Acacia cognata :: River Wattle 249 | 1241 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2015 12:00:00 AM | 3 | Permit Number 38737 | 6007082.36267 | 2118759.24706 | 37.7981088505934 | -122.419566329333 | (37.7981088505934, -122.419566329333) | ||
| 9692 | 9692 | 173634 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | ||||
| 10306 | 10306 | 1069 | DPW Maintained 3 | Acacia cognata :: River Wattle 249 | 2100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000137.1099 | 2089955.07873 | 37.7186260252389 | -122.441530791828 | (37.7186260252389, -122.441530791828) | |||
| 10751 | 10751 | 1053 | DPW Maintained 3 | Acacia cognata :: River Wattle 249 | 2040 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6000460.13302 | 2090261.3785599999 | 37.7194854533786 | -122.440436190985 | (37.7194854533786, -122.440436190985) | |||
| 14059 | 14059 | 73480 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 599x 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1994 12:00:00 AM | 14 | 3x3 | 6013522.7636400005 | 2111545.67763 | 37.7786627326451 | -122.39677451844601 | (37.7786627326451, -122.396774518446) | |
| 24452 | 24452 | 220097 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 99 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005410.9551800005 | 2103173.20638 | 37.755219092195894 | -122.424240813775 | (37.7552190921959, -122.424240813775) | |||
| 28061 | 28061 | 250087 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 1608 Bush St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6005770.74957 | 2115225.4613099997 | 37.7883319959812 | -122.423853491051 | (37.7883319959812, -122.423853491051) | |||
| 29454 | 29454 | 188533 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 570 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013447.06785 | 2111525.42945 | 37.7786029223367 | -122.397034961197 | (37.7786029223367, -122.397034961197) | |||
| 32301 | 32301 | 49820 | Permitted Site 1 | Acacia cognata :: River Wattle 249 | 1600X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2005 12:00:00 AM | 11 | 3x3 | Permit Number 48421 | 6012856.819680001 | 2105678.96328 | 37.762516967395 | -122.39866647978201 | (37.762516967395, -122.398666479782) |
| 32311 | 32311 | 220099 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 41 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002581.52039 | 2096379.46281 | 37.7364048945526 | -122.433540336143 | (37.7364048945526, -122.433540336143) | |||
| 40223 | 40223 | 74087 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 599X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1992 12:00:00 AM | 17 | 6013574.27676 | 2111494.44969 | 37.778524939401 | -122.396592721381 | (37.778524939401, -122.396592721381) | ||
| 40571 | 40571 | 67717 | Permitted Site 1 | Acacia cognata :: River Wattle 249 | 570 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 9 | Permit Number 31331 | 6013438.4217 | 2111535.2518 | 37.778629410967795 | -122.39706556065201 | (37.7786294109678, -122.397065560652) | |
| 67367 | 67367 | 73852 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 599X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1992 12:00:00 AM | 11 | 6013559.70399 | 2111507.31632 | 37.7785594572038 | -122.39664403669599 | (37.7785594572038, -122.396644036696) | ||
| 76678 | 76678 | 188530 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 117 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013376.95355 | 2111505.4597 | 37.778544186699904 | -122.39727611442301 | (37.7785441866999, -122.397276114423) | |||
| 116621 | 116621 | 94328 | Permitted Site 1 | Acacia cognata :: River Wattle 249 | 599X Wisconsin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | 6 | 8x6 | Permit Number 53628 | 6012719.6074 | 2104814.62781 | 37.7601360473633 | -122.39908037835899 | (37.7601360473633, -122.399080378359) | |
| 129615 | 129615 | 247754 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 46 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6001610.556340001 | 2108537.96548 | 37.7697340879911 | -122.43776789979499 | (37.7697340879911, -122.437767899795) | |||
| 132511 | 132511 | 220100 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 39 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002602.52341 | 2096353.8761599998 | 37.736335831134895 | -122.433465892038 | (37.7363358311349, -122.433465892038) | |||
| 134138 | 134138 | 250086 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 1608 Bush St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6005781.70757 | 2115226.50094 | 37.7883354691536 | -122.42381565206499 | (37.7883354691536, -122.423815652065) | |||
| 134956 | 134956 | 188531 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 117 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013393.02277 | 2111518.97562 | 37.778582192950395 | -122.3972214725 | (37.7785821929504, -122.3972214725) | |||
| 149224 | 149224 | 220098 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 3673 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005174.5332 | 2104852.16435 | 37.759815764615105 | -122.42517789293998 | (37.7598157646151, -122.42517789294) | |||
| 150048 | 150048 | 246618 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 175 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009121.84834 | 2099138.68885 | 37.7443500415332 | -122.411122430074 | (37.7443500415332, -122.411122430074) | |||
| 155886 | 155886 | 70903 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 119 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 9 | 6013345.23207 | 2111478.2104700003 | 37.7784676004338 | -122.39738394042 | (37.7784676004338, -122.39738394042) | ||
| 156220 | 156220 | 248041 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 43 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010519.48467 | 2099411.43107 | 37.745177212762606 | -122.40630888706801 | (37.7451772127626, -122.406308887068) | ||||
| 162077 | 162077 | 188528 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 1634 Jerrold Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6015106.50902 | 2097221.3643099996 | 37.739419267374004 | -122.390294627899 | (37.739419267374, -122.390294627899) | |||
| 166084 | 166084 | 124053 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 650 Funston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991957.65744 | 2110987.76796 | 37.7759069776194 | -122.47133520506901 | (37.7759069776194, -122.471335205069) | |||
| 176342 | 176342 | 188529 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 117 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013364.70784 | 2111493.54453 | 37.7785107885917 | -122.39731764151001 | (37.7785107885917, -122.39731764151) | |||
| 187791 | 187791 | 188532 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 117 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013410.2126400005 | 2111535.82372 | 37.778629410968705 | -122.39716318745 | (37.7786294109687, -122.39716318745) |
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");