Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47708 | 47708 | 201384 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018192.32323 | 2095410.89535 | 37.73461876184721 | -122.379499389078 | (37.7346187618472, -122.379499389078) | |||
62585 | 62585 | 201369 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 175 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018228.8289 | 2095275.93541 | 37.7342502016868 | -122.379363803718 | (37.7342502016868, -122.379363803718) | |||
64599 | 64599 | 229187 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3291 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6007776.8751 | 2100527.33423 | 37.7480874332941 | -122.41587139094601 | (37.7480874332941, -122.415871390946) | |||
64672 | 64672 | 201451 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.15931 | 2095830.10025 | 37.735770303244294 | -122.379497951066 | (37.7357703032443, -122.379497951066) | |||
66076 | 66076 | 201385 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018189.447380001 | 2095346.27491 | 37.7344411682206 | -122.37950484439399 | (37.7344411682206, -122.379504844394) | |||
67195 | 67195 | 201447 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.6528199995 | 2095922.70915 | 37.7360246162273 | -122.379502676117 | (37.7360246162273, -122.379502676117) | |||
68023 | 68023 | 201453 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018197.87092 | 2095750.8837 | 37.7355526088591 | -122.37950381915199 | (37.7355526088591, -122.379503819152) | |||
70501 | 70501 | 201446 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018203.56195 | 2095942.2457299998 | 37.7360783651123 | -122.37949743215599 | (37.7360783651123, -122.379497432156) | |||
72620 | 72620 | 201382 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018191.80275 | 2095463.53858 | 37.7347632810917 | -122.379504844387 | (37.7347632810917, -122.379504844387) | |||
76492 | 76492 | 201448 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.246669999 | 2095899.23828 | 37.735960147450704 | -122.379502450391 | (37.7359601474507, -122.379502450391) | |||
151671 | 151671 | 201368 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 175 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018226.9732800005 | 2095256.66698 | 37.734197192029704 | -122.379368881264 | (37.7341971920297, -122.379368881264) | |||
157197 | 157197 | 201370 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 175 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018229.792119999 | 2095294.6367900001 | 37.734301605121104 | -122.37936177213699 | (37.7343016051211, -122.379361772137) | |||
160952 | 160952 | 201444 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018205.67502 | 2096093.6651299999 | 37.7364942494189 | -122.379500641858 | (37.7364942494189, -122.379500641858) | |||
169795 | 169795 | 201378 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 100 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 10ft | 6018192.57747 | 2095584.31528 | 37.7350949528572 | -122.379510553277 | (37.7350949528572, -122.379510553277) | |||
171255 | 171255 | 201379 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 100 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 10ft | 6018192.62892 | 2095551.89867 | 37.7350059460682 | -122.379508124201 | (37.7350059460682, -122.379508124201) | |||
176121 | 176121 | 201386 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018188.14311 | 2095325.0086400001 | 37.7343827032917 | -122.379507876895 | (37.7343827032917, -122.379507876895) | |||
176290 | 176290 | 201449 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018200.77353 | 2095868.3398 | 37.7358752802274 | -122.37950194045901 | (37.7358752802274, -122.379501940459) | |||
180999 | 180999 | 201383 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018192.817430001 | 2095435.4996599997 | 37.7346863476974 | -122.379499389088 | (37.7346863476974, -122.379499389088) |
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");