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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
153552 | 153552 | 219315 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 5995096.96866 | 2091948.28525 | 37.7238104576833 | -122.459096640518 | (37.7238104576833, -122.459096640518) | |||
35316 | 35316 | 219317 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5995097.23073 | 2091960.8022599998 | 37.7238448414569 | -122.45909664051001 | (37.7238448414569, -122.45909664051) | |||
147427 | 147427 | 219316 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 1ft | 5995097.3414 | 2091954.20903 | 37.7238267443906 | -122.45909578075899 | (37.7238267443906, -122.459095780759) | |||
147731 | 147731 | 219334 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 800 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5995082.86973 | 2089689.0619599998 | 37.717606358621104 | -122.45898187623001 | (37.7176063586211, -122.45898187623) | |||
162915 | 162915 | 219279 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 59 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 5995277.33246 | 2097610.05281 | 37.7393666624493 | -122.458882882444 | (37.7393666624493, -122.458882882444) | |||
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) | |||
39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) | |||
65273 | 65273 | 219243 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995302.33675 | 2090036.07608 | 37.718571790736796 | -122.45824838556601 | (37.7185717907368, -122.458248385566) | |||
53868 | 53868 | 219242 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995302.90929 | 2090039.9744900002 | 37.718582527746705 | -122.45824668854799 | (37.7185825277467, -122.458246688548) | |||
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) | |||
90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
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) | |||
80360 | 80360 | 110171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
94629 | 94629 | 110173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
120525 | 120525 | 110172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
122726 | 122726 | 110174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
127293 | 127293 | 110175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
159174 | 159174 | 124497 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2700 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5996600.75625 | 2111319.20262 | 37.7770845024867 | -122.45529757783001 | (37.7770845024867, -122.45529757783) | |||
145739 | 145739 | 176592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2249 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5996118.04902 | 2086754.98706 | 37.70960952494271 | -122.455191839948 | (37.7096095249427, -122.455191839948) | |||
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) | |||
92201 | 92201 | 176628 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3067 Alemany Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5996456.31752 | 2087068.2457400002 | 37.7104890628041 | -122.454045341035 | (37.7104890628041, -122.454045341035) | |||
28089 | 28089 | 94904 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3701 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5997050.00292 | 2115323.90542 | 37.788106124051 | -122.454032799976 | (37.788106124051, -122.454032799976) | |||
146538 | 146538 | 129154 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3701 Clay St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5997094.15326 | 2115332.00999 | 37.7881309084546 | -122.45388063381 | (37.7881309084546, -122.45388063381) | |||
166898 | 166898 | 129156 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 341 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 1ft | 5997126.0863 | 2115169.43249 | 37.7876863448031 | -122.453758406952 | (37.7876863448031, -122.453758406952) | |||
152524 | 152524 | 219341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 176 Margaret Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 10ft | 5996604.57651 | 2089160.1054 | 37.7162413244539 | -122.45368388192101 | (37.7162413244539, -122.453683881921) | |||
9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
24727 | 24727 | 129157 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5997198.13027 | 2114418.3589 | 37.785628226512706 | -122.45345490104499 | (37.7856282265127, -122.453454901045) | |||
154596 | 154596 | 206928 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996825.61506 | 2095044.14156 | 37.7324101663 | -122.453344433724 | (37.7324101663, -122.453344433724) | |||
162896 | 162896 | 206930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996825.98874 | 2095054.21648 | 37.73243785103 | -122.45334386894699 | (37.73243785103, -122.453343868947) | |||
160615 | 160615 | 206929 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5996825.89712 | 2095049.8275 | 37.7324257946933 | -122.453343868941 | (37.7324257946933, -122.453343868941) | |||
134411 | 134411 | 206931 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996826.10073 | 2095059.5810599998 | 37.7324525872975 | -122.453343868939 | (37.7324525872975, -122.453343868939) | |||
41466 | 41466 | 206932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996826.20254 | 2095064.45784 | 37.732465983599894 | -122.453343868921 | (37.7324659835999, -122.453343868921) | |||
174519 | 174519 | 219302 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 594 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5996831.65871 | 2094146.3639099998 | 37.7299454303374 | -122.453258748999 | (37.7299454303374, -122.453258748999) | |||
53053 | 53053 | 219245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 16 Lobos St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 5996729.7413 | 2088712.5742099998 | 37.7150196826824 | -122.45321896478501 | (37.7150196826824, -122.453218964785) | |||
173921 | 173921 | 219301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 594 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 4ft | 5996849.44073 | 2094145.99272 | 37.729945430323895 | -122.453197247977 | (37.7299454303239, -122.453197247977) | |||
159319 | 159319 | 250161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997228.87455 | 2110733.66678 | 37.7755127924135 | -122.45308245310301 | (37.7755127924135, -122.453082453103) | |||
36939 | 36939 | 250162 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5997228.928169999 | 2110728.99929 | 37.7754999797735 | -122.45308193061301 | (37.7754999797735, -122.453081930613) | |||
172423 | 172423 | 250164 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5997230.43639 | 2110716.53529 | 37.7754658433095 | -122.453075813411 | (37.7754658433095, -122.453075813411) | |||
175121 | 175121 | 250163 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5997230.95701 | 2110719.49417 | 37.775473997461205 | -122.453074226111 | (37.7754739974612, -122.453074226111) | |||
171741 | 171741 | 250165 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5997232.24252 | 2110715.01845 | 37.7754617819717 | -122.453069456091 | (37.7754617819717, -122.453069456091) | |||
173752 | 173752 | 250166 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997232.8241 | 2110704.1079599997 | 37.7754318579352 | -122.453066656515 | (37.7754318579352, -122.453066656515) | |||
55387 | 55387 | 250167 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5997232.75579 | 2110698.69263 | 37.775416984933 | -122.453066501815 | (37.775416984933, -122.453066501815) | |||
166248 | 166248 | 250168 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 7ft | 5997236.19535 | 2110687.93342 | 37.775387640062796 | -122.45305382679399 | (37.7753876400628, -122.453053826794) | |||
39084 | 39084 | 250169 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 5997237.65706 | 2110666.34039 | 37.7753284349893 | -122.453047211372 | (37.7753284349893, -122.453047211372) | |||
68885 | 68885 | 250171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5997238.11076 | 2110659.10553 | 37.7753085959468 | -122.45304511956002 | (37.7753085959468, -122.45304511956) | |||
42535 | 42535 | 250173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997239.18442 | 2110648.2538799997 | 37.7752788616692 | -122.453040622039 | (37.7752788616692, -122.453040622039) | |||
169522 | 169522 | 250170 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5997240.0055 | 2110662.97968 | 37.7753193419419 | -122.453038844971 | (37.7753193419419, -122.453038844971) | |||
36832 | 36832 | 250172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997240.90305 | 2110650.9273599996 | 37.775286300843796 | -122.45303486996401 | (37.7752863008438, -122.453034869964) | |||
55652 | 55652 | 250174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997242.00203 | 2110645.63605 | 37.7752718352644 | -122.45303068632299 | (37.7752718352644, -122.453030686323) | |||
155003 | 155003 | 250175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997242.30788 | 2110631.32988 | 37.7752325717698 | -122.453028595406 | (37.7752325717698, -122.453028595406) | |||
59420 | 59420 | 249634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 5997294.55506 | 2111271.9763700003 | 37.776994614336 | -122.452894113492 | (37.776994614336, -122.452894113492) | |||
107819 | 107819 | 114704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 524 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | |||||
177708 | 177708 | 176591 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 170 Lawrence Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.41137 | 2087266.2974900003 | 37.711053623008 | -122.45280815898501 | (37.711053623008, -122.452808158985) | |||
40551 | 40551 | 129159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5997408.66924 | 2114451.98586 | 37.785732623419 | -122.452728928703 | (37.785732623419, -122.452728928703) | |||
177565 | 177565 | 129160 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997418.31681 | 2114452.99804 | 37.7857359554012 | -122.45269562410401 | (37.7857359554012, -122.452695624104) | |||
34985 | 34985 | 129161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997429.44136 | 2114454.7075099996 | 37.7857412865759 | -122.452657259939 | (37.7857412865759, -122.452657259939) | |||
179462 | 179462 | 129162 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997439.9594 | 2114456.55083 | 37.7857469505036 | -122.452621003773 | (37.7857469505036, -122.452621003773) | |||
184432 | 184432 | 219244 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4 Farallones St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5996960.480830001 | 2088401.3270400001 | 37.7141782922784 | -122.452398988125 | (37.7141782922784, -122.452398988125) | |||
55719 | 55719 | 110572 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
78535 | 78535 | 110569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
107354 | 107354 | 110571 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
61449 | 61449 | 219253 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 449 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997174.7237 | 2095517.45722 | 37.7337297819926 | -122.452171628738 | (37.7337297819926, -122.452171628738) | ||||
171687 | 171687 | 219254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 449 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997174.97013 | 2095514.3444599998 | 37.7337212492173 | -122.452170552242 | (37.7337212492173, -122.452170552242) | ||||
47046 | 47046 | 206921 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 638 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5997199.5508 | 2095299.8270400001 | 37.7331336438848 | -122.452070097972 | (37.7331336438848, -122.452070097972) | |||
117763 | 117763 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x8 | 5997298.0 | 2095759.0 | 37.7344000615683 | -122.45176284684601 | (37.7344000615683, -122.451762846846) | ||||
43916 | 43916 | 249625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 5997639.79528 | 2111322.31201 | 37.777152600940106 | -122.451703458765 | (37.7771526009401, -122.451703458765) | |||
153125 | 153125 | 249624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 7ft | 5997651.05189 | 2111322.51448 | 37.777153801533295 | -122.451664533393 | (37.7771538015333, -122.451664533393) | |||
130965 | 130965 | 249623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | |||
186803 | 186803 | 226887 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1266 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997536.57649 | 2105194.59271 | 37.7603215415281 | -122.451618405363 | (37.7603215415281, -122.451618405363) | |||
187209 | 187209 | 206920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 411 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5997366.58572 | 2095512.9448099998 | 37.7337283808453 | -122.45150798300399 | (37.7337283808453, -122.451507983004) | ||||
136885 | 136885 | 219304 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 518 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5997397.71686 | 2094138.95075 | 37.72995750373521 | -122.45130129363501 | (37.7299575037352, -122.451301293635) | |||
161526 | 161526 | 219303 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 518 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5997404.84982 | 2094139.1246200001 | 37.729958389564295 | -122.451276646793 | (37.7299583895643, -122.451276646793) | |||
46315 | 46315 | 206948 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5997397.5658599995 | 2093594.47343 | 37.7284624896392 | -122.451262563442 | (37.7284624896392, -122.451262563442) | |||
167821 | 167821 | 219239 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 579 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997578.77584 | 2094371.8563299999 | 37.7306073727237 | -122.450692139651 | (37.7306073727237, -122.450692139651) | ||||
148022 | 148022 | 129158 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5998011.3909 | 2113983.2225200003 | 37.784480040475394 | -122.45060988493401 | (37.7844800404754, -122.450609884934) | |||
157403 | 157403 | 226885 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997889.74449 | 2105168.82757 | 37.760271015821296 | -122.450395110664 | (37.7602710158213, -122.450395110664) | |||
159101 | 159101 | 226886 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997890.66163 | 2105156.29016 | 37.760236643732796 | -122.450391034916 | (37.7602366437328, -122.450391034916) | |||
60078 | 60078 | 206943 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 359 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 5997695.93457 | 2093782.21524 | 37.728995063674105 | -122.45024461989401 | (37.7289950636741, -122.450244619894) | |||
53919 | 53919 | 218142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.717992043688895 | -122.449490525783 | (37.7179920436889, -122.449490525783) | |||
164120 | 164120 | 176827 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1791 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5997883.80423 | 2088433.1189700002 | 37.7143184408223 | -122.44920992919799 | (37.7143184408223, -122.449209929198) | |||
149561 | 149561 | 249609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2310 Golden Gate Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 5998473.33255 | 2111438.47015 | 37.7775192428532 | -122.448828371134 | (37.7775192428532, -122.448828371134) | |||
134298 | 134298 | 219306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 148 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5998127.52225 | 2094054.8497 | 37.729768343017504 | -122.44877222468 | (37.7297683430175, -122.44877222468) | |||
154574 | 154574 | 219240 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 148 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5998128.33094 | 2094040.49389 | 37.729728971597794 | -122.448768395353 | (37.7297289715978, -122.448768395353) | |||
151185 | 151185 | 219248 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 580 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998168.32252 | 2095019.32726 | 37.7324189032047 | -122.448700613456 | (37.7324189032047, -122.448700613456) | |||
73406 | 73406 | 219296 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 381 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998149.50301 | 2094066.8230299999 | 37.7298024758953 | -122.44869709712 | (37.7298024758953, -122.44869709712) | |||
177130 | 177130 | 219295 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 480 Hearst Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998167.2791 | 2094421.20794 | 37.730776549584704 | -122.44866115748998 | (37.7307765495847, -122.44866115749) | |||
158971 | 158971 | 219297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 381 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998167.92855 | 2094066.7216400001 | 37.7298032511049 | -122.44863339092899 | (37.7298032511049, -122.448633390929) | |||
71408 | 71408 | 219298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 381 Flood Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998181.253169999 | 2094066.7264900003 | 37.729804026324 | -122.448587326764 | (37.729804026324, -122.448587326764) | |||
77183 | 77183 | 219299 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 381 Flood Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998187.186480001 | 2094065.75594 | 37.7298017006839 | -122.44856674485901 | (37.7298017006839, -122.448566744859) | |||
66211 | 66211 | 219294 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 480 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5998210.07192 | 2094421.64133 | 37.7307801864365 | -122.44851324778799 | (37.7307801864365, -122.448513247788) | |||
24254 | 24254 | 219293 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 480 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998219.47976 | 2094421.4454299998 | 37.7307801864506 | -122.448480709434 | (37.7307801864506, -122.448480709434) | |||
72467 | 72467 | 206917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 578 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998254.61477 | 2095017.4166400002 | 37.7324185911375 | -122.448402144659 | (37.7324185911375, -122.448402144659) | |||
61343 | 61343 | 129164 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998679.83386 | 2113409.66692 | 37.7829434444333 | -122.448255995832 | (37.7829434444333, -122.448255995832) | |||
129500 | 129500 | 129165 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5998683.20091 | 2113396.5400099996 | 37.7829075938537 | -122.448243401733 | (37.7829075938537, -122.448243401733) | |||
69431 | 69431 | 219404 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 471 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998306.28146 | 2095220.78528 | 37.7329799470492 | -122.448238160486 | (37.7329799470492, -122.448238160486) |
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");