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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 113938 | 113938 | 31281 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/2003 12:00:00 AM | Permit Number 34929 | 5991128.30074427 | 2097998.4698012 | 37.7401937911776 | -122.473256578017 | (37.7401937911776, -122.473256578017) | ||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 69685 | 69685 | 31286 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2591 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34934 | 5990775.57693 | 2097788.90474 | 37.7395979491861 | -122.47446085258001 | (37.7395979491861, -122.47446085258) | |
| 29420 | 29420 | 31287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34935 | 5990781.283369999 | 2097640.71217 | 37.7391913809888 | -122.474430310711 | (37.7391913809888, -122.474430310711) | |
| 129199 | 129199 | 31288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 96997 | 96997 | 31289 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 140421 | 140421 | 31290 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 103476 | 103476 | 31291 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 168831 | 168831 | 31292 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2607 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34936 | 5990782.2972800005 | 2097618.99301 | 37.7391318044827 | -122.47442522055401 | (37.7391318044827, -122.474425220554) | |
| 174260 | 174260 | 31293 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2630 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51389 | 5990831.02656 | 2097486.3119200002 | 37.7387703192965 | -122.474247059457 | (37.7387703192965, -122.474247059457) | |
| 59992 | 59992 | 31294 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2634 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34938 | 5990833.43787 | 2097461.0446 | 37.738701081392705 | -122.474236879142 | (37.7387010813927, -122.474236879142) | |
| 59079 | 59079 | 31295 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2670 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34939 | 5990841.428590001 | 2097225.71709 | 37.7380553951316 | -122.474192084818 | (37.7380553951316, -122.474192084818) | |
| 68029 | 68029 | 31353 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2363 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 8 | Permit Number 34963 | 5992611.652290001 | 2099388.8635 | 37.7440972384981 | -122.46822891325701 | (37.7440972384981, -122.468228913257) | |
| 134105 | 134105 | 31359 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2439 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34967 | 5991359.58224 | 2098806.0443 | 37.7424245732342 | -122.472515769209 | (37.7424245732342, -122.472515769209) | |
| 186415 | 186415 | 31371 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 537 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34973 | 5991501.22289 | 2099052.17268 | 37.7431085759965 | -122.472043958778 | (37.7431085759965, -122.472043958778) | |
| 147466 | 147466 | 31413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4015 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35001 | 6001977.40654 | 2103508.81115 | 37.755946109541995 | -122.436139035098 | (37.755946109542, -122.436139035098) | |
| 63136 | 63136 | 31414 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4015 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35001 | 6001997.26666 | 2103510.7551700003 | 37.7559525756639 | -122.436070491479 | (37.7559525756639, -122.436070491479) | |
| 181930 | 181930 | 31415 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4031 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35002 | 6001952.947240001 | 2103509.31726 | 37.7559461095403 | -122.43622365949 | (37.7559461095403, -122.43622365949) | |
| 51486 | 51486 | 31439 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4260 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35014 | 6000763.54302 | 2102896.12937 | 37.7541947949643 | -122.440293027915 | (37.7541947949643, -122.440293027915) | |
| 55971 | 55971 | 31448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35022 | 6002087.85452 | 2104429.9690900003 | 37.758481661717504 | -122.435822975573 | (37.7584816617175, -122.435822975573) | |
| 60098 | 60098 | 31449 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 8 | Permit Number 35022 | 6002088.98075 | 2104442.1365099996 | 37.7585151344893 | -122.435819951133 | (37.7585151344893, -122.435819951133) | |
| 177082 | 177082 | 31453 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001228.2731 | 2102757.74093 | 37.7538412624867 | -122.438675964135 | (37.7538412624867, -122.438675964135) | |
| 181645 | 181645 | 31456 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35026 | 6001232.81474 | 2102673.98616 | 37.7536115504365 | -122.43865425719801 | (37.7536115504365, -122.438654257198) | |
| 28667 | 28667 | 31457 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001233.81138 | 2102648.72464 | 37.7535422450846 | -122.43864900065701 | (37.7535422450846, -122.438649000657) | |
| 37332 | 37332 | 31458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 2 | Permit Number 35026 | 6001236.64987 | 2102602.74693 | 37.7534161628409 | -122.438635890359 | (37.7534161628409, -122.438635890359) | |
| 158055 | 158055 | 31460 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35026 | 6001239.440780001 | 2102584.49605 | 37.7533662090858 | -122.438624931196 | (37.7533662090858, -122.438624931196) | |
| 83302 | 83302 | 31461 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 630 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35027 | 6001185.04751596 | 2102718.99331881 | 37.7537324117625 | -122.438822671411 | (37.7537324117625, -122.438822671411) | ||
| 49410 | 49410 | 31464 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 419 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | 8 | Permit Number 35030 | 6003624.46293 | 2102130.90923 | 37.7522561543076 | -122.430344668985 | (37.7522561543076, -122.430344668985) | |
| 57167 | 57167 | 31509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2426 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35069 | 6011274.30435 | 2102324.32413 | 37.753217577243205 | -122.40390377703599 | (37.7532175772432, -122.403903777036) | |
| 88178 | 88178 | 31515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1221 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35073 | 6011656.39484291 | 2091519.89430614 | 37.723572242368896 | -122.401823009869 | (37.7235722423689, -122.401823009869) | ||
| 117241 | 117241 | 31518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1225 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | Permit Number 35075 | 6011656.56027463 | 2091519.35210888 | 37.723570762838705 | -122.401822399904 | (37.7235707628387, -122.401822399904) | |||
| 87153 | 87153 | 31519 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1225 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | Permit Number 35075 | 6011656.56027463 | 2091519.35210888 | 37.723570762838705 | -122.401822399904 | (37.7235707628387, -122.401822399904) | |||
| 111302 | 111302 | 31521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1319 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35077 | 6011660.44790907 | 2091506.61050899 | 37.7235359939753 | -122.401808065753 | (37.7235359939753, -122.401808065753) | ||
| 139505 | 139505 | 31522 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1319 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35077 | 6011660.44790907 | 2091506.61050899 | 37.7235359939753 | -122.401808065753 | (37.7235359939753, -122.401808065753) | ||
| 25526 | 25526 | 31523 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1320 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 9 | Permit Number 35078 | 6011116.30671 | 2102174.6826400002 | 37.752797866337794 | -122.404439635397 | (37.7527978663378, -122.404439635397) | |
| 107416 | 107416 | 31526 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1331 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35081 | 6011660.94420422 | 2091504.98391721 | 37.7235315553844 | -122.401806235857 | (37.7235315553844, -122.401806235857) | ||
| 160070 | 160070 | 31527 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1364 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35082 | 6011127.62197 | 2102002.7195099997 | 37.752326325712 | -122.40438840191099 | (37.752326325712, -122.404388401911) | |
| 176369 | 176369 | 31528 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1366 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35083 | 6011129.790030001 | 2101978.90007 | 37.7522610439178 | -122.40437922793899 | (37.7522610439178, -122.404379227939) | |
| 113784 | 113784 | 31529 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1372 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35084 | 6011133.311735599 | 2101955.20274251 | 37.7521961730604 | -122.40436538143601 | (37.7521961730604, -122.404365381436) | ||
| 77567 | 77567 | 31547 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 230 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45060 | 5998353.30570755 | 2112667.00543316 | 37.7808856171306 | -122.449332118202 | (37.7808856171306, -122.449332118202) | ||
| 131977 | 131977 | 31558 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 172 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 8 | Permit Number 35103 | 5998551.5701 | 2112529.1677 | 37.7805184894256 | -122.448636297075 | (37.7805184894256, -122.448636297075) | |
| 41179 | 41179 | 31559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 178 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35104 | 5998526.8653 | 2112524.7682 | 37.7805049968836 | -122.448721445326 | (37.7805049968836, -122.448721445326) | ||
| 138291 | 138291 | 31561 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 178 Ewing Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | ||
| 49041 | 49041 | 31563 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1996 12:00:00 AM | 8 | Permit Number 35105 | 5998443.6135 | 2112525.1066 | 37.7805011651196 | -122.44900947575199 | (37.7805011651196, -122.449009475752) | |
| 35867 | 35867 | 31577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1723 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35116 | 5989021.1478 | 2103586.321 | 37.7554143192924 | -122.48095119881799 | (37.7554143192924, -122.480951198818) | |
| 108078 | 108078 | 31597 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1544 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35124 | 5989258.42987869 | 2102441.4270978 | 37.752284535772795 | -122.480046831269 | (37.7522845357728, -122.480046831269) | ||
| 76744 | 76744 | 31691 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1549 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35195 | 5998318.3005 | 2105128.80455 | 37.7601856404696 | -122.448910060177 | (37.7601856404696, -122.448910060177) | |
| 187344 | 187344 | 31692 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 61 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 7 | Permit Number 35553 | 5998816.4378 | 2107906.1796 | 37.767840090069896 | -122.44738715512501 | (37.7678400900699, -122.447387155125) | |
| 137590 | 137590 | 31693 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 65 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52415 | 5998820.9803 | 2107877.7137 | 37.7677621894841 | -122.447369394112 | (37.7677621894841, -122.447369394112) | |
| 45510 | 45510 | 31694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 78 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35198 | 5998855.957 | 2107820.6304 | 37.7676074517958 | -122.447244305581 | (37.7676074517958, -122.447244305581) | |
| 176089 | 176089 | 31695 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35199 | 5998904.17865 | 2107218.24435 | 37.7659562069265 | -122.447034158921 | (37.7659562069265, -122.447034158921) | |
| 69247 | 69247 | 31696 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 169 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35200 | 5998909.79856 | 2107175.07195 | 37.7658379874718 | -122.44701161379 | (37.7658379874718, -122.44701161379) | |
| 79595 | 79595 | 31697 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 251 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52273 | 5998844.67635941 | 2107610.34536784 | 37.767029417655294 | -122.447268187302 | (37.7670294176553, -122.447268187302) | ||
| 144931 | 144931 | 31698 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 251 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52273 | 5998844.67635941 | 2107610.34536784 | 37.767029417655294 | -122.447268187302 | (37.7670294176553, -122.447268187302) | ||
| 119827 | 119827 | 31699 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 251 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52273 | 5998844.67635941 | 2107610.34536784 | 37.767029417655294 | -122.447268187302 | (37.7670294176553, -122.447268187302) | ||
| 158407 | 158407 | 31700 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 259 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35202 | 5998814.43004 | 2107606.91955 | 37.767018282894796 | -122.44737255760599 | (37.7670182828948, -122.447372557606) | |
| 119489 | 119489 | 31701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35203 | 5998787.10007 | 2107605.9925 | 37.7670141756857 | -122.44746702060199 | (37.7670141756857, -122.447467020602) | |
| 77433 | 77433 | 31711 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.763837639523395 | -122.450514467435 | (37.7638376395234, -122.450514467435) |
| 148545 | 148545 | 31716 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1137 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 10 | Permit Number 35216 | 5997692.23217 | 2106590.3868400003 | 37.764162952473704 | -122.45118072960399 | (37.7641629524737, -122.451180729604) | |
| 152378 | 152378 | 31719 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2441 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35218 | 5990424.0321 | 2098772.6598 | 37.742278712781896 | -122.475748149765 | (37.7422787127819, -122.475748149765) | |
| 179907 | 179907 | 31723 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35222 | 5990174.4545 | 2098741.1268 | 37.742177658626794 | -122.47660880018 | (37.7421776586268, -122.47660880018) | |
| 166155 | 166155 | 31724 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2446 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35223 | 5990172.2592 | 2098727.5891 | 37.7421403602768 | -122.476615401967 | (37.7421403602768, -122.476615401967) | |
| 47756 | 47756 | 31725 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2446 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35223 | 5990173.7227 | 2098712.5879 | 37.7420992557504 | -122.47660924601101 | (37.7420992557504, -122.476609246011) | |
| 40778 | 40778 | 31726 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2457 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35224 | 5990124.6943 | 2098653.4978 | 37.741934165798995 | -122.47677445266599 | (37.741934165799, -122.476774452666) | |
| 33081 | 33081 | 31729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.4261 | 2098592.0294 | 37.7417654319331 | -122.47676743237601 | (37.7417654319331, -122.476767432376) | |
| 74665 | 74665 | 31730 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.0602 | 2098571.5399 | 37.7417091518445 | -122.47676720086201 | (37.7417091518445, -122.476767200862) | |
| 71587 | 71587 | 31739 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2671 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35229 | 5990174.1076 | 2097212.0277 | 37.737979126750005 | -122.47649832068599 | (37.73797912675, -122.476498320686) | |
| 182630 | 182630 | 31740 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2675 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35230 | 5990173.7691 | 2097191.0455 | 37.73792149538679 | -122.47649795866998 | (37.7379214953868, -122.47649795867) | |
| 171199 | 171199 | 31741 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2679 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35231 | 5990174.446 | 2097163.9718 | 37.73784719722 | -122.47649364108901 | (37.73784719722, -122.476493641089) |
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");