Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
10575 | 10575 | 20040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
10952 | 10952 | 43297 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | Permit Number 43066 | ||||||||
11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
12976 | 12976 | 20042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
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) | |
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) | |
28269 | 28269 | 178750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009169.8221 | 2086336.97845 | 37.709201944987605 | -122.410052964391 | (37.7092019449876, -122.410052964391) | |||
40286 | 40286 | 178844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6009171.05644 | 2086338.49099 | 37.7092061672978 | -122.410048805012 | (37.7092061672978, -122.410048805012) | |||
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) | ||
33909 | 33909 | 178753 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 288 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008616.33006 | 2086415.6536599998 | 37.7093869328198 | -122.41197148180099 | (37.7093869328198, -122.411971481801) | |||
165737 | 165737 | 178848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 284 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008617.09448 | 2086417.42045 | 37.709391826951105 | -122.411968964603 | (37.7093918269511, -122.411968964603) | |||
123650 | 123650 | 24288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001280.10777 | 2086581.3596299998 | 37.709427595658795 | -122.43733847618401 | (37.7094275956588, -122.437338476184) | |||
155545 | 155545 | 178843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 316 Naylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002755.16684 | 2086552.83016 | 37.7094330059866 | -122.432238395683 | (37.7094330059866, -122.432238395683) | |||
44971 | 44971 | 178752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 276 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008629.54675 | 2086454.27777 | 37.7094937282293 | -122.411928530185 | (37.7094937282293, -122.411928530185) | |||
171245 | 171245 | 178847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 272 Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008631.68261 | 2086459.28689 | 37.7095076020765 | -122.411921502003 | (37.7095076020765, -122.411921502003) | |||
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) | |
134446 | 134446 | 178705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996782.39454 | 2086708.5296099999 | 37.7095200567877 | -122.452892407466 | (37.7095200567877, -122.452892407466) | |||
108284 | 108284 | 86728 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49704 | 5996769.2 | 2086717.1 | 37.7095428329763 | -122.452938628006 | (37.7095428329763, -122.452938628006) | ||||
39728 | 39728 | 178751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 272 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008644.3214 | 2086482.2621 | 37.709571396371395 | -122.411879442491 | (37.7095713963714, -122.411879442491) | |||
51803 | 51803 | 178846 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 272 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008639.83625 | 2086484.9507 | 37.7095785270867 | -122.411895133863 | (37.7095785270867, -122.411895133863) | |||
176572 | 176572 | 178833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6001567.75342 | 2086664.56423 | 37.709672405530796 | -122.43635027774401 | (37.7096724055308, -122.436350277744) | |||
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) | |
167416 | 167416 | 178834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001553.31629 | 2086683.73815 | 37.7097242325659 | -122.43640154631201 | (37.7097242325659, -122.436401546312) | |||
30587 | 30587 | 178835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001544.783340001 | 2086699.50707 | 37.709767045691294 | -122.436432165527 | (37.7097670456913, -122.436432165527) | |||
53625 | 53625 | 178836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001534.9682599995 | 2086713.04585 | 37.7098036624786 | -122.436467056534 | (37.7098036624786, -122.436467056534) | |||
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) | |
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) | |
99158 | 99158 | 178837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001551.41306 | 2086770.9715900002 | 37.7099636482706 | -122.43641436345301 | (37.7099636482706, -122.436414363453) | |||
60318 | 60318 | 178838 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001561.306469999 | 2086771.17725 | 37.7099647751299 | -122.436380184711 | (37.7099647751299, -122.436380184711) | |||
178112 | 178112 | 178839 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 921 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001840.757 | 2086804.7866200001 | 37.7100729338953 | -122.435416754499 | (37.7100729338953, -122.435416754499) | |||
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) | ||
57287 | 57287 | 178739 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 416 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012199.66481 | 2086699.2931099997 | 37.7103661434655 | -122.39960671288999 | (37.7103661434655, -122.39960671289) | |||
137051 | 137051 | 178842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | |||
59060 | 59060 | 178841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002067.276880001 | 2086921.00065 | 37.710404894347704 | -122.434642162998 | (37.7104048943477, -122.434642162998) | |||
45234 | 45234 | 178756 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 47 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008299.13366 | 2086795.4391400001 | 37.710411944121596 | -122.413094604643 | (37.7104119441216, -122.413094604643) | |||
31556 | 31556 | 178755 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008316.596469999 | 2086843.3583099998 | 37.710544500606396 | -122.413037635286 | (37.7105445006064, -122.413037635286) | |||
185410 | 185410 | 178754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 27 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008327.5198 | 2086871.77855 | 37.7106231499219 | -122.41300188991801 | (37.7106231499219, -122.413001889918) | |||
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) | ||
164778 | 164778 | 178845 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007634.8415 | 2086934.3968099998 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | |||
71089 | 71089 | 84187 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 543 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50696 | 6007633.86618 | 2086936.80805 | 37.7107627444765 | -122.41540391795601 | (37.7107627444765, -122.415403917956) | |
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) | ||
76801 | 76801 | 178696 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008480.0549800005 | 2086950.0388900002 | 37.7108465981642 | -122.41248022108101 | (37.7108465981642, -122.412480221081) | |||
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) | ||
183711 | 183711 | 178832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 26 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002753.4939 | 2087126.6504400002 | 37.711008496830004 | -122.43228513165 | (37.71100849683, -122.43228513165) | |||
68434 | 68434 | 178697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 170 Lawrence Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996822.297619999 | 2087264.10807 | 37.7110478340594 | -122.452794569318 | (37.7110478340594, -122.452794569318) | |||
162407 | 162407 | 65315 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 543 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 18 | Permit Number 28137 | 6013067.51643 | 2086945.4340000001 | 37.711090336012504 | -122.39662445846001 | (37.7110903360125, -122.39662445846) | ||
40726 | 40726 | 178738 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 88 Gillette Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013102.20794 | 2086955.43637 | 37.7111197312489 | -122.39650525601002 | (37.7111197312489, -122.39650525601) | |||
72038 | 72038 | 178737 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013141.93389 | 2086956.08513 | 37.7111237233427 | -122.39636799789801 | (37.7111237233427, -122.396367997898) | |||
133075 | 133075 | 178840 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1065 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002119.38667 | 2087187.3937099997 | 37.711139309492395 | -122.434481095339 | (37.7111393094924, -122.434481095339) | |||
130179 | 130179 | 212611 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 241 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994544.18385 | 2087742.4739 | 37.7122305082008 | -122.460702867445 | (37.7122305082008, -122.460702867445) | |||
162276 | 162276 | 178704 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Rae Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998308.33595 | 2087754.71225 | 37.712479963948496 | -122.44769377924601 | (37.7124799639485, -122.447693779246) | |||
73556 | 73556 | 178703 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Rae Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998317.89725 | 2087761.99008 | 37.712500493666795 | -122.447661256171 | (37.7125004936668, -122.447661256171) | |||
159346 | 159346 | 178702 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Rae Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998336.16892 | 2087781.41779 | 37.7125548819847 | -122.447599501525 | (37.7125548819847, -122.447599501525) | |||
43021 | 43021 | 178701 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Rae Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998344.49014 | 2087790.45997 | 37.7125801853098 | -122.447571391401 | (37.7125801853098, -122.447571391401) | |||
71553 | 71553 | 178700 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998352.64125 | 2087797.95549 | 37.712601232130496 | -122.447543757946 | (37.7126012321305, -122.447543757946) | |||
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) | ||
138062 | 138062 | 178735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 110 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000958.61329 | 2087891.23319 | 37.7130059360373 | -122.438543401379 | (37.7130059360373, -122.438543401379) | |||
45832 | 45832 | 178734 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 110 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000949.06967 | 2087917.1354 | 37.7130765148503 | -122.438578241996 | (37.7130765148503, -122.438578241996) | |||
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) | ||
149450 | 149450 | 178733 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 6000880.0864 | 2087963.6418299999 | 37.713200286736495 | -122.438820001354 | (37.7132002867365, -122.438820001354) | |||
36157 | 36157 | 178736 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 248 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012387.77571 | 2087731.3187900002 | 37.713210365434 | -122.39902894795 | (37.713210365434, -122.39902894795) | |||
134948 | 134948 | 178732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 1ft | 6000912.22914 | 2087974.06631 | 37.713230738679705 | -122.43870965184601 | (37.7132307386797, -122.438709651846) | |||
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) |
40814 | 40814 | 212668 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5992987.499559999 | 2088299.56272 | 37.713670454102896 | -122.46612364171101 | (37.7136704541029, -122.466123641711) | |||
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) | ||
135511 | 135511 | 62994 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1986 12:00:00 AM | 1 | Permit Number 23395 | 5991750.67961 | 2088373.7278599998 | 37.7138026589318 | -122.470403898426 | (37.7138026589318, -122.470403898426) | ||
179163 | 179163 | 178699 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Sala Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5999039.32435 | 2088222.2943799999 | 37.7138055898272 | -122.44520086393 | (37.7138055898272, -122.44520086393) | |||
70802 | 70802 | 178698 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Sala Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 5999028.57689 | 2088233.4510700002 | 37.713835610093795 | -122.445238812629 | (37.7138356100938, -122.445238812629) | |||
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) | ||
75937 | 75937 | 84132 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 332 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50694 | 6008018.96296 | 2088075.22634 | 37.713910242141 | -122.41415342053999 | (37.713910242141, -122.41415342054) | |
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) | ||
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) | ||
33557 | 33557 | 212610 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 278 Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994199.47136 | 2088424.58434 | 37.714083582860106 | -122.461943718748 | (37.7140835828601, -122.461943718748) | |||
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) | ||
55579 | 55579 | 178749 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 309 Elliot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008837.67953 | 2088153.65534 | 37.7141715446555 | -122.411329156315 | (37.7141715446555, -122.411329156315) | |||
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) |
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");