Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
100579 | 100579 | 117313 | Permitted Site 1 | :: 54 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981355.6 | 2109736.3 | 37.7718518197324 | -122.50791691513099 | (37.7718518197324, -122.507916915131) | |||||
116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
92619 | 92619 | 115024 | Permitted Site 1 | :: 54 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079.0 | 37.739963544351504 | -122.500032889381 | (37.7399635443515, -122.500032889381) | ||||
86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
113500 | 113500 | 109261 | Permitted Site 1 | :: 54 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
122432 | 122432 | 124725 | Permitted Site 1 | :: 54 | 846 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5984221.0 | 2110064.0 | 37.772920001740104 | -122.498029654692 | (37.7729200017401, -122.498029654692) | |||
103251 | 103251 | 38126 | Permitted Site 1 | :: 54 | 2822 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40290 | 5987014.20991985 | 2106446.11642248 | 37.7631496691658 | -122.488101839973 | (37.7631496691658, -122.488101839973) | ||
81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
104342 | 104342 | 95908 | Permitted Site 1 | :: 54 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767609 | 5987396.4 | 2105326.0 | 37.760096425656705 | -122.486697735896 | (37.7600964256567, -122.486697735896) | |
96541 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
85364 | 85364 | 115892 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
98575 | 98575 | 115891 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
101195 | 101195 | 115894 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
144086 | 144086 | 115893 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
85267 | 85267 | 46322 | Permitted Site 1 | :: 54 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.731428183192705 | -122.480829241755 | (37.7314281831927, -122.480829241755) | |||
78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
81995 | 81995 | 37632 | Permitted Site 1 | :: 54 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40050 | 5990357.50342651 | 2110002.09732806 | 37.773107903504794 | -122.476798459473 | (37.7731079035048, -122.476798459473) | ||
110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
129236 | 129236 | 41854 | Permitted Site 1 | :: 54 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42241 | 5991990.35837611 | 2105257.12694546 | 37.7601740626082 | -122.47080455929701 | (37.7601740626082, -122.470804559297) | ||
86244 | 86244 | 41853 | Permitted Site 1 | :: 54 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42240 | 5992008.2421953 | 2105257.75589238 | 37.7601768237518 | -122.470742754033 | (37.7601768237518, -122.470742754033) | ||
78333 | 78333 | 38003 | Permitted Site 1 | :: 54 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2002 12:00:00 AM | Permit Number 40215 | 5992069.67302471 | 2098579.11634993 | 37.74184256230679 | -122.47004399101499 | (37.7418425623068, -122.470043991015) | ||
18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
140174 | 140174 | 31188 | Permitted Site 1 | :: 54 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
142035 | 142035 | 31191 | Permitted Site 1 | :: 54 | 744 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
146146 | 146146 | 31190 | Permitted Site 1 | :: 54 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
110497 | 110497 | 38040 | Permitted Site 1 | :: 54 | 271 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40242 | 5992319.7729488 | 2097504.33557698 | 37.7389059415194 | -122.46910103166401 | (37.7389059415194, -122.469101031664) | ||
93962 | 93962 | 115298 | Permitted Site 1 | :: 54 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||||
2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
99253 | 99253 | 117318 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
105387 | 105387 | 117319 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
129313 | 129313 | 117320 | Permitted Site 1 | :: 54 | 1935 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | ||
10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
114617 | 114617 | 105046 | Permitted Site 1 | :: 54 | 268 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | ||||||
81650 | 81650 | 45785 | Permitted Site 1 | :: 54 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | |||
121409 | 121409 | 45784 | Permitted Site 1 | :: 54 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | ||
3276 | 3276 | 149033 | Permitted Site 1 | :: 54 | 3916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2017 12:00:00 AM | 3 | 5.5x12 | 5996085.364440001 | 2114918.02173 | 37.7869363183091 | -122.45734088598302 | (37.7869363183091, -122.457340885983) | ||
77581 | 77581 | 33407 | Permitted Site 1 | :: 54 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
79062 | 79062 | 33409 | Permitted Site 1 | :: 54 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
87303 | 87303 | 33408 | Permitted Site 1 | :: 54 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
91200 | 91200 | 33411 | Permitted Site 1 | :: 54 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
99156 | 99156 | 33410 | Permitted Site 1 | :: 54 | 100 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
140197 | 140197 | 33406 | Permitted Site 1 | :: 54 | 100 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
51323 | 51323 | 33210 | Permitted Site 1 | :: 54 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
83937 | 83937 | 33209 | Permitted Site 1 | :: 54 | 80 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
126759 | 126759 | 31148 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
122041 | 122041 | 38338 | Permitted Site 1 | :: 54 | 73 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1998 12:00:00 AM | Permit Number 40405 | 5998234.47777194 | 2107177.32360217 | 37.7658055638462 | -122.44934755802 | (37.7658055638462, -122.44934755802) | |||
111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
98437 | 98437 | 113995 | Permitted Site 1 | :: 54 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692456996 | -122.44641142836599 | (37.789931692457, -122.446411428366) | |||
42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
117141 | 117141 | 115013 | Permitted Site 1 | :: 54 | 2493 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 5999602.09209 | 2119817.77431 | 37.8005911003042 | -122.44552631681499 | (37.8005911003042, -122.445526316815) | ||||
127606 | 127606 | 40513 | Permitted Site 1 | :: 54 | 1620 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41577 | 5999999.85509787 | 2110944.48687978 | 37.7762500681911 | -122.443512144169 | (37.7762500681911, -122.443512144169) | ||
92536 | 92536 | 114785 | Permitted Site 1 | :: 54 | 2459 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 6000398.9 | 2113706.0 | 37.7838552262656 | -122.44233003645701 | (37.7838552262656, -122.442330036457) | ||||
49594 | 49594 | 112605 | Permitted Site 1 | :: 54 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465.0 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | |||
109892 | 109892 | 36905 | Permitted Site 1 | :: 54 | 4416 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39553 | 6000517.15649148 | 2102301.36938584 | 37.7525476968755 | -122.441102423403 | (37.7525476968755, -122.441102423403) | ||
118536 | 118536 | 36929 | Permitted Site 1 | :: 54 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39571 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
87925 | 87925 | 104864 | Permitted Site 1 | :: 54 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000629.3 | 2102650.0 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | ||||||
98032 | 98032 | 114972 | Permitted Site 1 | :: 54 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6000962.5 | 2110659.8 | 37.775523242518794 | -122.440161680014 | (37.7755232425188, -122.440161680014) | |||
118121 | 118121 | 36924 | Permitted Site 1 | :: 54 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39568 | 6001154.35821609 | 2103257.26025902 | 37.755208616744795 | -122.438967374074 | (37.7552086167448, -122.438967374074) | ||
20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
106864 | 106864 | 109768 | Permitted Site 1 | :: 54 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
88689 | 88689 | 109762 | Permitted Site 1 | :: 54 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
97786 | 97786 | 109767 | Permitted Site 1 | :: 54 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
142347 | 142347 | 109178 | Permitted Site 1 | :: 54 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.796184544404895 | -122.438522078694 | (37.7961845444049, -122.438522078694) | |||
81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
112497 | 112497 | 104858 | Permitted Site 1 | :: 54 | 4205 24th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6001816.0 | 2101720.7 | 37.7510272133613 | -122.43656924920201 | (37.7510272133613, -122.436569249202) | ||||||
139436 | 139436 | 35137 | Permitted Site 1 | :: 54 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | ||
85490 | 85490 | 52296 | Permitted Site 1 | :: 54 | 677DIAMOND ST Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48457 | 6002165.96993722 | 2099704.44459938 | 37.7455109340163 | -122.435214819168 | (37.7455109340163, -122.435214819168) | ||
80004 | 80004 | 35095 | Permitted Site 1 | :: 54 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.718911055862606 | -122.43365900206499 | (37.7189110558626, -122.433659002065) | ||
89307 | 89307 | 105925 | Permitted Site 1 | :: 54 | 4166 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6002608.6 | 2104160.0 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | |||||
143116 | 143116 | 37316 | Permitted Site 1 | :: 54 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39831 | 6002632.74186614 | 2103295.45378084 | 37.755397491549 | -122.433857422868 | (37.755397491549, -122.433857422868) | ||
110326 | 110326 | 37315 | Permitted Site 1 | :: 54 | 561 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39830 | 6002709.44183784 | 2103247.60813838 | 37.7552704710237 | -122.43358875215 | (37.7552704710237, -122.43358875215) | ||
88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
118010 | 118010 | 109755 | Permitted Site 1 | :: 54 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) |
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");