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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
38919 | 38919 | 201349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774058998 | (37.7265656062986, -122.39784774059) | |||
44637 | 44637 | 201345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012754.450780001 | 2092609.0590599999 | 37.726624085606396 | -122.398103573427 | (37.7266240856064, -122.398103573427) | |||
131124 | 131124 | 201347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012791.8631 | 2092596.6146799999 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | |||
131673 | 131673 | 201354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6012921.134769999 | 2092559.31371 | 37.726496777601795 | -122.39752386145099 | (37.7264967776018, -122.397523861451) | |||
135032 | 135032 | 201351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012866.15074 | 2092573.2448900002 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | |||
149516 | 149516 | 201350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.726546458834896 | -122.397780348078 | (37.7265464588349, -122.397780348078) | |||
154484 | 154484 | 201353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.39758340285101 | (37.7265081621175, -122.397583402851) | |||
166848 | 166848 | 201346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.39803552533199 | (37.7266049372574, -122.398035525332) | |||
168356 | 168356 | 201352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012884.58431 | 2092567.5936099999 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | |||
173712 | 173712 | 201343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012739.9825 | 2092614.2530099999 | 37.72663754126479 | -122.39815395433399 | (37.7266375412648, -122.398153954334) | ||||
177390 | 177390 | 201348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012808.60563 | 2092591.5632900002 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | |||
26975 | 26975 | 129323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Florence St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | ||||
63937 | 63937 | 176847 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005714.45632 | 2093496.12065 | 37.7286651338862 | -122.422503626641 | (37.7286651338862, -122.422503626641) | |||
130258 | 130258 | 176848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005711.542330001 | 2093506.49571 | 37.728693457131 | -122.422514437416 | (37.728693457131, -122.422514437416) | |||
174196 | 174196 | 176849 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | |||
74388 | 74388 | 226884 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Hidalgo Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6005071.43074 | 2107486.3006599997 | 37.7670426518224 | -122.425721963013 | (37.7670426518224, -122.425721963013) | |||
93609 | 93609 | 124569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Jordan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996154.91779 | 2114511.96286 | 37.785825384071394 | -122.457070865676 | (37.7858253840714, -122.457070865676) | |||
37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
65 | 65 | 226926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | |||
39701 | 39701 | 129113 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | ||||
183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
45644 | 45644 | 218230 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993788.79546 | 2098675.54917 | 37.7422065730654 | -122.46410687336001 | (37.7422065730654, -122.46410687336) | |||
62797 | 62797 | 218228 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 5993822.95601 | 2098779.1266900003 | 37.742492939687 | -122.463996274721 | (37.742492939687, -122.463996274721) | |||
169741 | 169741 | 218229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5993803.00449 | 2098718.65979 | 37.7423257629199 | -122.464060872135 | (37.7423257629199, -122.464060872135) | |||
186117 | 186117 | 218231 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993773.53157 | 2098636.1244900003 | 37.7420974430581 | -122.464156789307 | (37.7420974430581, -122.464156789307) | |||
188348 | 188348 | 218225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 5993843.55646 | 2098914.16079 | 37.7428648966005 | -122.463934844718 | (37.7428648966005, -122.463934844718) | |||
188677 | 188677 | 218227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993831.45355 | 2098825.44748 | 37.742620614658 | -122.463970254628 | (37.742620614658, -122.463970254628) | |||
188774 | 188774 | 218226 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5993838.37632 | 2098869.25868 | 37.7427413081634 | -122.46394949738199 | (37.7427413081634, -122.463949497382) | |||
153807 | 153807 | 219373 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6001373.71026 | 2094967.00776 | 37.7324580174085 | -122.437615112141 | (37.7324580174085, -122.437615112141) | |||
62283 | 62283 | 219329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995365.77553 | 2090599.7710099998 | 37.7201232084876 | -122.45806987824699 | (37.7201232084876, -122.458069878247) | |||
104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
62666 | 62666 | 129281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008192.28376 | 2118905.24878 | 37.798572191203704 | -122.415736009712 | (37.7985721912037, -122.415736009712) | |||
72385 | 72385 | 129282 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6008205.81975 | 2118906.85431 | 37.798577360503394 | -122.415689284536 | (37.7985773605034, -122.415689284536) | |||
155651 | 155651 | 129280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008177.93776 | 2118903.66017 | 37.798567022807795 | -122.41578553897699 | (37.7985670228078, -122.415785538977) | |||
133819 | 133819 | 120070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 26th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5987678.122930001 | 2115272.13774 | 37.7874221569894 | -122.48645366177401 | (37.7874221569894, -122.486453661774) | |||
28909 | 28909 | 176778 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6008224.08958 | 2093491.7864599999 | 37.728794492350396 | -122.41382733896499 | (37.7287944923504, -122.413827338965) | |||
33950 | 33950 | 176781 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008506.492819999 | 2093591.6358299998 | 37.7290845129336 | -122.41285810544399 | (37.7290845129336, -122.412858105444) | |||
71131 | 71131 | 176782 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008503.6919 | 2093600.7846099997 | 37.7291094763057 | -122.412868435047 | (37.7291094763057, -122.412868435047) | |||
129996 | 129996 | 176779 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008512.5516 | 2093571.34607 | 37.729029141679895 | -122.412835725785 | (37.7290291416799, -122.412835725785) | |||
147527 | 147527 | 176780 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008510.60068 | 2093581.4689 | 37.729056827298 | -122.412843185683 | (37.729056827298, -122.412843185683) | |||
171560 | 171560 | 219327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995301.64396 | 2090617.7903200001 | 37.720169000171296 | -122.458292861552 | (37.7201690001713, -122.458292861552) | |||
172065 | 172065 | 219328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995301.79244 | 2090610.0663299998 | 37.720147800462996 | -122.458291789543 | (37.720147800463, -122.458291789543) | |||
187057 | 187057 | 219326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995302.40607 | 2090624.5686700002 | 37.7201876557032 | -122.45829071756701 | (37.7201876557032, -122.458290717567) | |||
61159 | 61159 | 129163 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5996819.747219999 | 2113790.05212 | 37.783881366273704 | -122.45471857981701 | (37.7838813662737, -122.454718579817) | |||
41916 | 41916 | 176824 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008431.82226 | 2094483.21435 | 37.7315284044084 | -122.413179268628 | (37.7315284044084, -122.413179268628) | |||
42361 | 42361 | 176822 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008425.8217 | 2094514.9756099998 | 37.7316152771105 | -122.413202258904 | (37.7316152771105, -122.413202258904) | |||
58648 | 58648 | 176823 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008429.95223 | 2094500.1756400003 | 37.731574871472795 | -122.41318693263901 | (37.7315748714728, -122.413186932639) | |||
136126 | 136126 | 176806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008418.41029 | 2094548.1649200001 | 37.7317059917167 | -122.413230227789 | (37.7317059917167, -122.413230227789) | |||
24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
173591 | 173591 | 219330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | |||
188529 | 188529 | 219331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | |||
48158 | 48158 | 176798 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6008483.53327 | 2094510.3324 | 37.7316057676803 | -122.41300240975401 | (37.7316057676803, -122.413002409754) | |||
56312 | 56312 | 176800 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6008479.14615 | 2094525.5991 | 37.731647440478 | -122.413018655999 | (37.731647440478, -122.413018655999) | |||
77062 | 77062 | 176799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008480.51195 | 2094517.85625 | 37.7316262569493 | -122.413013386875 | (37.7316262569493, -122.413013386875) | |||
168649 | 168649 | 176802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008473.4395 | 2094550.88435 | 37.731716547980206 | -122.41304017228201 | (37.7317165479802, -122.413040172282) | |||
174736 | 174736 | 176801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008476.7673 | 2094533.48941 | 37.7316689720313 | -122.413027437877 | (37.7316689720313, -122.413027437877) | |||
186709 | 186709 | 176797 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008485.14768 | 2094502.3312900001 | 37.731583888980104 | -122.412996262887 | (37.7315838889801, -122.412996262887) | |||
187619 | 187619 | 176803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008471.3844800005 | 2094562.18285 | 37.731747455866 | -122.41304807552099 | (37.731747455866, -122.413048075521) | |||
189128 | 189128 | 176796 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008486.43054 | 2094496.74036 | 37.7315686095034 | -122.41299143261001 | (37.7315686095034, -122.41299143261) | |||
132381 | 132381 | 226897 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | |||
26630 | 26630 | 206935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000034.8522 | 2094044.21533 | 37.7298480292542 | -122.442177629193 | (37.7298480292542, -122.442177629193) | |||
38096 | 38096 | 206933 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6000003.13616 | 2094038.3079799998 | 37.7298300014536 | -122.44228685095301 | (37.7298300014536, -122.442286850953) | |||
147711 | 147711 | 206936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6000038.50963 | 2094035.1117 | 37.7298232412405 | -122.44216433183998 | (37.7298232412405, -122.44216433184) | |||
170335 | 170335 | 206934 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 6000030.26557 | 2094035.00933 | 37.7298224903164 | -122.442192825064 | (37.7298224903164, -122.442192825064) | |||
35782 | 35782 | 190765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.751496295539106 | -122.39007361861601 | (37.7514962955391, -122.390073618616) | |||
25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
175494 | 175494 | 176807 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 106 Gaven St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6009983.095919999 | 2095237.75517 | 37.7336871802039 | -122.407869378985 | (37.7336871802039, -122.407869378985) | |||
181075 | 181075 | 176777 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 107 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | |||
63947 | 63947 | 129335 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1074 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007834.34596 | 2119269.05545 | 37.799550985448604 | -122.41700038098101 | (37.7995509854486, -122.417000380981) | |||
168244 | 168244 | 129334 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1074 Union St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007844.96731 | 2119270.12506 | 37.799554519795606 | -122.416963703016 | (37.7995545197956, -122.416963703016) | |||
34986 | 34986 | 129263 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 6009008.56152 | 2117982.3464099998 | 37.796083982049 | -122.41284613813299 | (37.796083982049, -122.412846138133) | |||
35741 | 35741 | 129306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006156.05151 | 2120698.06699 | 37.8033801368411 | -122.42290950959101 | (37.8033801368411, -122.422909509591) | |||
52974 | 52974 | 129305 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006148.36265 | 2120696.43143 | 37.8033752121629 | -122.422936000907 | (37.8033752121629, -122.422936000907) | |||
108014 | 108014 | 113985 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 109 MADRONE AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5992778.0 | 2098364.0 | 37.74129282931111 | -122.46757920887899 | (37.7412928293111, -122.467579208879) | ||||
32089 | 32089 | 219321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.45909980971201 | (37.7216008413857, -122.459099809712) | |||
32651 | 32651 | 219322 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.87033 | 2091157.1990200002 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | |||
37643 | 37643 | 219320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5995079.65544 | 2091128.71847 | 37.7215591281313 | -122.459097172915 | (37.7215591281313, -122.459097172915) | |||
42679 | 42679 | 219324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995080.31545 | 2091178.4589099998 | 37.721695741442396 | -122.459098491311 | (37.7216957414424, -122.459098491311) | |||
134794 | 134794 | 219325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5995080.6810800005 | 2091195.9220900002 | 37.721743712182395 | -122.459098491296 | (37.7217437121824, -122.459098491296) | |||
147745 | 147745 | 219323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.72755 | 2091168.59616 | 37.7216686268896 | -122.459099809715 | (37.7216686268896, -122.459099809715) | |||
134612 | 134612 | 190772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | |||
48931 | 48931 | 129211 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000911.6199199995 | 2117290.07743 | 37.793725383184295 | -122.440813405326 | (37.7937253831843, -122.440813405326) | |||
60802 | 60802 | 129210 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000912.13744 | 2117299.9912900003 | 37.793752633522104 | -122.440812326154 | (37.7937526335221, -122.440812326154) | |||
133508 | 133508 | 129212 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000913.33947 | 2117282.2310599997 | 37.793703937035104 | -122.440806892437 | (37.7937039370351, -122.440806892437) | |||
152129 | 152129 | 129208 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000907.377069999 | 2117323.47168 | 37.7938168334195 | -122.44083048255399 | (37.7938168334195, -122.440830482554) | |||
175786 | 175786 | 129207 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000907.81607 | 2117333.5843599997 | 37.7938446251929 | -122.440829689342 | (37.7938446251929, -122.440829689342) | |||
176585 | 176585 | 129209 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000909.22566 | 2117310.8698 | 37.793782337235 | -122.440823181871 | (37.793782337235, -122.440823181871) | |||
187969 | 187969 | 129213 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000915.059280001 | 2117274.38469 | 37.793682490900295 | -122.440800378652 | (37.7936824909003, -122.440800378652) | |||
175383 | 175383 | 226978 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Thor Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 2ft | 6002261.072480001 | 2096075.82305 | 37.735552982986604 | -122.43462655258499 | (37.7355529829866, -122.434626552585) | |||
77087 | 77087 | 219288 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6000650.92821 | 2094383.0916900001 | 37.730813597150394 | -122.44007207888399 | (37.7308135971504, -122.440072078884) | |||
130697 | 130697 | 176632 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.713012287961604 | -122.43857351247499 | (37.7130122879616, -122.438573512475) | |||
148159 | 148159 | 176631 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000945.59643 | 2087907.6965599998 | 37.7130504003174 | -122.438589570763 | (37.7130504003174, -122.438589570763) | |||
183779 | 183779 | 176633 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000954.59421 | 2087879.4605599998 | 37.7129733823892 | -122.43855644963399 | (37.7129733823892, -122.438556449634) | |||
41521 | 41521 | 176750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007642.23896 | 2092919.3671799998 | 37.7271900586719 | -122.415798324654 | (37.7271900586719, -122.415798324654) | |||
47542 | 47542 | 176748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007695.086519999 | 2092935.46015 | 37.7272372173175 | -122.4156167695 | (37.7272372173175, -122.4156167695) | |||
157465 | 157465 | 176747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007704.15527 | 2092938.2985599998 | 37.727245520749996 | -122.415585619676 | (37.72724552075, -122.415585619676) | |||
181535 | 181535 | 176749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007680.78535 | 2092930.6972 | 37.7272233353724 | -122.415665871602 | (37.7272233353724, -122.415665871602) | |||
35777 | 35777 | 226865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004824.42349 | 2096711.0552700001 | 37.7374423749661 | -122.425809268297 | (37.7374423749661, -122.425809268297) |
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");