Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize, YCoord, Latitude, Longitude
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184333 | 184333 | 178913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5993781.9303 | 2086773.16178 | 37.709525120851396 | -122.463267128695 | (37.7095251208514, -122.463267128695) | ||||
63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
46837 | 46837 | 178884 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003708.27118 | 2090552.3037299998 | 37.720468684870504 | -122.42922930371599 | (37.7204686848705, -122.429229303716) | |||
70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
114627 | 114627 | 36259 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 Elmhurst Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | ||
100422 | 100422 | 36248 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Surrey St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
102071 | 102071 | 50544 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
107830 | 107830 | 4033 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
126737 | 126737 | 27754 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
44048 | 44048 | 37254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
78486 | 78486 | 117170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
122977 | 122977 | 36037 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1660X BRYANT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39178 | 6009346.0 | 2106886.0 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | ||
115299 | 115299 | 115687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
98133 | 98133 | 88232 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
121685 | 121685 | 42759 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
96072 | 96072 | 109161 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
71170 | 71170 | 244253 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005660.0799 | 2110124.2725 | 37.7743191351223 | -122.423873514167 | (37.7743191351223, -122.423873514167) | |||
83464 | 83464 | 119866 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
104070 | 104070 | 119873 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
113327 | 113327 | 115456 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
58675 | 58675 | 110549 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
57526 | 57526 | 244352 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.42405809140699 | (37.7752287864343, -122.424058091407) | |||
181182 | 181182 | 138874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005562.0898 | 2110802.7178 | 37.7761764489655 | -122.424260742604 | (37.7761764489655, -122.424260742604) | |||
35994 | 35994 | 138977 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005455.7439 | 2110835.1089 | 37.7762593816337 | -122.42463092693501 | (37.7762593816337, -122.424630926935) | |||
178028 | 178028 | 38750 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012258.40846 | 2112446.8085 | 37.7810665763953 | -122.40121177791 | (37.7810665763953, -122.40121177791) | ||
43907 | 43907 | 139147 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004351.7938 | 2114062.4276 | 37.785058390527794 | -122.428679907469 | (37.7850583905278, -122.428679907469) | |||
31626 | 31626 | 106986 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003814.6942 | 2114193.6153 | 37.7853881873399 | -122.430547466156 | (37.7853881873399, -122.430547466156) | |||
26263 | 26263 | 23904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6003550.0996 | 2114363.7178 | 37.7858402532263 | -122.43147503127199 | (37.7858402532263, -122.431475031272) | |||
150701 | 150701 | 138799 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000493.7553 | 2114952.745 | 37.78728387171021 | -122.44209139561 | (37.7872838717102, -122.44209139561) | |||
103110 | 103110 | 48786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
23661 | 23661 | 142764 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.801741456909596 | -122.40695573845899 | (37.8017414569096, -122.406955738459) |
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");