Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25648 | 25648 | 191123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012425.58055 | 2105029.27463 | 37.7607090306229 | -122.400112358502 | (37.7607090306229, -122.400112358502) | |||
26311 | 26311 | 227767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000143.14107 | 2101645.6357400003 | 37.7507259002966 | -122.442348757612 | (37.7507259002966, -122.442348757612) | |||
29643 | 29643 | 246620 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009078.777530001 | 2099136.29589 | 37.744341055486295 | -122.411271191437 | (37.7443410554863, -122.411271191437) | |||
37214 | 37214 | 191135 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6015829.2920699995 | 2099737.9733599997 | 37.7463694242077 | -122.387971104383 | (37.7463694242077, -122.387971104383) | ||||
41487 | 41487 | 208150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 210 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000776.72095 | 2094702.6231900002 | 37.7316981172754 | -122.439660093143 | (37.7316981172754, -122.439660093143) | |||
41780 | 41780 | 208153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 435 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999203.01227 | 2094950.2253400001 | 37.732288277587706 | -122.445118495046 | (37.7322882775877, -122.445118495046) | |||
46300 | 46300 | 191141 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6015816.86409 | 2114381.01819 | 37.78657535921089 | -122.389036284815 | (37.7865753592109, -122.389036284815) | |||
53038 | 53038 | 208160 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 366 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997663.5494099995 | 2093590.68698 | 37.7284673190039 | -122.45034277641399 | (37.7284673190039, -122.450342776414) | |||
54764 | 54764 | 246617 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 179 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009150.0999300005 | 2099139.59949 | 37.7443541262592 | -122.411024805947 | (37.7443541262592, -122.411024805947) | |||
59631 | 59631 | 191142 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6015882.39445 | 2114438.5684700003 | 37.7867370114514 | -122.388813583003 | (37.7867370114514, -122.388813583003) | |||
69558 | 69558 | 208157 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000676.4727 | 2094919.4754400002 | 37.7322878369069 | -122.440022214175 | (37.7322878369069, -122.440022214175) | ||||
72799 | 72799 | 208158 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999136.82993 | 2093762.64441 | 37.7290236809976 | -122.445261947704 | (37.7290236809976, -122.445261947704) | |||
74914 | 74914 | 246619 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009083.01922 | 2099139.1845299997 | 37.7443492249476 | -122.411256728527 | (37.7443492249476, -122.411256728527) | |||
90213 | 90213 | 100247 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
106403 | 106403 | 102105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 769122 | 6002645.0 | 2099438.0 | 37.7448065304391 | -122.43353937189501 | (37.7448065304391, -122.433539371895) | |||
129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
132565 | 132565 | 227768 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6000154.6428 | 2101646.40611 | 37.750728671093704 | -122.442309039053 | (37.7507286710937, -122.442309039053) | |||
133563 | 133563 | 191137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6015869.60508 | 2099707.91773 | 37.7462891309579 | -122.387829608652 | (37.7462891309579, -122.387829608652) | ||||
151596 | 151596 | 227822 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 146 Elsie St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007069.8584 | 2098388.70244 | 37.7421754574342 | -122.418164635198 | (37.7421754574342, -122.418164635198) | |||
151681 | 151681 | 118454 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8350 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5981044.43167 | 2112373.0207700003 | 37.7790731383894 | -122.50918908645399 | (37.7790731383894, -122.509189086454) | ||||
152753 | 152753 | 208156 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6000658.62955 | 2094922.8183799998 | 37.732296000053 | -122.440084141493 | (37.732296000053, -122.440084141493) | ||||
158601 | 158601 | 208076 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 442 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998485.7432 | 2094410.1353900002 | 37.7307643520895 | -122.447559384561 | (37.7307643520895, -122.447559384561) | |||
160391 | 160391 | 120011 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 886 29th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5987003.60348 | 2109935.62097 | 37.7727302588392 | -122.48839498846 | (37.7727302588392, -122.48839498846) | |||
167232 | 167232 | 227544 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 288 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002936.87727 | 2096251.7785 | 37.7360744584526 | -122.432302602791 | (37.7360744584526, -122.432302602791) | ||||
174064 | 174064 | 177152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 649 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6009816.38769 | 2091371.81115 | 37.7230627793063 | -122.408173178961 | (37.7230627793063, -122.408173178961) | |||
174097 | 174097 | 208149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hamerton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6001382.20466 | 2095404.6567400002 | 37.7336601834577 | -122.43761707629 | (37.7336601834577, -122.43761707629) | |||
175051 | 175051 | 129722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007108.76695 | 2120556.6740099997 | 37.8030456187175 | -122.419602556719 | (37.8030456187175, -122.419602556719) | |||
178697 | 178697 | 191124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012423.59359 | 2105049.6302900002 | 37.760764811978 | -122.400120660154 | (37.760764811978, -122.400120660154) | |||
180624 | 180624 | 208155 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997950.371590001 | 2095226.7551900002 | 37.7329759855362 | -122.449469058051 | (37.7329759855362, -122.449469058051) | ||||
186620 | 186620 | 191136 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6015849.43406 | 2099722.2269099997 | 37.7463273035772 | -122.387900356534 | (37.7463273035772, -122.387900356534) | ||||
188107 | 188107 | 208154 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997951.24674 | 2095236.71061 | 37.7330033708131 | -122.449466749514 | (37.7330033708131, -122.449466749514) |
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");