Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
27348 | 27348 | 225835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010878.34698 | 2102482.51525 | 37.7536298057935 | -122.40528422380899 | (37.7536298057935, -122.405284223809) | |||
27894 | 27894 | 128840 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011231.32586 | 2121455.9320099996 | 37.8057461137655 | -122.40539964187599 | (37.8057461137655, -122.405399641876) | |||
29096 | 29096 | 225825 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6011093.6138 | 2102532.5721400003 | 37.7537792839011 | -122.404543302929 | (37.7537792839011, -122.404543302929) | |||
31134 | 31134 | 246971 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002932.26985 | 2106723.06084 | 37.7648258688387 | -122.433066446456 | (37.7648258688387, -122.433066446456) | |||
32970 | 32970 | 176487 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 6011797.051530001 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | |||
33850 | 33850 | 225838 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010873.380419999 | 2102595.51297 | 37.753939794896105 | -122.40530935625799 | (37.7539397948961, -122.405309356258) | |||
34776 | 34776 | 128838 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1614 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005643.34494 | 2118253.58513 | 37.7966392702321 | -122.42450976952499 | (37.7966392702321, -122.424509769525) | |||
41861 | 41861 | 225839 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010870.72267 | 2102625.60051 | 37.754022260038 | -122.40532066611 | (37.754022260038, -122.40532066611) | |||
44123 | 44123 | 201434 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 200 Harbor Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6018235.129430001 | 2094913.6539 | 37.7332557952224 | -122.37931686450099 | (37.7332557952224, -122.379316864501) | |||
44362 | 44362 | 225855 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1619 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6004635.97757 | 2099333.5139200003 | 37.7446323980786 | -122.42664750570101 | (37.7446323980786, -122.426647505701) | |||
46467 | 46467 | 225824 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011091.77167 | 2102559.41951 | 37.753852897909105 | -122.404551563217 | (37.7538528979091, -122.404551563217) | |||
46763 | 46763 | 225859 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998015.015430001 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | |||
53143 | 53143 | 225823 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011090.95025 | 2102601.58592 | 37.7539686316657 | -122.404557371938 | (37.7539686316657, -122.404557371938) | |||
62062 | 62062 | 225836 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010877.083380001 | 2102509.67969 | 37.7537043227005 | -122.40529050644399 | (37.7537043227005, -122.405290506444) | |||
63759 | 63759 | 246972 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6002932.11099 | 2106737.87543 | 37.764866537093894 | -122.433068054458 | (37.7648665370939, -122.433068054458) | |||
69085 | 69085 | 225826 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011095.54336 | 2102504.4626599997 | 37.7537022093019 | -122.40453465146601 | (37.7537022093019, -122.404534651466) | |||
69771 | 69771 | 225837 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010874.71509 | 2102536.14279 | 37.7537768521194 | -122.405300559996 | (37.7537768521194, -122.405300559996) | |||
74402 | 74402 | 225834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010880.09664 | 2102425.6694099996 | 37.7534738174881 | -122.40527417026001 | (37.7534738174881, -122.40527417026) | |||
109431 | 109431 | 225840 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010871.216109999 | 2102649.83415 | 37.754088827844896 | -122.405320666132 | (37.7540888278449, -122.405320666132) | |||
109836 | 109836 | 225831 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010886.07537 | 2102341.86633 | 37.753244046982395 | -122.405247593515 | (37.7532440469824, -122.405247593515) | |||
138124 | 138124 | 128839 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1661 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005108.54777 | 2118478.70027 | 37.7972271633692 | -122.426376325029 | (37.7972271633692, -122.426376325029) | |||
149746 | 149746 | 225821 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011085.78168 | 2102661.2355400003 | 37.7541321275051 | -122.40457944489701 | (37.7541321275051, -122.404579444897) | |||
152103 | 152103 | 225827 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011098.29939 | 2102434.5099400003 | 37.753510288572 | -122.40452019665899 | (37.753510288572, -122.404520196659) | |||
152600 | 152600 | 176486 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6011771.80954 | 2087312.16984 | 37.712025121923396 | -122.40112851596399 | (37.7120251219234, -122.401128515964) | |||
152837 | 152837 | 225830 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011105.21745 | 2102361.77794 | 37.7533109691405 | -122.404491153067 | (37.7533109691405, -122.404491153067) | |||
153851 | 153851 | 225822 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011089.51394 | 2102630.04924 | 37.754046705392796 | -122.40456434257601 | (37.7540467053928, -122.404564342576) | |||
155214 | 155214 | 225860 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 5997829.91039 | 2105879.4144599997 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | |||
155581 | 155581 | 225832 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010884.0917 | 2102372.03414 | 37.7533267702301 | -122.405256577724 | (37.7533267702301, -122.405256577724) | |||
159226 | 159226 | 192386 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 725 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 24 | Width 4ft | 6011857.61784 | 2104994.61162 | 37.7605821695415 | -122.40207426103399 | (37.7605821695415, -122.402074261034) | |||
167312 | 167312 | 225841 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010865.97168 | 2102677.80317 | 37.7541653313745 | -122.40534077226101 | (37.7541653313745, -122.405340772261) | |||
168604 | 168604 | 225820 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011084.057440001 | 2102692.0465599997 | 37.754216631403 | -122.40458757656799 | (37.754216631403, -122.404587576568) | |||
171085 | 171085 | 225858 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3561 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6004581.43862 | 2103650.71284 | 37.756483339342395 | -122.427143538447 | (37.7564833393424, -122.427143538447) | |||
178593 | 178593 | 225857 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3561 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6004603.67421 | 2103652.1683400003 | 37.75648859319929 | -122.42706674353501 | (37.7564885931993, -122.427066743535) | |||
181235 | 181235 | 246973 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6002929.82417 | 2106784.67092 | 37.764994896425705 | -122.433079307674 | (37.7649948964257, -122.433079307674) | |||
185139 | 185139 | 225829 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011100.71134 | 2102387.9622400003 | 37.753382613635296 | -122.40450857923099 | (37.7533826136353, -122.404508579231) | |||
187330 | 187330 | 225833 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010883.2575 | 2102402.44646 | 37.753410229111 | -122.40526160403999 | (37.753410229111, -122.40526160404) | |||
187507 | 187507 | 225828 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6011100.1328300005 | 2102409.04918 | 37.7534404813975 | -122.404512064091 | (37.7534404813975, -122.404512064091) |
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");