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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187352 | 187352 | 231154 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 114 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6009037.91802 | 2097949.68655 | 37.7410805949011 | -122.411328665303 | (37.7410805949011, -122.411328665303) | |||
184383 | 184383 | 201380 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 100 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 6018193.3537099995 | 2095527.6615900001 | 37.7349394357932 | -122.379503935163 | (37.7349394357932, -122.379503935163) | |||
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) | |||
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) | |||
176941 | 176941 | 250886 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 187 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986785.041569999 | 2114523.7412799997 | 37.7853151779048 | -122.489488445745 | (37.7853151779048, -122.489488445745) | |||
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) | |||
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) | |||
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) | |||
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) | |||
166814 | 166814 | 130428 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1680 Taylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6008776.13337 | 2118721.7233599997 | 37.798101079559395 | -122.413702711824 | (37.7981010795594, -122.413702711824) | |||
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) | |||
159872 | 159872 | 208530 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 66 Lobos St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5996236.67011 | 2088707.6674799998 | 37.7149779370547 | -122.45492286439699 | (37.7149779370547, -122.454922864397) | ||||
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) | |||
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) | |||
153539 | 153539 | 201377 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 100 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 6018193.606000001 | 2095600.54319 | 37.7351395682275 | -122.379508124199 | (37.7351395682275, -122.379508124199) | |||
151833 | 151833 | 229188 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3287 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6007796.6026099995 | 2100528.4399 | 37.748091578262795 | -122.415803252021 | (37.7480915782628, -122.415803252021) | |||
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) | |||
150242 | 150242 | 130429 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1680 Taylor St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6008772.072269999 | 2118754.32118 | 37.798190357049705 | -122.413719071397 | (37.7981903570497, -122.413719071397) | |||
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) | |||
134563 | 134563 | 192745 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3429 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6013179.5796 | 2089589.99773 | 37.71835802098379 | -122.396422384394 | (37.7183580209838, -122.396422384394) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
61771 | 61771 | 201441 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018208.2556 | 2096140.7000900002 | 37.7366235404482 | -122.37949498601601 | (37.7366235404482, -122.379494986016) | |||
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) | |||
38144 | 38144 | 201442 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6018207.71631 | 2096124.7676 | 37.736579763236705 | -122.37949574413601 | (37.7365797632367, -122.379495744136) | |||
34335 | 34335 | 201443 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6018205.670580001 | 2096108.31022 | 37.736534461697104 | -122.379501674263 | (37.7365344616971, -122.379501674263) | |||
23444 | 23444 | 201445 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018205.83588 | 2096062.22823 | 37.7364079387746 | -122.379497902505 | (37.7364079387746, -122.379497902505) |
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");