Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
81069 | 81069 | 113145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990980.0 | 2092843.0 | 37.726029586770395 | -122.473393404688 | (37.7260295867704, -122.473393404688) | ||||
87877 | 87877 | 113532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
95633 | 95633 | 114816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x10 | 5995779.0 | 2095603.0 | 37.7338846095715 | -122.45700321324699 | (37.7338846095715, -122.457003213247) | ||||
103044 | 103044 | 113533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
107674 | 107674 | 106774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155X Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5990905.0300199995 | 2094685.3067400001 | 37.7310837571916 | -122.47378690918801 | (37.7310837571916, -122.473786909188) | |||
107836 | 107836 | 113531 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 28 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | |||
116856 | 116856 | 109176 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 335 COLON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 26 | 5995818.3 | 2094822.2 | 37.7317429788493 | -122.45681088999399 | (37.7317429788493, -122.456810889994) | ||||
127907 | 127907 | 109177 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 320 COLON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 5995887.7 | 2094797.5 | 37.7316791433679 | -122.45656917602899 | (37.7316791433679, -122.456569176029) |
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");