Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3195 | 3195 | 253357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3217 | 3217 | 253347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
67560 | 67560 | 117168 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
77426 | 77426 | 91342 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
80148 | 80148 | 44164 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
87038 | 87038 | 49405 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 288@ OCEAN Onondaga Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
87240 | 87240 | 42765 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
88252 | 88252 | 35302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
88347 | 88347 | 32171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
88882 | 88882 | 45551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Sloat Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.734477258874605 | -122.47556548665399 | (37.7344772588746, -122.475565486654) | |||
90604 | 90604 | 110547 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
91237 | 91237 | 36246 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Surrey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
92238 | 92238 | 104081 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2610 Lake St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | |||||
98503 | 98503 | 88230 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
100139 | 100139 | 119864 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
101920 | 101920 | 36432 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
102559 | 102559 | 43833 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388718998 | 37.737232941963605 | -122.492392332362 | (37.7372329419636, -122.492392332362) | ||
113796 | 113796 | 36033 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1660X BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39178 | 6009346.0 | 2106886.0 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | |||
124768 | 124768 | 109159 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
126836 | 126836 | 37264 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
140103 | 140103 | 40946 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
143683 | 143683 | 115685 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
144073 | 144073 | 43324 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 32 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43085 | 6004171.91569518 | 2093420.14794731 | 37.728369388097896 | -122.427830872105 | (37.7283693880979, -122.427830872105) | ||
144834 | 144834 | 50537 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
144915 | 144915 | 43004 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Rose St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
144990 | 144990 | 119871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
145207 | 145207 | 107756 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | ||||
29397 | 29397 | 38753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.780869712107396 | -122.40145140226002 | (37.7808697121074, -122.40145140226) | ||
32754 | 32754 | 138797 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | |||
74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
182335 | 182335 | 178911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993783.22919 | 2086769.82188 | 37.709516025103895 | -122.46326239735201 | (37.7095160251039, -122.463262397352) | ||||
24350 | 24350 | 214468 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997445.526980001 | 2095470.2100900002 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | |||
52419 | 52419 | 139419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1675 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004207.4112 | 2114251.7374 | 37.785570015468295 | -122.42919292902201 | (37.7855700154683, -122.429192929022) | |||
65283 | 65283 | 139134 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1825 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003440.8714 | 2114149.8668 | 37.7852468810092 | -122.43183765526001 | (37.7852468810092, -122.43183765526) | |||
69243 | 69243 | 244108 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1950 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997159.4208 | 2108812.5222 | 37.7702338463195 | -122.453183989334 | (37.7702338463195, -122.453183989334) | |||
136002 | 136002 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | ||||
158770 | 158770 | 139145 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004390.5718 | 2114066.8594 | 37.78507275369729 | -122.428546063814 | (37.7850727536973, -122.428546063814) | |||
853 | 853 | 244350 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.77512539438639 | -122.424035805431 | (37.7751253943864, -122.424035805431) | ||
6039 | 6039 | 23898 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003553.1196 | 2113987.2345 | 37.7848066960652 | -122.43143769715701 | (37.7848066960652, -122.431437697157) | ||
9984 | 9984 | 106984 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 3 | 6003775.6189 | 2114189.0991 | 37.7853735733153 | -122.430682332536 | (37.7853735733153, -122.430682332536) | |||
11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
55206 | 55206 | 196381 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | |||
96146 | 96146 | 29251 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
103342 | 103342 | 12426 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1701X Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 4X4 | 6004430.116669999 | 2114714.4618599997 | 37.786853145727704 | -122.428455426283 | (37.7868531457277, -122.428455426283) | ||
128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
153541 | 153541 | 178882 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | |||
175411 | 175411 | 139396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 496 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005003.1486 | 2111107.1822 | 37.7769808572422 | -122.426215953949 | (37.7769808572422, -122.426215953949) | |||
11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
37179 | 37179 | 138872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005567.8228 | 2110765.4538 | 37.7760744547885 | -122.424238259715 | (37.7760744547885, -122.424238259715) | |||
52137 | 52137 | 138975 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 461 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005450.5842 | 2110864.9202 | 37.776340944809704 | -122.42465089693 | (37.7763409448097, -122.42465089693) | |||
86381 | 86381 | 178934 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000059.66319 | 2091611.4621 | 37.7231696637395 | -122.441917314134 | (37.7231696637395, -122.441917314134) | |||
100203 | 100203 | 44089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | |
131288 | 131288 | 214437 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 602 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992311.89414 | 2104591.93492 | 37.758366209443295 | -122.46964410348998 | (37.7583662094433, -122.46964410349) | |||
131299 | 131299 | 135912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.40432297534402 | (37.7991816185927, -122.404322975344) | ||||
5993 | 5993 | 23902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | |||
147356 | 147356 | 214460 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001504.80171 | 2094910.40142 | 37.732310042080606 | -122.437157847364 | (37.7323100420806, -122.437157847364) | |||
176104 | 176104 | 196413 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009790.62694 | 2111119.41573 | 37.7772838848824 | -122.40965538310101 | (37.7772838848824, -122.409655383101) | |||
5957 | 5957 | 28643 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.43088139933201 | (37.7829985565916, -122.430881399332) | |||
26502 | 26502 | 196418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010052.79507 | 2110841.7577299997 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) |
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");