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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25960 | 25960 | 31277 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991087.0554599995 | 2097794.191 | 37.739630505545705 | -122.47338429037902 | (37.7396305055457, -122.473384290379) | |
| 27869 | 27869 | 31273 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | |
| 27935 | 27935 | 31275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991083.96236 | 2097817.15833 | 37.739693388847606 | -122.47339665963001 | (37.7396933888476, -122.47339665963) | |
| 50096 | 50096 | 31268 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.840009999 | 2098080.24601 | 37.7404148266578 | -122.47347158803001 | (37.7404148266578, -122.47347158803) | ||
| 55695 | 55695 | 31271 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991077.63514 | 2098038.16928 | 37.740299861958206 | -122.47343465238998 | (37.7402998619582, -122.47343465239) | |
| 59792 | 59792 | 31269 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991078.20537 | 2097980.39351 | 37.740141257507794 | -122.47342846774299 | (37.7401412575078, -122.473428467743) | |
| 77579 | 77579 | 31254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991075.91901 | 2097809.61001 | 37.7396721973209 | -122.47342391940201 | (37.7396721973209, -122.473423919402) | ||
| 79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
| 81182 | 81182 | 31279 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097846.97401 | 37.739774730819605 | -122.473430136096 | (37.7397747308196, -122.473430136096) | ||
| 83339 | 83339 | 31245 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097800.52101 | 37.739632092076 | -122.47432756819299 | (37.739632092076, -122.474327568193) | ||
| 83518 | 83518 | 31276 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097878.2790099997 | 37.7398608033144 | -122.473425434618 | (37.7398608033144, -122.473425434618) | ||
| 85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
| 88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
| 89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
| 90204 | 90204 | 31270 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991068.85001 | 2098107.5120099997 | 37.7404897505974 | -122.473470084178 | (37.7404897505974, -122.473470084178) | ||
| 90597 | 90597 | 31274 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097865.1510099997 | 37.739824640211 | -122.473431461565 | (37.739824640211, -122.473431461565) | ||
| 92475 | 92475 | 31267 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990813.36101 | 2097821.7280099997 | 37.739690262547796 | -122.47433260742399 | (37.7396902625478, -122.474332607424) | ||
| 93590 | 93590 | 31252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097887.3670099997 | 37.7398703149271 | -122.47434786892599 | (37.7398703149271, -122.474347868926) | ||
| 95229 | 95229 | 31251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098048.9410099997 | 37.740313663161395 | -122.47437711373101 | (37.7403136631614, -122.474377113731) | ||
| 95327 | 95327 | 31259 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990811.34201 | 2097863.1310099997 | 37.7398038276004 | -122.474342608694 | (37.7398038276004, -122.474342608694) | ||
| 98419 | 98419 | 31258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990812.351009999 | 2097840.9150099996 | 37.739742886616796 | -122.474337499296 | (37.7397428866168, -122.474337499296) | ||
| 102756 | 102756 | 31260 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990807.30201 | 2098024.7050099997 | 37.740247234298 | -122.47436836476001 | (37.740247234298, -122.47436836476) | ||
| 104347 | 104347 | 31255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097788.40301 | 37.739614026809996 | -122.473418880884 | (37.73961402681, -122.473418880884) | ||
| 109096 | 109096 | 31262 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097920.69201 | 37.7399618168302 | -122.474350300123 | (37.7399618168302, -122.474350300123) | ||
| 109275 | 109275 | 31256 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990815.38101 | 2097761.1370099997 | 37.739524012219796 | -122.474321202908 | (37.7395240122198, -122.474321202908) | ||
| 109317 | 109317 | 31253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097829.80601 | 37.7397275918836 | -122.47342888420499 | (37.7397275918836, -122.473428884205) | ||
| 112100 | 112100 | 31261 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097905.54401 | 37.7399202243074 | -122.474349195013 | (37.7399202243074, -122.474349195013) | ||
| 115267 | 115267 | 31264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990809.32201 | 2097939.87901 | 37.740014440896104 | -122.47435519202601 | (37.7400144408961, -122.474355192026) | ||
| 115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) | ||
| 120170 | 120170 | 31280 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991068.85001 | 2098095.39401 | 37.740456477673796 | -122.473469200507 | (37.7404564776738, -122.473469200507) | ||
| 128920 | 128920 | 31250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990801.243009999 | 2098168.10201 | 37.7406406146101 | -122.474399775861 | (37.7406406146101, -122.474399775861) | ||
| 140936 | 140936 | 31266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097974.21301 | 37.740108654737206 | -122.47436118898099 | (37.7401086547372, -122.474361188981) | ||
| 144186 | 144186 | 31265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097955.0260099997 | 37.740055972157705 | -122.474359789198 | (37.7400559721577, -122.474359789198) | ||
| 147454 | 147454 | 31278 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991081.40761 | 2097877.77569 | 37.739859680672204 | -122.47340991294901 | (37.7398596806722, -122.473409912949) | |
| 174030 | 174030 | 31272 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991082.4572 | 2097854.85146 | 37.7397967973808 | -122.473404612326 | (37.7397967973808, -122.473404612326) | |
| 174171 | 174171 | 31263 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991077.35619 | 2098024.94282 | 37.7402635293324 | -122.473434652395 | (37.7402635293324, -122.473434652395) |
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");