Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, DBH, PlotSize, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
| 49605 | 49605 | 87302 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 4 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 1 | Permit Number 50312 | 6011942.20762 | 2100900.73993 | 37.7493460165275 | -122.401493976188 | (37.7493460165275, -122.401493976188) | |||
| 51543 | 51543 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 180 Yukon St | Back Yard : Cutout 16 | Tree 1 | Private 1 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.44240692055901 | (37.7570738455347, -122.442406920559) | ||||
| 64868 | 64868 | 113526 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 16x SHELDON TER | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 30 | 3x3 | 5991843.0 | 2103332.0 | 37.7548796468533 | -122.47117393885799 | (37.7548796468533, -122.471173938858) | |||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 84223 | 84223 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 Conrad St | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 20 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 85237 | 85237 | 113807 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 70X MALTA DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x30 | 5999481.0 | 2096265.0 | 37.735914202367894 | -122.444251877835 | (37.7359142023679, -122.444251877835) | ||||
| 88523 | 88523 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 3 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 94229 | 94229 | 116554 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 424x LOS PALMOS DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 16 | 3x3 | 5997290.0 | 2095790.0 | 37.734484721942295 | -122.451792740897 | (37.7344847219423, -122.451792740897) | |||
| 96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 97425 | 97425 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 100593 | 100593 | 115407 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 46 PROSPECT AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 14 | 3x3 | 6007068.0 | 2099193.0 | 37.7443837739696 | -122.41822807190901 | (37.7443837739696, -122.418228071909) | |||
| 105499 | 105499 | 121242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 16th Ave | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 5990933.0 | 2110561.0 | 37.7746758635803 | -122.474848566269 | (37.7746758635803, -122.474848566269) | ||||
| 105687 | 105687 | 122518 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 772X Panorama Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996713.0 | 2102901.0 | 37.753976715350106 | -122.45430108189 | (37.7539767153501, -122.45430108189) | ||||
| 108742 | 108742 | 110939 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 30 | 3x3 | 5992046.0 | 2088201.0 | 37.7133454608488 | -122.46937060641001 | (37.7133454608488, -122.46937060641) | |||
| 110956 | 110956 | 118356 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 RACCOON DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 48 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | ||||
| 112771 | 112771 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 96 CRESTA VISTA DR | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.45765100803699 | (37.7352487002973, -122.457651008037) | ||||||
| 117016 | 117016 | 110120 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 507X JOOST AVE | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 45 | 3x3 | 5998608.0 | 2094933.0 | 37.7322070010706 | -122.44717434081801 | (37.7322070010706, -122.447174340818) | |||
| 128022 | 128022 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150 Raccoon Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 3x3 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | |||
| 142025 | 142025 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 55X Perine Pl | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | ||||
| 145924 | 145924 | 87273 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 4 Miraloma Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 03/12/2008 12:00:00 AM | Permit Number 50295 | 5995203.0 | 2097905.0 | 37.7401722415629 | -122.45916124145 | (37.7401722415629, -122.45916124145) |
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");