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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2567 | 2567 | 252819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479.0 | 2096413.0 | 37.736604456337105 | -122.426982337456 | (37.7366044563371, -122.426982337456) | ||
24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
32208 | 32208 | 207938 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 168 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994463.39444 | 2096391.8205099998 | 37.735974878342205 | -122.461608798622 | (37.7359748783422, -122.461608798622) | |||
35744 | 35744 | 207933 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5995331.00373 | 2100187.61073 | 37.746447081563 | -122.458883881613 | (37.746447081563, -122.458883881613) | |||
39991 | 39991 | 249929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | Width 0ft | 6011103.53501 | 2120007.07668 | 37.801760767194 | -122.405739765471 | (37.801760767194, -122.405739765471) | |||
40769 | 40769 | 207918 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993549.31722 | 2095096.55206 | 37.7323657343817 | -122.464675076695 | (37.7323657343817, -122.464675076695) | |||
47167 | 47167 | 182701 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1706 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5989689.5329 | 2103706.6241 | 37.75578346921429 | -122.478648542868 | (37.7557834692143, -122.478648542868) | |||
54907 | 54907 | 207912 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993750.78708 | 2099620.0090799998 | 37.744797631402996 | -122.46430684749501 | (37.744797631403, -122.464306847495) | |||
55233 | 55233 | 177086 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 114 Gillette Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6013074.44499 | 2086867.89295 | 37.7108778091238 | -122.39659507942301 | (37.7108778091238, -122.396595079423) | |||
55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
57403 | 57403 | 207920 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993561.46186 | 2095084.6811400002 | 37.73233383991511 | -122.46463222850599 | (37.7323338399151, -122.464632228506) | |||
58144 | 58144 | 207932 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994525.1369 | 2100016.19972 | 37.7459300748307 | -122.461658032009 | (37.7459300748307, -122.461658032009) | |||
58173 | 58173 | 124075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5991933.35964 | 2110333.59039 | 37.774109377871106 | -122.47137158054599 | (37.7741093778711, -122.471371580546) | |||
60928 | 60928 | 207951 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993609.19049 | 2101330.01407 | 37.7494847081672 | -122.4649206222 | (37.7494847081672, -122.4649206222) | |||
63027 | 63027 | 207411 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 368 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994209.72393 | 2101319.30186 | 37.7494899026486 | -122.462843199076 | (37.7494899026486, -122.462843199076) | |||
64518 | 64518 | 207931 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 9 Homewood Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994625.2236 | 2093411.18724 | 37.7278001020881 | -122.460833344698 | (37.7278001020881, -122.460833344698) | |||
71064 | 71064 | 183299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983077.482999999 | 2106392.3859 | 37.7627716918826 | -122.501713459776 | (37.7627716918826, -122.501713459776) | |||
123815 | 123815 | 207396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5992865.43172 | 2103190.1743799997 | 37.754549316717 | -122.467627800978 | (37.754549316717, -122.467627800978) | |||
130983 | 130983 | 207922 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993570.7217 | 2095074.32308 | 37.732305933067 | -122.46459946350299 | (37.732305933067, -122.464599463503) | |||
136758 | 136758 | 142203 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1619 Hayes St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6000105.1937 | 2110218.2805 | 37.7742620968205 | -122.44309558343201 | (37.7742620968205, -122.443095583432) | |||
137696 | 137696 | 207395 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5992873.157240001 | 2103191.67776 | 37.7545538906601 | -122.46760119364299 | (37.7545538906601, -122.467601193643) | |||
147156 | 147156 | 182589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | |||
160628 | 160628 | 183298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983077.482999999 | 2106384.7622 | 37.762750759369105 | -122.501712895715 | (37.7627507593691, -122.501712895715) | |||
163811 | 163811 | 207919 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993555.00989 | 2095089.8986 | 37.73234779381271 | -122.464654913005 | (37.7323477938127, -122.464654913005) | |||
165150 | 165150 | 200058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6014865.9446 | 2094065.6668 | 37.7307410182438 | -122.390905909596 | (37.7307410182438, -122.390905909596) | |||
165829 | 165829 | 227281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4181 23rd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6001938.68503 | 2102334.04898 | 37.752718294320296 | -122.43618888093701 | (37.7527182943203, -122.436188880937) | |||
166661 | 166661 | 207923 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993572.45221 | 2095069.9309 | 37.7322939729878 | -122.46459316196899 | (37.7322939729878, -122.464593161969) | |||
167651 | 167651 | 207397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992858.7373 | 2103189.98205 | 37.7545484021055 | -122.467650937865 | (37.7545484021055, -122.467650937865) | |||
167970 | 167970 | 207952 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993588.025769999 | 2101347.20495 | 37.7495306895917 | -122.464995058183 | (37.7495306895917, -122.464995058183) | |||
170238 | 170238 | 249928 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 0ft | 6011076.21302 | 2120004.52946 | 37.801752245226396 | -122.40583413315001 | (37.8017522452264, -122.40583413315) | |||
170244 | 170244 | 207924 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993576.36868 | 2095065.49282 | 37.7322820128957 | -122.464579299802 | (37.7322820128957, -122.464579299802) | |||
170777 | 170777 | 200060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6014881.3338 | 2094088.2009 | 37.7308037462249 | -122.390854280531 | (37.7308037462249, -122.390854280531) | |||
173295 | 173295 | 200059 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | |||
175820 | 175820 | 207921 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993566.43334 | 2095078.40606 | 37.7323168967005 | -122.46461458559999 | (37.7323168967005, -122.4646145856) | |||
178236 | 178236 | 207953 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 44 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994094.04258 | 2101846.56715 | 37.750930975380896 | -122.46328148097601 | (37.7509309753809, -122.463281480976) | |||
183560 | 183560 | 227186 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 260 Upper Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5999465.27543 | 2106151.00222 | 37.7630578682481 | -122.445016716945 | (37.7630578682481, -122.445016716945) | |||
187508 | 187508 | 191440 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2212 25th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6012152.298359999 | 2101896.5627900003 | 37.75209205051161 | -122.40083742701401 | (37.7520920505116, -122.400837427014) | |||
188436 | 188436 | 207812 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 635 Hearst Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5997216.39115 | 2094387.61086 | 37.7306298809467 | -122.451946087746 | (37.7306298809467, -122.451946087746) |
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");