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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 165215 | 165215 | 44743 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 5 | Permit Number 43861 | 5992021.82053 | 2086414.86847 | 37.7084397758389 | -122.469324250627 | (37.7084397758389, -122.469324250627) | |
| 178309 | 178309 | 31056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Toyon Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34808 | 6003244.645880001 | 2086572.31488 | 37.7095142480656 | -122.430548065039 | (37.7095142480656, -122.430548065039) | |
| 34347 | 34347 | 44742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) | |
| 146572 | 146572 | 73606 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994431.8230800005 | 2086668.6372599998 | 37.7092755401168 | -122.461013433922 | (37.7092755401168, -122.461013433922) | ||
| 55122 | 55122 | 71593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994443.94493 | 2086683.2861799998 | 37.70931646014839 | -122.46097260021001 | (37.7093164601484, -122.46097260021) | ||
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 58904 | 58904 | 44740 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 5 | Permit Number 43858 | 5992059.17709 | 2086878.10482 | 37.7097138705641 | -122.469228836168 | (37.7097138705641, -122.469228836168) | |
| 130109 | 130109 | 78715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 5 | 6008812.7369 | 2086938.0409099997 | 37.710832318719504 | -122.411329543927 | (37.7108323187195, -122.411329543927) | ||
| 179704 | 179704 | 44738 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 224 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43855 | 5992028.811919999 | 2086945.8058900002 | 37.7098980067533 | -122.46933870721901 | (37.7098980067533, -122.469338707219) | |
| 182397 | 182397 | 78518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997355.58596 | 2086978.87375 | 37.7102951905332 | -122.450930851174 | (37.7102951905332, -122.450930851174) | ||
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 57825 | 57825 | 78914 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 3 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||
| 88240 | 88240 | 65746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 252 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28705 | 6000865.93587078 | 2087131.69490372 | 37.7109151403091 | -122.438809330108 | (37.7109151403091, -122.438809330108) | ||
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 81604 | 81604 | 52515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 83381 | 83381 | 52518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 85420 | 85420 | 52517 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 111902 | 111902 | 52516 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 69810 | 69810 | 65716 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 3x3 | Permit Number 28648 | 6000919.98791 | 2088014.07766 | 37.7133410423274 | -122.438685700186 | (37.7133410423274, -122.438685700186) |
| 176147 | 176147 | 78746 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 355 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 8 | 6009102.50426 | 2088111.2854900002 | 37.7140700552715 | -122.410410826197 | (37.7140700552715, -122.410410826197) | ||
| 62438 | 62438 | 73489 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000901.50106 | 2088195.8414200002 | 37.713839073386104 | -122.438762613813 | (37.7138390733861, -122.438762613813) | ||
| 152001 | 152001 | 65712 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 10 | Permit Number 28641 | 6000856.2772 | 2088212.0675400002 | 37.713881053746206 | -122.438920085998 | (37.7138810537462, -122.438920085998) | |
| 126754 | 126754 | 70910 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000896.54528 | 2088212.43618 | 37.7138843569546 | -122.43878093122 | (37.7138843569546, -122.43878093122) | ||
| 183519 | 183519 | 74088 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000890.324130001 | 2088231.9158299998 | 37.7139374897944 | -122.438803828836 | (37.7139374897944, -122.438803828836) | ||
| 34700 | 34700 | 73853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000885.5664 | 2088247.4069700001 | 37.713979754329 | -122.438821382721 | (37.713979754329, -122.438821382721) | ||
| 45829 | 45829 | 70117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000875.3973900005 | 2088278.84235 | 37.714065490318106 | -122.438858781914 | (37.7140654903181, -122.438858781914) | ||
| 97486 | 97486 | 48580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45894 | 5992735.0311487 | 2088323.3092015 | 37.713721087088295 | -122.466997982048 | (37.7137210870883, -122.466997982048) | ||
| 127810 | 127810 | 48581 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 162 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45895 | 5992994.26817447 | 2088334.73866608 | 37.7137674293264 | -122.466102801731 | (37.7137674293264, -122.466102801731) | ||
| 49129 | 49129 | 35866 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002010.96914 | 2088348.68943 | 37.714321816885096 | -122.43493881070499 | (37.7143218168851, -122.434938810705) | |
| 49728 | 49728 | 35867 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002026.003769999 | 2088372.6219 | 37.7143883838026 | -122.434888555678 | (37.7143883838026, -122.434888555678) | |
| 48367 | 48367 | 49748 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 109@ BRUSSELS Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46547 | 6011907.8290099995 | 2088398.1624200002 | 37.715014627609 | -122.400734636294 | (37.715014627609, -122.400734636294) | |
| 105701 | 105701 | 48564 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 278 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45983 | 5994240.83855888 | 2088432.11877754 | 37.714106652118204 | -122.461801284944 | (37.7141066521182, -122.461801284944) | ||
| 64613 | 64613 | 31046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34803 | 6000734.07095 | 2088520.9414400002 | 37.714722198640004 | -122.439364601993 | (37.71472219864, -122.439364601993) | |
| 87100 | 87100 | 46750 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47629 | 5993206.8260224005 | 2088718.30816088 | 37.714832880195104 | -122.46539597604401 | (37.7148328801951, -122.465395976044) | ||
| 37616 | 37616 | 34801 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 311 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38437 | 5998132.09009 | 2088842.02869 | 37.715455411421 | -122.44838118866699 | (37.715455411421, -122.448381188667) | |
| 42579 | 42579 | 34802 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 5 | Permit Number 38438 | 5998143.868319999 | 2088884.5785 | 37.7155729168266 | -122.448343540327 | (37.7155729168266, -122.448343540327) | |
| 152311 | 152311 | 71324 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 591 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6003413.42989 | 2089070.32012 | 37.7163827878013 | -122.43014280626001 | (37.7163827878013, -122.43014280626) | ||
| 182311 | 182311 | 35841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 578 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 12 | Permit Number 39068 | 6003413.6457 | 2089149.24845 | 37.716599519939706 | -122.430147687789 | (37.7165995199397, -122.430147687789) | |
| 120897 | 120897 | 47368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45288 | 5993691.51889332 | 2089207.56073179 | 37.716204192433096 | -122.463756178051 | (37.7162041924331, -122.463756178051) | ||
| 176548 | 176548 | 50510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 731 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47145 | 6002571.72937 | 2089253.5566 | 37.71683820630321 | -122.433065216203 | (37.7168382063032, -122.433065216203) | |
| 157290 | 157290 | 49759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 214 Harkness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011567.181 | 2089303.38657 | 37.717481184695394 | -122.401975665657 | (37.7174811846954, -122.401975665657) | |
| 157113 | 157113 | 49758 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 214 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011575.84226 | 2089306.63415 | 37.7174905852902 | -122.401945955659 | (37.7174905852902, -122.401945955659) | |
| 63386 | 63386 | 49787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 488 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 5 | Permit Number 46571 | 6010133.11219 | 2089440.66928 | 37.7177779924458 | -122.40694227598101 | (37.7177779924458, -122.406942275981) | |
| 186770 | 186770 | 78427 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001123.9692400005 | 2089480.39079 | 37.7173788130682 | -122.43808564286199 | (37.7173788130682, -122.438085642862) | ||
| 48935 | 48935 | 50507 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 718 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47142 | 6001083.23309 | 2089505.44127 | 37.717445279265206 | -122.438228242065 | (37.7174452792652, -122.438228242065) | |
| 48190 | 48190 | 50506 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47141 | 6001113.88434 | 2089552.34071 | 37.717575797871 | -122.438125652794 | (37.717575797871, -122.438125652794) | |
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 106319 | 106319 | 35098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 710 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38640 | 6002142.25029691 | 2089673.27394965 | 37.71796628582229 | -122.43457970713999 | (37.7179662858223, -122.43457970714) | ||
| 78557 | 78557 | 35097 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38639 | 6002155.75551452 | 2089694.71254743 | 37.7180259181087 | -122.43453455761801 | (37.7180259181087, -122.434534557618) | ||
| 80982 | 80982 | 45310 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.46974489666401 | (37.71762835398, -122.469744896664) | ||
| 98262 | 98262 | 45311 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.46974489666401 | (37.71762835398, -122.469744896664) | ||
| 185984 | 185984 | 50509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 812 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47144 | 6003323.52841 | 2089782.3870599999 | 37.7183328750409 | -122.43050432831001 | (37.7183328750409, -122.43050432831) | |
| 183763 | 183763 | 72256 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 663 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002588.76079 | 2089788.4767900002 | 37.718307944930004 | -122.43304454347499 | (37.71830794493, -122.433044543475) | ||
| 118911 | 118911 | 50301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.39313641269699 | (37.7190642634607, -122.393136412697) | ||
| 104870 | 104870 | 45345 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 600 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607820998 | 37.7179713877014 | -122.46806434863701 | (37.7179713877014, -122.468064348637) | ||
| 179812 | 179812 | 40484 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 119 Shawnee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | 7 | Permit Number 41563 | 5998642.9116 | 2089895.24325 | 37.7183764894551 | -122.44669130408501 | (37.7183764894551, -122.446691304085) | |
| 115130 | 115130 | 47326 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 414 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45256 | 5993794.23352089 | 2089951.41466575 | 37.7182525554849 | -122.46345510031 | (37.7182525554849, -122.46345510031) | ||
| 44719 | 44719 | 71322 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | ||
| 86619 | 86619 | 68002 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 319 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31727 | 5992442.5315274 | 2089981.57315011 | 37.7182573914808 | -122.468129512391 | (37.7182573914808, -122.468129512391) | ||
| 104932 | 104932 | 45356 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 426 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44181 | 5993274.56615099 | 2090020.51787313 | 37.7184123415446 | -122.465256372075 | (37.7184123415446, -122.465256372075) | ||
| 92106 | 92106 | 68003 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 327 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31728 | 5992443.22144719 | 2090030.89079527 | 37.718392845598004 | -122.468130713203 | (37.718392845598, -122.468130713203) | ||
| 125624 | 125624 | 45317 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 630 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44154 | 5993535.31460225 | 2090042.0802023998 | 37.718486580043 | -122.46435664513399 | (37.718486580043, -122.464356645134) | ||
| 132317 | 132317 | 71316 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.43035851582701 | (37.7192106439431, -122.430358515827) | ||
| 109953 | 109953 | 67977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31701 | 5996184.66753333 | 2090103.76165833 | 37.71880830123929 | -122.45520343579099 | (37.7188083012393, -122.455203435791) | ||
| 33004 | 33004 | 37858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 566St. Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 7 | Permit Number 40145 | 6001842.58186 | 2090205.4937 | 37.719410626184796 | -122.43565358376699 | (37.7194106261848, -122.435653583767) | |
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 64790 | 64790 | 65520 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | Permit Number 28407 | 6001857.077269999 | 2090228.1127 | 37.7194735562312 | -122.435605095905 | (37.7194735562312, -122.435605095905) | |
| 94349 | 94349 | 68004 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 359 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1994 12:00:00 AM | Permit Number 31729 | 5992445.98112632 | 2090228.1613758998 | 37.718934662037505 | -122.468135516498 | (37.7189346620375, -122.468135516498) | ||
| 74408 | 74408 | 83942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6015103.3012 | 2090231.7832 | 37.72022710350421 | -122.389817632552 | (37.7202271035042, -122.389817632552) | ||
| 143586 | 143586 | 48582 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 366 Stratford Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45896 | 5991035.37424613 | 2090234.08230991 | 37.7188693517925 | -122.473011814307 | (37.7188693517925, -122.473011814307) | ||
| 85828 | 85828 | 67978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 55 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | Permit Number 31702 | 5996187.33843084 | 2090254.51404047 | 37.719222385048795 | -122.455205091912 | (37.7192223850488, -122.455205091912) | ||
| 99514 | 99514 | 45346 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 374 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44174 | 5992499.3558781 | 2090326.06927027 | 37.719206575715496 | -122.46795814020001 | (37.7192065757155, -122.4679581402) | ||
| 98339 | 98339 | 35842 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 545 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39069 | 6003002.28967479 | 2090438.03848066 | 37.720114945873206 | -122.43166149970301 | (37.7201149458732, -122.431661499703) | ||
| 176751 | 176751 | 78312 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 546 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6002946.84027 | 2090441.1993599997 | 37.720120481761704 | -122.431853395021 | (37.7201204817617, -122.431853395021) | ||
| 78524 | 78524 | 47338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 80317 | 80317 | 47339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 92211 | 92211 | 47340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 109019 | 109019 | 45315 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48950 | 5992447.6424105 | 2090467.99586353 | 37.7195932851189 | -122.468147211188 | (37.7195932851189, -122.468147211188) | ||
| 123992 | 123992 | 47341 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 615 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45268 | 5992432.680183999 | 2090468.17220354 | 37.7195929051759 | -122.468198942558 | (37.7195929051759, -122.468198942558) | ||
| 79559 | 79559 | 47344 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 141094 | 141094 | 47343 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 178411 | 178411 | 71321 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6004246.979590001 | 2090473.3975400003 | 37.7202825081141 | -122.42736154309799 | (37.7202825081141, -122.427361543098) | ||
| 158396 | 158396 | 37841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 5 | Permit Number 40135 | 6004769.12053 | 2090484.0078 | 37.72034115831121 | -122.42555742754499 | (37.7203411583112, -122.425557427545) | |
| 164887 | 164887 | 37842 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 6 | Permit Number 40135 | 6004757.56597 | 2090489.6511 | 37.7203560007008 | -122.425597769339 | (37.7203560007008, -122.425597769339) | |
| 36830 | 36830 | 32000 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.9843099997 | 37.7203526336359 | -122.42585972476299 | (37.7203526336359, -122.425859724763) | |
| 124678 | 124678 | 47332 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 131 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45263 | 5993704.23092481 | 2090493.94065656 | 37.7197370153769 | -122.463805555403 | (37.7197370153769, -122.463805555403) | ||
| 176732 | 176732 | 31999 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 7 | Permit Number 35398 | 6004667.05838 | 2090499.06627 | 37.72037673816379 | -122.42591129458201 | (37.7203767381638, -122.425911294582) | |
| 128660 | 128660 | 45314 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 608 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44151 | 5992448.25522328 | 2090519.99225245 | 37.7197360899317 | -122.468148873343 | (37.7197360899317, -122.468148873343) | ||
| 116141 | 116141 | 47342 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 636 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45269 | 5992378.43149497 | 2090520.81517255 | 37.719734316666205 | -122.46839028687799 | (37.7197343166662, -122.468390286878) | ||
| 32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
| 11987 | 11987 | 50020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1208 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 4 | 2.5x4 | Permit Number 46754 | 6009698.1958800005 | 2090561.7050599998 | 37.7208317780481 | -122.408524628629 | (37.7208317780481, -122.408524628629) |
| 116335 | 116335 | 60984 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20795 | 5994770.81866401 | 2090632.92031204 | 37.7201800257747 | -122.460128829497 | (37.7201800257747, -122.460128829497) | ||
| 100868 | 100868 | 53390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 307 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20783 | 5994718.82728479 | 2090633.86714187 | 37.7201796349623 | -122.46030861360599 | (37.7201796349623, -122.460308613606) | ||
| 100188 | 100188 | 60983 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 310 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20794 | 5994771.28000526 | 2090658.25302484 | 37.720249609888896 | -122.460129069137 | (37.7202496098889, -122.460129069137) | ||
| 47754 | 47754 | 78568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | ||
| 126118 | 126118 | 60982 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20793 | 5994771.74134651 | 2090683.58573763 | 37.72031919400229 | -122.46012930877701 | (37.7203191940023, -122.460129308777) | ||
| 140885 | 140885 | 60975 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 315 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20782 | 5994719.74996729 | 2090684.53256746 | 37.7203188031892 | -122.46030909322201 | (37.7203188031892, -122.460309093222) | ||
| 177871 | 177871 | 78222 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) |
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");