Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
32581 | 32581 | 197122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.747376054258105 | -122.394415755007 | (37.7473760542581, -122.394415755007) | |||
34091 | 34091 | 197124 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013733.0286 | 2100130.5529400003 | 37.747331007214896 | -122.395247287949 | (37.7473310072149, -122.395247287949) | |||
40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
44172 | 44172 | 247564 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | |||
44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
46583 | 46583 | 246509 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | |||
48422 | 48422 | 197116 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1015 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011950.215340001 | 2103491.63171 | 37.75646048668521 | -122.40164836548 | (37.7564604866852, -122.40164836548) | |||
49322 | 49322 | 197128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016765.196409999 | 2098282.20265 | 37.7424239805909 | -122.384633436999 | (37.7424239805909, -122.384633436999) | |||
55329 | 55329 | 249399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 222 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008090.577380001 | 2113215.48771 | 37.78294378436429 | -122.41568486886999 | (37.7829437843643, -122.41568486887) | |||
55551 | 55551 | 197118 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013784.73559 | 2105658.04133 | 37.7625111748734 | -122.39545566804199 | (37.7625111748734, -122.395455668042) | |||
56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
56408 | 56408 | 197131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 17 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015885.54456 | 2097735.3383299997 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | |||
60831 | 60831 | 247567 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | |||
67268 | 67268 | 197120 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014065.797040001 | 2105649.96536 | 37.7625046287026 | -122.394483006312 | (37.7625046287026, -122.394483006312) | |||
68861 | 68861 | 197140 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 53 Pomona St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6014151.58684 | 2094423.9633799999 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | |||
69161 | 69161 | 247568 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.734071490194296 | -122.41235633497101 | (37.7340714901943, -122.412356334971) | |||
70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
73028 | 73028 | 197130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015893.1870800005 | 2097747.64492 | 37.7409079313583 | -122.38761132431299 | (37.7409079313583, -122.387611324313) | |||
73273 | 73273 | 197136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071648998 | (37.7383937389821, -122.38966071649) | |||
74086 | 74086 | 239242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.751349662874105 | -122.406008821959 | (37.7513496628741, -122.406008821959) | |||
75202 | 75202 | 197123 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013823.14287 | 2100134.6938099996 | 37.7473473883884 | -122.39493596693 | (37.7473473883884, -122.39493596693) | |||
133236 | 133236 | 197121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6014057.88074 | 2100147.5071099997 | 37.747395620823 | -122.39412515077 | (37.747395620823, -122.39412515077) | |||
148185 | 148185 | 202038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.39963948420099 | (37.7219600944649, -122.399639484201) | |||
149811 | 149811 | 249400 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008085.571690001 | 2113256.87585 | 37.7830571448252 | -122.41570511799699 | (37.7830571448252, -122.415705117997) | |||
152686 | 152686 | 197117 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 315 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013789.951309999 | 2105605.10268 | 37.762366107038105 | -122.395433919764 | (37.7623661070381, -122.395433919764) | |||
152901 | 152901 | 239239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | |||
154405 | 154405 | 246962 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6002859.8798400005 | 2106886.32393 | 37.7652700431031 | -122.43332849181999 | (37.7652700431031, -122.43332849182) | |||
157156 | 157156 | 239261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Utah St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6010855.2107 | 2101671.833 | 37.751402557405896 | -122.405307149322 | (37.7514025574059, -122.405307149322) | |||
160606 | 160606 | 247566 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008741.21767 | 2095435.4350400001 | 37.7341603621059 | -122.41217689865101 | (37.7341603621059, -122.412176898651) | |||
165428 | 165428 | 197129 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.741212233148495 | -122.387337958305 | (37.7412122331485, -122.387337958305) | |||
166384 | 166384 | 239241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | |||
173343 | 173343 | 197137 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1611 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6015105.04683 | 2096793.47619 | 37.7382442932251 | -122.39026979671699 | (37.7382442932251, -122.390269796717) | |||
176449 | 176449 | 197115 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1231 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.40144468342301 | (37.7541312380906, -122.401444683423) | |||
178520 | 178520 | 197119 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014067.1485 | 2105627.53504 | 37.7624431150761 | -122.394476761399 | (37.7624431150761, -122.394476761399) | |||
180496 | 180496 | 197133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016812.9341400005 | 2098272.11729 | 37.742398928158295 | -122.384467670355 | (37.7423989281583, -122.384467670355) | |||
183028 | 183028 | 197134 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016745.12895 | 2098337.97655 | 37.7425760145669 | -122.38470670927299 | (37.7425760145669, -122.384706709273) | |||
188403 | 188403 | 239243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010651.8200900005 | 2101663.18223 | 37.751367430767395 | -122.40600989216101 | (37.7513674307674, -122.406009892161) |
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");