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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | ||||||||
82643 | 82643 | 20854 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1892X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
105157 | 105157 | 21218 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
143219 | 143219 | 21220 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
90456 | 90456 | 21221 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
84153 | 84153 | 21725 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1938X Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003302.068331299 | 2114526.316247 | 37.786272646739796 | -122.43234476672501 | (37.7862726467398, -122.432344766725) | |||
123086 | 123086 | 22830 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 88 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999067.1751904 | 2099480.26243 | 37.7447189259574 | -122.44591380563101 | (37.7447189259574, -122.445913805631) | |||
23254 | 23254 | 22843 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999765.52429 | 2099012.7663 | 37.7434751450586 | -122.443465482663 | (37.7434751450586, -122.443465482663) | |||
17951 | 17951 | 22845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1997 12:00:00 AM | 16 | 1X1 | 5999785.45831 | 2099029.41993 | 37.7435220087408 | -122.44339775201401 | (37.7435220087408, -122.443397752014) | ||
139335 | 139335 | 22846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999247.2741693 | 2099079.9876616 | 37.7436301498813 | -122.44526228700501 | (37.7436301498813, -122.445262287005) | |||
19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
19919 | 19919 | 22857 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 140 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5999962.5857 | 2099158.01646 | 37.743885203545396 | -122.442794523662 | (37.7438852035454, -122.442794523662) | ||||
45341 | 45341 | 23899 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
125348 | 125348 | 23901 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
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) | |||
21899 | 21899 | 24817 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.5090299998 | 37.7329044714678 | -122.41475991886101 | (37.7329044714678, -122.414759918861) | ||
16930 | 16930 | 25410 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.769705817804606 | -122.423571815294 | (37.7697058178046, -122.423571815294) | ||
18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
13496 | 13496 | 25978 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2027 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/1997 12:00:00 AM | 8 | 6x9 | 6012757.293869999 | 2097148.7726200002 | 37.7390893573798 | -122.39841214252701 | (37.7390893573798, -122.398412142527) | ||
16805 | 16805 | 25996 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.39356660700899 | (37.7363419456235, -122.393566607009) | ||
13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
16894 | 16894 | 26124 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.732840515342104 | -122.387408617446 | (37.7328405153421, -122.387408617446) | |||
14968 | 14968 | 26618 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1295 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011596.48977 | 2093221.8488599998 | 37.7282421152608 | -122.402149690774 | (37.7282421152608, -122.402149690774) | |||
20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
21918 | 21918 | 26668 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.51366 | 2108390.09444 | 37.769542278768505 | -122.42468260394199 | (37.7695422787685, -122.424682603942) | |||
12256 | 12256 | 26978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004762.815690001 | 2093485.8585299999 | 37.7285832245248 | -122.42579277741001 | (37.7285832245248, -122.42579277741) | |||
11578 | 11578 | 27091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006120.2550800005 | 2093595.10299 | 37.7289598021321 | -122.42110777902398 | (37.7289598021321, -122.421107779024) | |||
11228 | 11228 | 27092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006103.20931 | 2093594.9436599999 | 37.728958403708894 | -122.42116669629699 | (37.7289584037089, -122.421166696297) | |||
21625 | 21625 | 27417 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.17444 | 2100908.10154 | 37.7489472688119 | -122.427284553046 | (37.7489472688119, -122.427284553046) | |||
11708 | 11708 | 27702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1140 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2000 12:00:00 AM | 6 | 2X3 | 6008343.29575 | 2093842.41085 | 37.729763925549506 | -122.41344002075701 | (37.7297639255495, -122.413440020757) | ||
270 | 270 | 28098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 639 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 3X3 | 6001577.9698 | 2110674.4978 | 37.7755986195101 | -122.438033679217 | (37.7755986195101, -122.438033679217) | ||
118700 | 118700 | 28146 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 429 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006920.737469 | 2097958.7102788 | 37.7409864003091 | -122.418649764286 | (37.7409864003091, -122.418649764286) | |||
19941 | 19941 | 28386 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 9 | 3X3 | 6009842.67473 | 2101317.3868299997 | 37.750372664569504 | -122.408783629764 | (37.7503726645695, -122.408783629764) | ||
18134 | 18134 | 28387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1271 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2003 12:00:00 AM | 3 | 3X3 | 6004513.78886 | 2101505.14883 | 37.7505882968197 | -122.427224669004 | (37.7505882968197, -122.427224669004) | ||
1535 | 1535 | 28642 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.782921429068395 | -122.430862736641 | (37.7829214290684, -122.430862736641) | |||
124198 | 124198 | 28645 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
125690 | 125690 | 28649 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
138849 | 138849 | 28652 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
142975 | 142975 | 28653 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
113023 | 113023 | 28841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 366 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2005 12:00:00 AM | 12 | 3X3 | 5995586.0711199995 | 2114021.88834 | 37.784447087073396 | -122.45900340593398 | (37.7844470870734, -122.459003405934) | ||
105963 | 105963 | 28850 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
88514 | 88514 | 28851 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
123223 | 123223 | 28852 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
141442 | 141442 | 28853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
139447 | 139447 | 28854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
90239 | 90239 | 28855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
142523 | 142523 | 30301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48196 | 5990498.42551573 | 2114680.4203788997 | 37.7859614580277 | -122.47665285108299 | (37.7859614580277, -122.476652851083) | |||
184905 | 184905 | 30305 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | 9 | Permit Number 7 | 5996194.44946 | 2113622.43964 | 37.7833852609546 | -122.456869738263 | (37.7833852609546, -122.456869738263) | ||
170334 | 170334 | 30308 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | 12 | Permit Number 7 | 5996193.65871 | 2113633.69704 | 37.7834161253698 | -122.456873288412 | (37.7834161253698, -122.456873288412) | ||
42301 | 42301 | 30496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1985 12:00:00 AM | 5 | Permit Number 22043 | 6001850.15003 | 2117377.4559 | 37.7940187069382 | -122.43757227473999 | (37.7940187069382, -122.43757227474) | ||
92514 | 92514 | 30573 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691001 | (37.7705964833806, -122.42785438691) | ||
162119 | 162119 | 30574 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | |
52581 | 52581 | 30766 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.729643069645704 | -122.391775180038 | (37.7296430696457, -122.391775180038) | |
25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
73597 | 73597 | 30774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.39507154151501 | (37.7805707972354, -122.395071541515) |
114586 | 114586 | 30860 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
85298 | 85298 | 30861 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
6855 | 6855 | 30870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.787971137606895 | -122.436932736614 | (37.7879711376069, -122.436932736614) | |
169350 | 169350 | 30871 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 9 | 3x3 | Permit Number 34705 | 6001987.0249 | 2115189.9174 | 37.788020071895794 | -122.436941993701 | (37.7880200718958, -122.436941993701) | |
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) | ||
97225 | 97225 | 31025 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
83938 | 83938 | 31026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
129018 | 129018 | 31027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
100665 | 100665 | 31028 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34791 | 6006941.23220098 | 2096843.72202515 | 37.737926044164794 | -122.418499857351 | (37.7379260441648, -122.418499857351) | |||
113429 | 113429 | 31029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34791 | 6006941.23220098 | 2096843.72202515 | 37.737926044164794 | -122.418499857351 | (37.7379260441648, -122.418499857351) | |||
126110 | 126110 | 31030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34792 | 6006952.41167603 | 2096789.60681619 | 37.737778085142295 | -122.418457368251 | (37.7377780851423, -122.418457368251) | |||
141227 | 141227 | 31031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34793 | 6006978.02662143 | 2096838.48513192 | 37.7379137361446 | -122.418372269478 | (37.7379137361446, -122.418372269478) | |||
138357 | 138357 | 31032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 88 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34794 | 6007048.99704691 | 2096775.85996902 | 37.7377457761671 | -122.418122450801 | (37.7377457761671, -122.418122450801) | |||
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) | |
144651 | 144651 | 31047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34803 | 6000718.58674958 | 2088518.12227815 | 37.7147135766514 | -122.43941791967501 | (37.7147135766514, -122.439417919675) | |||
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) | |
116648 | 116648 | 31063 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
81400 | 81400 | 31064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
113164 | 113164 | 31065 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
143600 | 143600 | 31066 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
92264 | 92264 | 31067 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34814 | 6007710.23060996 | 2107394.98126032 | 37.7669406704491 | -122.41658826699499 | (37.7669406704491, -122.416588266995) | |||
96508 | 96508 | 31080 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
79541 | 79541 | 31081 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
123857 | 123857 | 31090 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
109007 | 109007 | 31091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
17368 | 17368 | 31107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 237 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 12 | 2x9 | Permit Number 34836 | 5998741.10559 | 2093696.6729599999 | 37.7288199422639 | -122.44662524706101 | (37.7288199422639, -122.446625247061) | |
156886 | 156886 | 31200 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 580 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34891 | 6002645.8184400005 | 2102709.5548400003 | 37.7537894947999 | -122.433770326052 | (37.7537894947999, -122.433770326052) | ||
26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) | |
125483 | 125483 | 31233 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34918 | 5991384.46211768 | 2098059.72003712 | 37.740376797876 | -122.47237534801901 | (37.740376797876, -122.472375348019) | ||
59734 | 59734 | 31234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34919 | 5991432.5751 | 2098011.68272 | 37.740247684195204 | -122.472205493211 | (37.7402476841952, -122.472205493211) | |
150061 | 150061 | 31235 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34919 | 5991433.59287 | 2097992.23332 | 37.740194340008394 | -122.47220055682699 | (37.7401943400084, -122.472200556827) | |
158191 | 158191 | 31239 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2666 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34923 | 5991460.800919999 | 2097279.0781900003 | 37.738237772244396 | -122.47205451591199 | (37.7382377722444, -122.472054515912) | |
57345 | 57345 | 31240 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2522 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34924 | 5991117.01739 | 2098221.31702 | 37.740805019224204 | -122.47331184006599 | (37.7408050192242, -122.473311840066) | |
176285 | 176285 | 31243 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2526 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34926 | 5991119.14799 | 2098201.16942 | 37.740749822448294 | -122.47330300423401 | (37.7407498224483, -122.473303004234) | |
83339 | 83339 | 31245 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097800.52101 | 37.739632092076 | -122.47432756819299 | (37.739632092076, -122.474327568193) | ||
85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) |
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");