Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23581 | 23581 | 179576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001080.83583 | 2089635.4329400002 | 37.717802070884794 | -122.438245835497 | (37.7178020708848, -122.438245835497) | |||
23768 | 23768 | 215139 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993967.99913 | 2094114.77996 | 37.7296941579575 | -122.463156396067 | (37.7296941579575, -122.463156396067) | |||
32135 | 32135 | 215152 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994637.17315 | 2089906.08202 | 37.71817661334929 | -122.460538153038 | (37.7181766133493, -122.460538153038) | |||
32915 | 32915 | 197811 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Dore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008628.59591 | 2110107.11154 | 37.7744391520861 | -122.413603620921 | (37.7744391520861, -122.413603620921) | |||
34885 | 34885 | 136564 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 780 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007032.143730001 | 2121235.0354299997 | 37.80490391034729 | -122.41991587960699 | (37.8049039103473, -122.419915879607) | |||
36678 | 36678 | 245275 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 211 Montcalm St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6009973.05434 | 2099655.25827 | 37.7458161271257 | -122.408215551417 | (37.7458161271257, -122.408215551417) | |||
40288 | 40288 | 136534 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1690 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6002748.26643 | 2120983.44526 | 37.8039708358557 | -122.43472268470501 | (37.8039708358557, -122.434722684705) | |||
44372 | 44372 | 197808 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008660.65845 | 2110075.3171900003 | 37.7743536526336 | -122.413490461037 | (37.7743536526336, -122.413490461037) | |||
45663 | 45663 | 215160 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 125 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5992679.1263 | 2088076.57107 | 37.713040376475504 | -122.467173279126 | (37.7130403764755, -122.467173279126) | |||
48837 | 48837 | 225141 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Albion St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005929.72911 | 2106381.16026 | 37.7640566615994 | -122.422674693899 | (37.7640566615994, -122.422674693899) | |||
50766 | 50766 | 215186 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998652.24527 | 2093777.94068 | 37.7290380080928 | -122.44693828756901 | (37.7290380080928, -122.446938287569) | |||
54492 | 54492 | 215153 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994954.26021 | 2089609.71028 | 37.7173810838456 | -122.459420674348 | (37.7173810838456, -122.459420674348) | |||
57640 | 57640 | 215185 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5998634.76225 | 2093779.7026799999 | 37.7290418472936 | -122.44699885422399 | (37.7290418472936, -122.446998854224) | |||
57671 | 57671 | 245306 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002154.22585 | 2096093.8635099998 | 37.735596451704 | -122.434997251342 | (37.735596451704, -122.434997251342) | |||
70858 | 70858 | 197810 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Dore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008638.52776 | 2110098.76438 | 37.7744167904456 | -122.413568674158 | (37.7744167904456, -122.413568674158) | |||
73911 | 73911 | 136532 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3600 Webster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6002643.59456 | 2120992.69589 | 37.8039902926784 | -122.43508557013901 | (37.8039902926784, -122.435085570139) | |||
74706 | 74706 | 179575 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001094.37871 | 2089628.06075 | 37.717782598761396 | -122.438198496058 | (37.7177825987614, -122.438198496058) | |||
77139 | 77139 | 197809 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008647.67456 | 2110087.31944 | 37.77438587894 | -122.413536223923 | (37.77438587894, -122.413536223923) | |||
77256 | 77256 | 136533 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3600 Webster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6002642.76754 | 2121001.81484 | 37.804015283952296 | -122.435089084694 | (37.8040152839523, -122.435089084694) | |||
84097 | 84097 | 225144 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Albion St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6005929.784519999 | 2106396.8527599997 | 37.764099752624 | -122.42267561748899 | (37.764099752624, -122.422675617489) | |||
104435 | 104435 | 225143 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Albion St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005929.424459999 | 2106392.33827 | 37.764087336586705 | -122.422676541996 | (37.7640873365867, -122.422676541996) | |||
132137 | 132137 | 245303 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 377 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003856.34203 | 2096607.16628 | 37.7371023646765 | -122.42914897355499 | (37.7371023646765, -122.429148973555) | |||
132299 | 132299 | 197749 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 285 Clara St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6011375.02403 | 2111337.26592 | 37.7779707079309 | -122.40418974885401 | (37.7779707079309, -122.404189748854) | |||
133770 | 133770 | 245230 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 24 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005803.61111 | 2105914.49608 | 37.7627681957301 | -122.423077727748 | (37.7627681957301, -122.423077727748) | |||
137182 | 137182 | 197796 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1938 Quesada Ave | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013463.045530001 | 2095982.9565 | 37.7359275587079 | -122.395890286113 | (37.7359275587079, -122.395890286113) | |||
137987 | 137987 | 215137 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993934.51855 | 2094140.11477 | 37.7297617923721 | -122.463273978817 | (37.7297617923721, -122.463273978817) | |||
148506 | 148506 | 245272 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 59 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009614.820119999 | 2098366.49718 | 37.742257405448896 | -122.40936334625299 | (37.7422574054489, -122.409363346253) | |||
149002 | 149002 | 197795 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1938 Quesada Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6013476.07087 | 2095990.32103 | 37.735948504815 | -122.39584576789301 | (37.735948504815, -122.395845767893) | |||
149373 | 149373 | 245276 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 211 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6009977.14888 | 2099657.7632299997 | 37.74582323446911 | -122.40820156965599 | (37.7458232344691, -122.408201569656) | |||
151118 | 151118 | 215154 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994969.58923 | 2089610.2136799998 | 37.717383347428296 | -122.459367725845 | (37.7173833474283, -122.459367725845) | |||
153030 | 153030 | 245260 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 178 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6004796.85539 | 2098734.84829 | 37.742997693194496 | -122.426048612058 | (37.7429976931945, -122.426048612058) | |||
159680 | 159680 | 245274 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 211 Montcalm St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6009969.560380001 | 2099653.89134 | 37.745812178191294 | -122.40822753669701 | (37.7458121781913, -122.408227536697) | |||
160706 | 160706 | 197807 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 59 Grace St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008374.508780001 | 2110266.71352 | 37.7748631104905 | -122.414493855329 | (37.7748631104905, -122.414493855329) | |||
162934 | 162934 | 197797 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 315 Topeka Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013586.21958 | 2094425.5372900001 | 37.731658057859 | -122.395355352274 | (37.731658057859, -122.395355352274) | |||
167757 | 167757 | 215178 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000653.2921400005 | 2095587.48865 | 37.7341207262744 | -122.44015023985901 | (37.7341207262744, -122.440150239859) | |||
168511 | 168511 | 245305 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002140.10278 | 2096079.88738 | 37.7355572745451 | -122.43504508086399 | (37.7355572745451, -122.435045080864) | |||
169892 | 169892 | 218219 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 387 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991861.85445 | 2097038.30782 | 37.737599877716704 | -122.470650352243 | (37.7375998777167, -122.470650352243) | |||
171299 | 171299 | 215155 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994990.6689 | 2089608.53553 | 37.717379951595504 | -122.45929474225599 | (37.7173799515955, -122.459294742256) | |||
171721 | 171721 | 179574 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001107.65338 | 2089620.96663 | 37.7177638748828 | -122.438152103634 | (37.7177638748828, -122.438152103634) | |||
174290 | 174290 | 240855 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 151 Albion St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005930.39356 | 2106374.49675 | 37.7640384026622 | -122.422671922196 | (37.7640384026622, -122.422671922196) | |||
180610 | 180610 | 225142 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Albion St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005928.78135 | 2106387.03173 | 37.764072729797704 | -122.422678389203 | (37.7640727297977, -122.422678389203) | |||
181047 | 181047 | 136527 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 85 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 5997345.31461 | 2114006.64352 | 37.784506200849 | -122.452915959821 | (37.784506200849, -122.452915959821) | |||
183179 | 183179 | 245263 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3724 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004881.16744 | 2102538.46913 | 37.7534463233974 | -122.42602779456399 | (37.7534463233974, -122.426027794564) | |||
183238 | 183238 | 215140 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993993.45625 | 2094092.4558400002 | 37.7296343278608 | -122.463066769619 | (37.7296343278608, -122.463066769619) | |||
184545 | 184545 | 245273 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 65 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009608.20416 | 2098291.4729 | 37.742051034443 | -122.409380928885 | (37.742051034443, -122.409380928885) | |||
186715 | 186715 | 245231 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 24 Dearborn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6005803.549 | 2105901.04894 | 37.762731269549704 | -122.423076986719 | (37.7627312695497, -122.423076986719) | |||
187539 | 187539 | 215183 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 463 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5999025.03283 | 2094940.1697099998 | 37.732250506956504 | -122.44573308543801 | (37.7322505069565, -122.445733085438) | |||
188727 | 188727 | 215138 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5993949.3025 | 2094130.56753 | 37.729736429686206 | -122.46322217696002 | (37.7297364296862, -122.46322217696) | |||
188923 | 188923 | 179577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) |
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");