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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157002 | 157002 | 176841 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999258.34845 | 2089733.03463 | 37.7179662385418 | -122.444552352003 | (37.7179662385418, -122.444552352003) | |||
56652 | 56652 | 176842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999251.78306 | 2089738.34145 | 37.717980435227396 | -122.44457542680901 | (37.7179804352274, -122.444575426809) | |||
40241 | 40241 | 176843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999252.47179 | 2089747.68303 | 37.718006124373105 | -122.444573717211 | (37.7180061243731, -122.444573717211) | |||
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) | |||
34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
48635 | 48635 | 176617 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1367 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5999325.43091 | 2089826.3295 | 37.718226232531 | -122.444327178876 | (37.718226232531, -122.444327178876) | |||
161516 | 161516 | 219361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 606 Shields St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 5992405.16075 | 2089868.2609299999 | 37.717944105311 | -122.468250447523 | (37.717944105311, -122.468250447523) | |||
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) | |||
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) | |||
53740 | 53740 | 176618 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Seneca Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000040.875469999 | 2090086.0119900003 | 37.7189800550644 | -122.441872826471 | (37.7189800550644, -122.441872826471) | |||
175259 | 175259 | 218146 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5994143.80732 | 2090112.0989599999 | 37.7187138908262 | -122.46225842838601 | (37.7187138908262, -122.462258428386) | ||||
29711 | 29711 | 218145 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5994144.20993 | 2090116.67038 | 37.7187264660332 | -122.462257368104 | (37.7187264660332, -122.462257368104) | ||||
101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
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) | |||
65469 | 65469 | 219343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991924.98252 | 2090428.4017299998 | 37.7194543701096 | -122.469950959395 | (37.7194543701096, -122.469950959395) | |||
166707 | 166707 | 219342 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5991925.44739 | 2090450.4823200002 | 37.719515024881794 | -122.469950959366 | (37.7195150248818, -122.469950959366) | |||
40817 | 40817 | 176682 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1998 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000630.5225599995 | 2090456.6587099999 | 37.7200313490478 | -122.43986121213301 | (37.7200313490478, -122.439861212133) | |||
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) | |||
161077 | 161077 | 176681 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1998 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000637.29788 | 2090464.1729400002 | 37.7200523670946 | -122.439838330692 | (37.7200523670946, -122.439838330692) | |||
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) | |||
184130 | 184130 | 219353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993539.38524 | 2090524.66713 | 37.7198118820929 | -122.46437759357201 | (37.7198118820929, -122.464377593572) | |||
32303 | 32303 | 219349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992970.2206 | 2090529.11347 | 37.719791266033 | -122.466345302087 | (37.719791266033, -122.466345302087) | |||
67231 | 67231 | 219354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5993538.524669999 | 2090540.93075 | 37.7198564884635 | -122.46438174842699 | (37.7198564884635, -122.464381748427) | |||
44537 | 44537 | 219348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5992970.49595 | 2090542.2168 | 37.7198272604875 | -122.466345302117 | (37.7198272604875, -122.466345302117) | |||
187898 | 187898 | 219347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992971.18683 | 2090558.0944400001 | 37.7198708965006 | -122.46634406733999 | (37.7198708965006, -122.46634406734) | |||
32893 | 32893 | 176636 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009567.85058 | 2090563.67809 | 37.7208298948579 | -122.40897533376301 | (37.7208298948579, -122.408975333763) | |||
57377 | 57377 | 219355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993537.41459 | 2090564.39449 | 37.719920850243 | -122.464387288237 | (37.719920850243, -122.464387288237) | |||
153257 | 153257 | 176637 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6009580.5453 | 2090567.0766099999 | 37.7208399376015 | -122.40893169145001 | (37.7208399376015, -122.40893169145) | |||
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) | |||
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) | |||
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) | |||
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) | |||
185547 | 185547 | 176629 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1111 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 1ft | 6000425.60449 | 2090663.4815 | 37.7205875707281 | -122.440584368684 | (37.7205875707281, -122.440584368684) | |||
59824 | 59824 | 176593 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 556 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5999236.66404 | 2090814.9322900001 | 37.7209356443574 | -122.44470502632099 | (37.7209356443574, -122.444705026321) | |||
49652 | 49652 | 202033 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1319 Fitzgerald Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 7ft | 6014010.86588 | 2090963.17222 | 37.722174710472004 | -122.39364501082198 | (37.722174710472, -122.393645010822) | |||
176479 | 176479 | 202032 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1319 Fitzgerald Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 7ft | 6014005.50578 | 2090967.22182 | 37.7221855320171 | -122.393663822829 | (37.7221855320171, -122.393663822829) | |||
46609 | 46609 | 202031 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1319 Fitzgerald Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 7ft | 6013998.1976 | 2090972.78897 | 37.7222004121965 | -122.3936894751 | (37.7222004121965, -122.3936894751) | |||
155443 | 155443 | 219333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 159 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5994132.08627 | 2090976.61214 | 37.721086961572496 | -122.46236161210699 | (37.7210869615725, -122.462361612107) | |||
75263 | 75263 | 202046 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Exeter St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012581.44921 | 2090990.21223 | 37.722169424252 | -122.398588087695 | (37.722169424252, -122.398588087695) | |||
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) | |||
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) | |||
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) | |||
111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
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) | |||
34914 | 34914 | 176818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 695 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009866.42198 | 2091203.0617799999 | 37.722602230178 | -122.407988325128 | (37.722602230178, -122.407988325128) | |||
60723 | 60723 | 176819 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 691 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6009861.20828 | 2091223.43353 | 37.7226578748526 | -122.40800778375099 | (37.7226578748526, -122.408007783751) | |||
30656 | 30656 | 176851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6004177.9913099995 | 2091279.54891 | 37.7224921207944 | -122.427657419158 | (37.7224921207944, -122.427657419158) | |||
73755 | 73755 | 187586 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6010130.12486 | 2091286.0001700001 | 37.7228447224995 | -122.407082601693 | (37.7228447224995, -122.407082601693) | |||
26978 | 26978 | 176852 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6004182.999 | 2091286.4234200001 | 37.7225112799465 | -122.427640598252 | (37.7225112799465, -122.427640598252) | |||
73569 | 73569 | 187587 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6010130.636940001 | 2091289.3744 | 37.7228540160906 | -122.40708106925501 | (37.7228540160906, -122.407081069255) | |||
157613 | 157613 | 187588 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6010130.07309 | 2091290.7104099998 | 37.7228576529424 | -122.407083112501 | (37.7228576529424, -122.407083112501) | |||
58448 | 58448 | 187589 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6010129.52422 | 2091292.7817400002 | 37.7228633096683 | -122.40708515576901 | (37.7228633096683, -122.407085155769) | |||
176573 | 176573 | 176820 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 667 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009838.84445 | 2091294.60305 | 37.722852039372505 | -122.408090107681 | (37.7228520393725, -122.408090107681) | |||
12269 | 12269 | 106828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | |||
135078 | 135078 | 176697 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004613.59426 | 2091464.71146 | 37.7230251669629 | -122.426164813475 | (37.7230251669629, -122.426164813475) | ||||
27332 | 27332 | 176698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004617.240230001 | 2091470.03605 | 37.72303999319411 | -122.42615258897 | (37.7230399931941, -122.42615258897) | ||||
132206 | 132206 | 176602 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 279 Moscow St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6004631.85763 | 2091492.97725 | 37.7231038108784 | -122.426103691929 | (37.7231038108784, -122.426103691929) | |||
116931 | 116931 | 176821 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 629 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6009772.50024 | 2091512.8387900002 | 37.723447554245894 | -122.40833483209299 | (37.7234475542459, -122.408334832093) | |||
152136 | 152136 | 176733 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 492 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6007824.003719999 | 2091540.42903 | 37.7234140059293 | -122.41507240089199 | (37.7234140059293, -122.415072400892) | |||
175306 | 175306 | 176699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6004681.99685 | 2091569.4178799998 | 37.723316533811 | -122.425935809202 | (37.723316533811, -122.425935809202) | |||
133424 | 133424 | 176700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Moscow St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6004684.69555 | 2091574.5274599998 | 37.7233307161129 | -122.42592684384199 | (37.7233307161129, -122.425926843842) | |||
32036 | 32036 | 176732 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 462 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007785.763719999 | 2091661.92409 | 37.7237454564679 | -122.415213186138 | (37.7237454564679, -122.415213186138) | |||
168191 | 168191 | 176606 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 481 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008146.1798 | 2091705.5456599998 | 37.723885480908606 | -122.413970368936 | (37.7238854809086, -122.413970368936) | |||
10717 | 10717 | 25296 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 158 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000552.574130001 | 2091731.5353 | 37.723527432941204 | -122.44022202823 | (37.7235274329412, -122.44022202823) | |||
134576 | 134576 | 176601 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 226 Moscow St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6004750.46205 | 2091804.94471 | 37.7239671078745 | -122.425715893496 | (37.7239671078745, -122.425715893496) | |||
170637 | 170637 | 176600 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 226 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004751.9353 | 2091806.8776 | 37.7239724984169 | -122.42571093821002 | (37.7239724984169, -122.42571093821) | |||
29956 | 29956 | 176692 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004473.28311 | 2091848.82103 | 37.72407191576529 | -122.426677180615 | (37.7240719157653, -122.426677180615) | ||||
32430 | 32430 | 176689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6004476.46951 | 2091852.67463 | 37.72408267705 | -122.426666440004 | (37.72408267705, -122.426666440004) | ||||
174640 | 174640 | 176690 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004472.37947 | 2091855.23398 | 37.724089473225206 | -122.426680760821 | (37.7240894732252, -122.426680760821) | ||||
133626 | 133626 | 176731 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 421 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 5ft | 6007786.78425 | 2091855.6543599998 | 37.724277455832706 | -122.415223365581 | (37.7242774558327, -122.415223365581) | |||
54077 | 54077 | 176691 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004467.85023 | 2091856.56465 | 37.7240928708828 | -122.426696512434 | (37.7240928708828, -122.426696512434) | ||||
179518 | 179518 | 176686 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004486.61146 | 2091862.36635 | 37.7241098617621 | -122.426632070637 | (37.7241098617621, -122.426632070637) | ||||
50439 | 50439 | 176687 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004483.134190001 | 2091864.5004 | 37.7241155248047 | -122.426644242931 | (37.7241155248047, -122.426644242931) | ||||
151959 | 151959 | 176688 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004477.9919300005 | 2091866.25637 | 37.7241200555896 | -122.426662143938 | (37.7241200555896, -122.426662143938) | ||||
38573 | 38573 | 176693 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 231 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6004560.89466 | 2091885.9682599998 | 37.7241788667532 | -122.426376964428 | (37.7241788667532, -122.426376964428) | |||
73963 | 73963 | 176694 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 231 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6004563.41543 | 2091888.93094 | 37.7241871441138 | -122.42636846133999 | (37.7241871441138, -122.42636846134) | |||
131766 | 131766 | 176734 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.41525670432699 | (37.7245056282085, -122.415256704327) | |||
40509 | 40509 | 176735 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.41523534004101 | (37.7245113883837, -122.415235340041) | |||
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) | |||
40707 | 40707 | 219318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5994210.25958 | 2091948.5213400002 | 37.7237600911452 | -122.46216184119 | (37.7237600911452, -122.46216184119) | |||
138109 | 138109 | 176675 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 202 Otsego Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000429.09112 | 2091952.21155 | 37.7241263283396 | -122.44066470691001 | (37.7241263283396, -122.44066470691) | |||
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) | |||
66460 | 66460 | 176844 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 838 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004810.4561 | 2091959.39958 | 37.7243945970256 | -122.425519490549 | (37.7243945970256, -122.425519490549) | |||
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) | |||
40364 | 40364 | 219319 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994210.91317 | 2091964.42992 | 37.7238038098934 | -122.462160735039 | (37.7238038098934, -122.462160735039) | |||
148789 | 148789 | 176736 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1201 Bacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007970.1933699995 | 2091996.7692200001 | 37.724675233151004 | -122.41459932600701 | (37.724675233151, -122.414599326007) | |||
37694 | 37694 | 176737 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1201 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007977.54478 | 2091998.9809400002 | 37.7246817190783 | -122.414574069464 | (37.7246817190783, -122.414574069464) | |||
158247 | 158247 | 176676 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5999923.13264 | 2092015.78997 | 37.724272074293104 | -122.442418285994 | (37.7242720742931, -122.442418285994) | |||
173682 | 173682 | 176603 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1736 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6006266.94318 | 2092016.7165400002 | 37.724634164707105 | -122.420488674034 | (37.7246341647071, -122.420488674034) | |||
183234 | 183234 | 43136 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1730 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42952 | 6006290.853069999 | 2092023.3911599999 | 37.7246538391803 | -122.42040649398199 | (37.7246538391803, -122.420406493982) | |
151640 | 151640 | 176696 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 804 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6004702.85264 | 2092026.4277400002 | 37.7245725611527 | -122.425896230029 | (37.7245725611527, -122.425896230029) | |||
136155 | 136155 | 176695 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 804 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6004692.95687 | 2092032.8489 | 37.72458963299471 | -122.425930895307 | (37.7245896329947, -122.425930895307) | |||
161682 | 161682 | 176703 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6004753.02081 | 2092064.15662 | 37.724678991421705 | -122.425725489235 | (37.7246789914217, -122.425725489235) | |||
76264 | 76264 | 44486 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 390 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 16 | Permit Number 43792 | 6006402.34332 | 2092081.2102700002 | 37.724818880074395 | -122.420025186814 | (37.7248188800744, -122.420025186814) | |
39860 | 39860 | 42981 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42865 | 6007925.78486 | 2092082.5600700001 | 37.7249083014575 | -122.414758909799 | (37.7249083014575, -122.414758909799) | |
181861 | 181861 | 176738 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007923.10392 | 2092090.50279 | 37.7249299598378 | -122.414768739387 | (37.7249299598378, -122.414768739387) |
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");