Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27525 | 27525 | 215551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994048.13405 | 2096632.6874900002 | 37.7366123276804 | -122.46306197983401 | (37.7366123276804, -122.463061979834) | |||
28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
29756 | 29756 | 215492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993992.82093 | 2097521.50716 | 37.7390496190449 | -122.463317697564 | (37.7390496190449, -122.463317697564) | |||
31013 | 31013 | 198560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.39178010106899 | (37.7364607478562, -122.391780101069) | |||
33083 | 33083 | 215539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 70 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993947.30597 | 2097439.0269400002 | 37.73882052663561 | -122.463469082233 | (37.7388205266356, -122.463469082233) | |||
35712 | 35712 | 198574 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014815.04425 | 2114132.68239 | 37.7858379025473 | -122.39248498701099 | (37.7858379025473, -122.392484987011) | |||
35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) | |||
37359 | 37359 | 215483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.46295396047199 | (37.7397934743851, -122.462953960472) | |||
38137 | 38137 | 215538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993953.054409999 | 2097475.42453 | 37.7389207965449 | -122.46345184763099 | (37.7389207965449, -122.463451847631) | |||
39846 | 39846 | 215499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993991.18061 | 2097202.58443 | 37.738173842158105 | -122.463300232714 | (37.7381738421581, -122.463300232714) | |||
45912 | 45912 | 242593 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 960 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000277.53945 | 2101991.5509200003 | 37.751683359019395 | -122.44190882273199 | (37.7516833590194, -122.441908822732) | |||
47189 | 47189 | 215569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993829.85654 | 2096316.71457 | 37.735732168414 | -122.46379372579901 | (37.735732168414, -122.463793725799) | |||
55611 | 55611 | 198674 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 169 Russ St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6010536.5691599995 | 2111353.45515 | 37.7779682743635 | -122.407091416859 | (37.7779682743635, -122.407091416859) | |||
55699 | 55699 | 198474 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6015187.75524 | 2104800.09072 | 37.7602333639076 | -122.390543142045 | (37.7602333639076, -122.390543142045) | |||
62589 | 62589 | 198564 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6014732.17193 | 2114176.27095 | 37.7859529842748 | -122.392774754864 | (37.7859529842748, -122.392774754864) | |||
64525 | 64525 | 215554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 224 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994072.66196 | 2096533.8959299999 | 37.736342483419705 | -122.462970011551 | (37.7363424834197, -122.462970011551) | |||
64606 | 64606 | 215486 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.739549245488796 | -122.46312045374901 | (37.7395492454888, -122.463120453749) | |||
71554 | 71554 | 215528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.46304438280501 | (37.7398407436586, -122.463044382805) | |||
74042 | 74042 | 198453 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6015012.52649 | 2106269.2143900003 | 37.7642575368696 | -122.39125187709499 | (37.7642575368696, -122.391251877095) | |||
74578 | 74578 | 215514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993902.7407599995 | 2096288.82132 | 37.7356597801802 | -122.463539714991 | (37.7356597801802, -122.463539714991) | |||
76234 | 76234 | 198526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014646.0524 | 2096160.0564599999 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | |||
120433 | 120433 | 215497 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 73 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993976.24019 | 2097340.1859999998 | 37.738550801067 | -122.46336187137 | (37.738550801067, -122.46336187137) | |||
131254 | 131254 | 198643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6016155.89645 | 2108764.08817 | 37.7711713062286 | -122.38747130976401 | (37.7711713062286, -122.387471309764) | ||||
133047 | 133047 | 215548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994023.18881 | 2096729.95205 | 37.736877955053295 | -122.463155280903 | (37.7368779550533, -122.463155280903) | |||
133254 | 133254 | 215479 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 85 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992627.2877 | 2096233.3886799999 | 37.7354340044744 | -122.467945378584 | (37.7354340044744, -122.467945378584) | |||
134594 | 134594 | 198483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6015197.31328 | 2104594.68874 | 37.7596699044709 | -122.390495732502 | (37.7596699044709, -122.390495732502) | |||
134609 | 134609 | 215533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 42 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993973.161169999 | 2097585.26638 | 37.7392235533179 | -122.463390297139 | (37.7392235533179, -122.463390297139) | |||
135165 | 135165 | 215563 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 244 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993985.88408 | 2096348.3750200002 | 37.735828090088894 | -122.463256578734 | (37.7358280900889, -122.463256578734) | |||
135251 | 135251 | 198533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014374.32844 | 2096361.3025900002 | 37.737017074781896 | -122.392766053934 | (37.7370170747819, -122.392766053934) | |||
150445 | 150445 | 180561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.712917038962495 | -122.437192888562 | (37.7129170389625, -122.437192888562) | |||
154584 | 154584 | 183426 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2419 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5989497.0526 | 2098869.9717 | 37.742492119648205 | -122.478960440771 | (37.7424921196482, -122.478960440771) | |||
157065 | 157065 | 215536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 56 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993957.82429 | 2097516.0973 | 37.739032748648796 | -122.463438306534 | (37.7390327486488, -122.463438306534) | |||
158886 | 158886 | 198521 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014485.10287 | 2096211.0948599998 | 37.7366107871579 | -122.39237255107099 | (37.7366107871579, -122.392372551071) | |||
159214 | 159214 | 198602 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016341.1963599995 | 2108654.11325 | 37.7708796003339 | -122.38682267373801 | (37.7708796003339, -122.386822673738) | ||||
159402 | 159402 | 215525 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 478 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994741.9738 | 2100056.97706 | 37.746054518502895 | -122.460911199901 | (37.7460545185029, -122.460911199901) | |||
160439 | 160439 | 198613 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015962.12973 | 2108632.67433 | 37.770799738754 | -122.388132389719 | (37.770799738754, -122.388132389719) | ||||
164646 | 164646 | 215541 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993946.31928 | 2097307.1562900003 | 37.73845838583971 | -122.463462926386 | (37.7384583858397, -122.463462926386) | |||
167961 | 167961 | 215565 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993953.18487 | 2096333.32123 | 37.7357848722665 | -122.46336853982099 | (37.7357848722665, -122.463368539821) | |||
170224 | 170224 | 215559 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994067.05947 | 2096413.8540400001 | 37.7360125554181 | -122.46298067483102 | (37.7360125554181, -122.462980674831) | |||
171175 | 171175 | 215501 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 225 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994092.6368 | 2096583.0249700001 | 37.7364785301452 | -122.462904513945 | (37.7364785301452, -122.462904513945) | |||
178117 | 178117 | 215490 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 45 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994002.63682 | 2097564.4991099997 | 37.739168229725706 | -122.46328687779601 | (37.7391682297257, -122.463286877796) | |||
179957 | 179957 | 123533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3 05th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5994221.757259999 | 2115563.2113799998 | 37.7886006193808 | -122.46383534054199 | (37.7886006193808, -122.463835340542) | |||
181522 | 181522 | 215506 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 255 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994105.35353 | 2096421.48762 | 37.7360357210632 | -122.46284883151199 | (37.7360357210632, -122.462848831512) | |||
183809 | 183809 | 198628 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015696.32506 | 2108739.9117 | 37.7710794584904 | -122.389059310163 | (37.7710794584904, -122.389059310163) | ||||
185782 | 185782 | 215556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994083.61734 | 2096486.4471099998 | 37.736212831753896 | -122.46292869311701 | (37.7362128317539, -122.462928693117) |
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");