Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
85803 | 85803 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 174 STILLINGS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | |||||
86324 | 86324 | 121732 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
88432 | 88432 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2398 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
90158 | 90158 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
91961 | 91961 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
104252 | 104252 | 121734 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
109308 | 109308 | 103590 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
116755 | 116755 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
31573 | 31573 | 129332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007563.684280001 | 2119863.77685 | 37.8011687120311 | -122.417979152724 | (37.8011687120311, -122.417979152724) | ||||
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) | ||||
74501 | 74501 | 129333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007566.1830400005 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | ||||
170842 | 170842 | 129329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007555.7240699995 | 2119861.47467 | 37.8011619428155 | -122.41800653528601 | (37.8011619428155, -122.418006535286) | ||||
171563 | 171563 | 129328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007553.95221 | 2119861.40094 | 37.8011616406485 | -122.418012661478 | (37.8011616406485, -122.418012661478) | ||||
60902 | 60902 | 129330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007557.40785 | 2119862.6523599997 | 37.8011652712212 | -122.41800079219601 | (37.8011652712212, -122.418000792196) | ||||
169303 | 169303 | 129327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007552.17158 | 2119860.88653 | 37.801160127991295 | -122.41801878675899 | (37.8011601279913, -122.418018786759) | ||||
179802 | 179802 | 129331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.41798625015899 | (37.8011675015458, -122.417986250159) | ||||
64677 | 64677 | 247136 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003181.95614 | 2100090.46758 | 37.7466285054035 | -122.43172925621501 | (37.7466285054035, -122.431729256215) | ||||
175549 | 175549 | 247137 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003179.078430001 | 2100075.39017 | 37.7465869432333 | -122.431738130709 | (37.7465869432333, -122.431738130709) | ||||
52800 | 52800 | 129325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007543.5223900005 | 2119858.96336 | 37.801154360655 | -122.41804858037399 | (37.801154360655, -122.418048580374) | ||||
65360 | 65360 | 129326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007546.3898 | 2119859.39883 | 37.801155717731 | -122.41803868875401 | (37.801155717731, -122.418038688754) | ||||
150004 | 150004 | 247945 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010344.08085 | 2098894.91993 | 37.743749172086794 | -122.406879009554 | (37.7437491720868, -122.406879009554) | ||||
57173 | 57173 | 247138 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6003171.95048 | 2100074.35789 | 37.7465837047841 | -122.43176270469499 | (37.7465837047841, -122.431762704695) | ||||
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) | |||
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) | ||||
170127 | 170127 | 201932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Boutwell St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 9ft | 6010626.2158 | 2095614.29555 | 37.734757064092605 | -122.405672426066 | (37.7347570640926, -122.405672426066) | |||
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) | ||||
93035 | 93035 | 103565 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
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) | |||
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) | |||
84454 | 84454 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
83945 | 83945 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
94696 | 94696 | 107828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | Permit Number 774138 | 6005744.5 | 2119283.2 | 37.799472043237294 | -122.424233014169 | (37.7994720432373, -122.424233014169) |
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");