Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23955 | 23955 | 204246 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997506.8200199995 | 2099205.04953 | 37.7438740375718 | -122.45128934072399 | (37.7438740375718, -122.451289340724) | |||
24322 | 24322 | 125703 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008909.16091 | 2116830.53076 | 37.7929157990679 | -122.4131085999 | (37.7929157990679, -122.4131085999) | |||
28073 | 28073 | 221120 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 326 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008611.309880001 | 2097158.27133 | 37.7388836059924 | -122.41274779008499 | (37.7388836059924, -122.412747790085) | |||
29548 | 29548 | 204248 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 547 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996224.70545 | 2089880.3826 | 37.7181972518712 | -122.455048908902 | (37.7181972518712, -122.455048908902) | |||
30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
32146 | 32146 | 204250 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996278.68243 | 2089878.5277599997 | 37.7181952553759 | -122.45486220065399 | (37.7181952553759, -122.454862200654) | |||
33477 | 33477 | 221124 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 355 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007210.69865 | 2096548.51088 | 37.737130625862704 | -122.41754726049801 | (37.7371306258627, -122.417547260498) | |||
36453 | 36453 | 221122 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 8 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007401.99746 | 2099837.76455 | 37.7461729475405 | -122.41711885317 | (37.7461729475405, -122.41711885317) | |||
39463 | 39463 | 205605 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 555 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998406.069490001 | 2094967.6325 | 37.732290553769204 | -122.447874949473 | (37.7322905537692, -122.447874949473) | |||
44672 | 44672 | 205606 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998487.62323 | 2094969.3893900001 | 37.7323000389202 | -122.44759312714599 | (37.7323000389202, -122.447593127146) | |||
47076 | 47076 | 221171 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000910.085469999 | 2105681.05677 | 37.761849869193 | -122.43998592380501 | (37.761849869193, -122.439985923805) | |||
50257 | 50257 | 125705 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008691.84445 | 2116822.80562 | 37.792882385661 | -122.41385998166001 | (37.792882385661, -122.41385998166) | |||
55729 | 55729 | 221138 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 110 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003494.94443 | 2095122.0497700002 | 37.733004107356294 | -122.430292564064 | (37.7330041073563, -122.430292564064) | |||
56258 | 56258 | 205603 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 845 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999427.00683 | 2095718.88382 | 37.7344116156036 | -122.44439931797501 | (37.7344116156036, -122.444399317975) | |||
62123 | 62123 | 204249 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996267.7381 | 2089878.75641 | 37.71819525538329 | -122.454900046824 | (37.7181952553833, -122.454900046824) | |||
64085 | 64085 | 204247 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 360 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997685.380340001 | 2093824.52357 | 37.7291106283292 | -122.450284154993 | (37.7291106283292, -122.450284154993) | |||
68660 | 68660 | 125694 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999115.53218 | 2121417.6212299997 | 37.8049560584444 | -122.447325218189 | (37.8049560584444, -122.447325218189) | |||
72316 | 72316 | 175551 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001714.08055 | 2089236.3629599998 | 37.716742309774496 | -122.436028453575 | (37.7167423097745, -122.436028453575) | |||
74790 | 74790 | 221123 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 378 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007343.72622 | 2096503.7494 | 37.737015205071295 | -122.417084151929 | (37.7370152050713, -122.417084151929) | |||
75084 | 75084 | 125704 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008924.73472 | 2116833.00784 | 37.792923474790896 | -122.413054888768 | (37.7929234747909, -122.413054888768) | |||
76957 | 76957 | 204251 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996289.61918 | 2089877.93605 | 37.7181942580441 | -122.454824354468 | (37.7181942580441, -122.454824354468) | |||
131982 | 131982 | 221172 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000923.42132 | 2105688.65448 | 37.7618714897953 | -122.43994034528 | (37.7618714897953, -122.43994034528) | |||
137556 | 137556 | 204229 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 243 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994968.46955 | 2106663.402 | 37.76420710740771 | -122.460606664293 | (37.7642071074077, -122.460606664293) | |||
148224 | 148224 | 188231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012859.425559999 | 2113671.68237 | 37.7844633085723 | -122.399218553795 | (37.7844633085723, -122.399218553795) | |||
149960 | 149960 | 175554 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 751 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002038.05484 | 2089420.5116400002 | 37.7172663411433 | -122.434921798223 | (37.7172663411433, -122.434921798223) | |||
152761 | 152761 | 175555 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 744 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002240.95464 | 2089320.7382099999 | 37.7170039036857 | -122.434213341068 | (37.7170039036857, -122.434213341068) | |||
155939 | 155939 | 205607 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998498.386580001 | 2094968.0137599998 | 37.7322968768869 | -122.447555816948 | (37.7322968768869, -122.447555816948) | |||
156838 | 156838 | 204236 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1330 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5993657.9849 | 2106425.1721 | 37.7634775090049 | -122.46512191475 | (37.7634775090049, -122.46512191475) | |||
163472 | 163472 | 175556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 675 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002319.00588 | 2089864.96187 | 37.7185026508577 | -122.43398243563499 | (37.7185026508577, -122.433982435635) | |||
166307 | 166307 | 175553 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001661.33875 | 2089268.82238 | 37.716828439656794 | -122.43621307719299 | (37.7168284396568, -122.436213077193) | |||
169113 | 169113 | 205608 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998524.77669 | 2094967.4645 | 37.7322968768837 | -122.447464541153 | (37.7322968768837, -122.447464541153) | |||
169215 | 169215 | 204243 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 90 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993464.526880001 | 2093539.34009 | 37.7280851251272 | -122.46485516683201 | (37.7280851251272, -122.464855166832) | |||
174279 | 174279 | 175550 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001725.18782 | 2089230.405 | 37.7167265815513 | -122.435989635215 | (37.7167265815513, -122.435989635215) | |||
178003 | 178003 | 175552 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001677.55767 | 2089258.3943 | 37.716800727959104 | -122.436156270607 | (37.7168007279591, -122.436156270607) |
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");