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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
71342 | 71342 | 201450 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 6018200.75737 | 2095847.6313 | 37.735818417881106 | -122.379500558206 | (37.7358184178811, -122.379500558206) | |||
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) | |||
149823 | 149823 | 201454 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018196.93035 | 2095729.08903 | 37.73549271311771 | -122.379505557543 | (37.7354927131177, -122.379505557543) | |||
157882 | 157882 | 201381 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018192.01331 | 2095500.19369 | 37.7348639404214 | -122.379506661926 | (37.7348639404214, -122.379506661926) | |||
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) | |||
179491 | 179491 | 201452 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018199.95572 | 2095808.82115 | 37.7357118086525 | -122.37950063464199 | (37.7357118086525, -122.379500634642) | |||
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");