Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
36178 | 36178 | 197095 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.39280290452601 | (37.7527194688438, -122.392802904526) | |||
36783 | 36783 | 136264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011327.59811 | 2121029.0502400002 | 37.804579383680895 | -122.40503639942601 | (37.8045793836809, -122.405036399426) | |||
40908 | 40908 | 197109 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | ||||
41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
55248 | 55248 | 197103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | |||
57011 | 57011 | 136263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | |||
62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
65149 | 65149 | 197108 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012056.73956 | 2105565.85317 | 37.762161783771205 | -122.401425732033 | (37.7621617837712, -122.401425732033) | ||||
69725 | 69725 | 124089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | ||||
70424 | 70424 | 124324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996182.48161 | 2113700.3553299997 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | |||
73613 | 73613 | 136261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | ||||
76745 | 76745 | 197102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014466.67746 | 2102042.06403 | 37.752620386043205 | -122.392844072804 | (37.7526203860432, -122.392844072804) | |||
121744 | 121744 | 107696 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
134067 | 134067 | 197110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012050.80748 | 2105527.2247200003 | 37.7620553876595 | -122.40144353408701 | (37.7620553876595, -122.401443534087) | ||||
134469 | 134469 | 197089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.39282883379101 | (37.7529508329366, -122.392828833791) | |||
136568 | 136568 | 136260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | |||
137657 | 137657 | 197111 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012057.756469999 | 2105514.57714 | 37.762021047941204 | -122.401418611192 | (37.7620210479412, -122.401418611192) | ||||
149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
150842 | 150842 | 136205 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Locust St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997542.32225 | 2115652.46545 | 37.78903647900739 | -122.452353187461 | (37.7890364790074, -122.452353187461) | |||
157085 | 157085 | 197085 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014468.858580001 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | |||
157309 | 157309 | 197105 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014414.64892 | 2102038.8947099997 | 37.752608793773796 | -122.393023776248 | (37.7526087937738, -122.393023776248) | |||
160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
168763 | 168763 | 213992 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.733138545197704 | -122.43827381338801 | (37.7331385451977, -122.438273813388) | |||
170402 | 170402 | 197083 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | |||
171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
172109 | 172109 | 213994 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 132 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999171.152980001 | 2095530.50421 | 37.7338797682181 | -122.445270345553 | (37.7338797682181, -122.445270345553) | |||
176731 | 176731 | 197101 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6012884.97292 | 2106850.1929599997 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | |||
178466 | 178466 | 197104 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014428.85484 | 2102039.8538900004 | 37.752612216591004 | -122.392974716426 | (37.752612216591, -122.392974716426) | |||
178725 | 178725 | 197106 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014394.04215 | 2102037.78794 | 37.752604610114005 | -122.393094961165 | (37.752604610114, -122.393094961165) | |||
181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
181973 | 181973 | 197091 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014475.63706 | 2102134.7648099996 | 37.7528754202862 | -122.39281957348601 | (37.7528754202862, -122.392819573486) |
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");