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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
37394 | 37394 | 39047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009496.342 | 2105638.057 | 37.762216848178504 | -122.410286304804 | (37.7622168481785, -122.410286304804) | ||
49625 | 49625 | 39053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009484.188999999 | 2105497.432 | 37.7618300427155 | -122.410318408111 | (37.7618300427155, -122.410318408111) | ||
69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
79822 | 79822 | 39041 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.42605904 | 2105918.18139903 | 37.762985618211395 | -122.41033000413601 | (37.7629856182114, -122.410330004136) | ||
81527 | 81527 | 39026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009266.307 | 2105730.9390000002 | 37.762458983569495 | -122.411088472825 | (37.7624589835695, -122.411088472825) | ||
89544 | 89544 | 39044 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009495.908 | 2105668.873 | 37.7623014375638 | -122.410289981728 | (37.7623014375638, -122.410289981728) | ||
90496 | 90496 | 39024 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105649.776 | 37.76223634755271 | -122.411069230189 | (37.7622363475527, -122.411069230189) | ||
94184 | 94184 | 39022 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009272.384 | 2105615.922 | 37.762143513944004 | -122.411059330144 | (37.762143513944, -122.411059330144) | ||
95950 | 95950 | 39051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009278.893999999 | 2105538.231 | 37.7619305572552 | -122.41103132667601 | (37.7619305572552, -122.411031326676) | ||
96307 | 96307 | 39023 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105633.7169999997 | 37.7621922532056 | -122.411068095823 | (37.7621922532056, -122.411068095823) | ||
96380 | 96380 | 39016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009463.356000001 | 2105496.13 | 37.761825299878204 | -122.410390369545 | (37.7618252998782, -122.410390369545) | ||
96483 | 96483 | 39042 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.831 | 2105754.377 | 37.76253587140361 | -122.41031703728999 | (37.7625358714036, -122.41031703729) | ||
98810 | 98810 | 39046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009496.342 | 2105647.606 | 37.7622430675565 | -122.410286979045 | (37.7622430675565, -122.410286979045) | ||
99947 | 99947 | 39057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009402.158 | 2105494.394 | 37.7618171023683 | -122.410601907375 | (37.7618171023683, -122.410601907375) | ||
100527 | 100527 | 39035 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | 3x3 | Permit Number 40772 | 6009429.068 | 2105914.5330000003 | 37.7629722168899 | -122.410538505147 | (37.7629722168899, -122.410538505147) | |
102698 | 102698 | 39054 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009492.87 | 2105711.4080000003 | 37.7624180586812 | -122.41030349243601 | (37.7624180586812, -122.410303492436) | ||
102961 | 102961 | 39036 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009448.598999999 | 2105916.703 | 37.762979270155505 | -122.410471107096 | (37.7629792701555, -122.410471107096) | ||
109862 | 109862 | 39052 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009313.616 | 2105488.318 | 37.7617954545913 | -122.410907711009 | (37.7617954545913, -122.410907711009) | ||
110004 | 110004 | 39034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009405.63 | 2105912.797 | 37.7629661362051 | -122.410619446859 | (37.7629661362051, -122.410619446859) | ||
111443 | 111443 | 39039 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009292.348999999 | 2105907.154 | 37.7629442900592 | -122.411010849803 | (37.7629442900592, -122.411010849803) | ||
111456 | 111456 | 39040 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009495.908 | 2105657.588 | 37.7622704515257 | -122.410289184909 | (37.7622704515257, -122.410289184909) | ||
111963 | 111963 | 39019 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009482.887 | 2105872.432 | 37.7628596342444 | -122.410349390153 | (37.7628596342444, -122.410349390153) | ||
118345 | 118345 | 39058 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009498.946 | 2105586.8419999997 | 37.7620763694246 | -122.410273682328 | (37.7620763694246, -122.410273682328) | ||
118769 | 118769 | 39037 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009483.321 | 2105838.144 | 37.7627655115494 | -122.410345467972 | (37.7627655115494, -122.410345467972) | ||
119962 | 119962 | 39033 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009388.268999999 | 2105911.495 | 37.7629615878496 | -122.410679400873 | (37.7629615878496, -122.410679400873) | ||
120409 | 120409 | 39048 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009497.21 | 2105627.641 | 37.7621882968719 | -122.41028256725201 | (37.7621882968719, -122.410282567252) | ||
124880 | 124880 | 39029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009306.238 | 2105908.456 | 37.762948643891 | -122.410962904321 | (37.762948643891, -122.410962904321) | ||
125544 | 125544 | 39030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009267.609 | 2105685.366 | 37.7623339235365 | -122.411080750478 | (37.7623339235365, -122.411080750478) | ||
126513 | 126513 | 39025 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009268.043 | 2105665.835 | 37.7622803202093 | -122.4110778698 | (37.7622803202093, -122.4110778698) | ||
128037 | 128037 | 39045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009275.856000001 | 2105555.5919999997 | 37.7619780562366 | -122.41104306028299 | (37.7619780562366, -122.411043060283) | ||
128704 | 128704 | 39055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009436.88 | 2105495.262 | 37.7618214323112 | -122.410481878589 | (37.7618214323112, -122.410481878589) | ||
129386 | 129386 | 39017 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.42605904 | 2105918.18139903 | 37.762985618211395 | -122.41033000413601 | (37.7629856182114, -122.410330004136) | ||
138927 | 138927 | 39018 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009482.887 | 2105885.887 | 37.7628965786036 | -122.41035034023001 | (37.7628965786036, -122.41035034023) | ||
139332 | 139332 | 39021 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009273.252 | 2105594.654 | 37.7620851655468 | -122.41105482574801 | (37.7620851655468, -122.411054825748) | ||
140786 | 140786 | 39032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009362.227000001 | 2105911.495 | 37.7629601277229 | -122.410769471544 | (37.7629601277229, -122.410769471544) | ||
141380 | 141380 | 39049 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009498.078 | 2105612.016 | 37.7621454428378 | -122.41027846190501 | (37.7621454428378, -122.410278461905) | ||
142018 | 142018 | 39020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009326.637 | 2105908.456 | 37.7629497877468 | -122.410892350936 | (37.7629497877468, -122.410892350936) | ||
143966 | 143966 | 39038 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009500.248 | 2105572.085 | 37.7620359230474 | -122.410268137236 | (37.7620359230474, -122.410268137236) | ||
144228 | 144228 | 39028 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009274.554 | 2105576.425 | 37.7620351858869 | -122.41104903498001 | (37.7620351858869, -122.41104903498) | ||
144691 | 144691 | 39043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009263.703 | 2105753.075 | 37.7625196179381 | -122.411099042798 | (37.7625196179381, -122.411099042798) |
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");