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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
26492 | 26492 | 242374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006546.0037 | 2109148.1970900004 | 37.771689039651896 | -122.42073962714899 | (37.7716890396519, -122.420739627149) | |||
30111 | 30111 | 198501 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | ||||
40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
43669 | 43669 | 246542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126001 | (37.772505687922, -122.42377321126) | |||
50390 | 50390 | 246538 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | |||
57780 | 57780 | 246553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6005726.464930001 | 2109532.06592 | 37.7726968262309 | -122.42360176272699 | (37.7726968262309, -122.423601762727) | |||
75717 | 75717 | 246541 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.772441848655795 | -122.423755901126 | (37.7724418486558, -122.423755901126) | |||
131030 | 131030 | 246540 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | |||
135988 | 135988 | 242371 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6006102.65154 | 2109126.4322 | 37.771604280331005 | -122.42227166541001 | (37.771604280331, -122.42227166541) | |||
136228 | 136228 | 246554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.772739687913706 | -122.423612306376 | (37.7727396879137, -122.423612306376) | |||
138030 | 138030 | 242370 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6006121.14049 | 2109126.61017 | 37.7716058118802 | -122.422207723609 | (37.7716058118802, -122.422207723609) | |||
151969 | 151969 | 246544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005666.89387 | 2109521.5509099998 | 37.7726645918273 | -122.42380707793998 | (37.7726645918273, -122.42380707794) | |||
155019 | 155019 | 246537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | |||
160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
175443 | 175443 | 246555 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.772815290316295 | -122.423623602744 | (37.7728152903163, -122.423623602744) | |||
178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | |||
181312 | 181312 | 246539 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | |||
183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) |
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");