Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
26362 | 26362 | 196123 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6011242.42693 | 2104654.95461 | 37.7596151915071 | -122.404178032517 | (37.7596151915071, -122.404178032517) | |||
149621 | 149621 | 196124 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6011192.22551 | 2104649.1364599997 | 37.7595964109771 | -122.40435124553998 | (37.7595964109771, -122.40435124554) | |||
49284 | 49284 | 196125 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6011177.05787 | 2104649.1602 | 37.7595956285643 | -122.40440370476101 | (37.7595956285643, -122.404403704761) | |||
34244 | 34244 | 196191 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 Armstrong Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013892.03543 | 2092881.8479400002 | 37.727436404540796 | -122.39419004313 | (37.7274364045408, -122.39419004313) | ||||
187449 | 187449 | 196192 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011951.07495 | 2096769.0187900001 | 37.7380016885201 | -122.40117301982 | (37.7380016885201, -122.40117301982) | ||||
155365 | 155365 | 196193 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6011935.59565 | 2096781.31623 | 37.73803459111979 | -122.401227403639 | (37.7380345911198, -122.401227403639) | ||||
131205 | 131205 | 196298 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6011933.586759999 | 2096785.03715 | 37.738044695904605 | -122.40123461080799 | (37.7380446959046, -122.401234610808) | ||||
25566 | 25566 | 214228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999467.5472800005 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | ||||
28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
70823 | 70823 | 237870 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.78033 | 2105726.70817 | 37.7619268889309 | -122.442923144685 | (37.7619268889309, -122.442923144685) | |||
25273 | 25273 | 237871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.7105 | 2105723.34521 | 37.761917651093704 | -122.44292314469 | (37.7619176510937, -122.44292314469) | |||
173692 | 173692 | 237872 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000053.4214699995 | 2105717.34957 | 37.7619007159651 | -122.44295138252 | (37.7619007159651, -122.44295138252) | |||
154255 | 154255 | 247009 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Valley St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100676996 | -122.431331435716 | (37.744170100677, -122.431331435716) | |||
156569 | 156569 | 247882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 387 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009927.8842 | 2098400.72535 | 37.7423689240761 | -122.40828327575701 | (37.7423689240761, -122.408283275757) | ||||
164280 | 164280 | 247909 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 582 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009857.303669999 | 2098747.94229 | 37.743318353655 | -122.408551810625 | (37.743318353655, -122.408551810625) | ||||
30408 | 30408 | 248049 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010499.7614 | 2099438.0486 | 37.7452491953942 | -122.40637896223 | (37.7452491953942, -122.40637896223) | ||||
23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
180928 | 180928 | 248055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010658.86611 | 2099354.83953 | 37.745029620524605 | -122.405822941986 | (37.7450296205246, -122.405822941986) | ||||
156969 | 156969 | 248056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010671.1144 | 2099351.76088 | 37.7450218521921 | -122.405780372559 | (37.7450218521921, -122.405780372559) | ||||
32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
32768 | 32768 | 248178 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 218 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6007415.21428 | 2098671.9184 | 37.7429725382626 | -122.416990561277 | (37.7429725382626, -122.416990561277) | ||||
71454 | 71454 | 249847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 289 Greenwich St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831002 | (37.8028363185975, -122.40464825831) | |||
27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) |
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");