Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11417 | 11417 | 117425 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 218 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775470 | 6004576.76699 | 2091985.7103900001 | 37.724453633907 | -122.426329194258 | (37.724453633907, -122.426329194258) | ||
| 29923 | 29923 | 52529 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 142 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Permit Number 48628 | 6001327.58175 | 2092279.55294 | 37.7250762588572 | -122.437582197876 | (37.7250762588572, -122.437582197876) | ||
| 43477 | 43477 | 60873 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 2028 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2012 12:00:00 AM | 4x4 | Permit Number 768154 | 6008629.04829533 | 2119833.32118677 | 37.8011449901029 | -122.41429036156799 | (37.8011449901029, -122.414290361568) | ||
| 49988 | 49988 | 57815 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 154 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1977 12:00:00 AM | 5 | Permit Number 16752 | 5988698.7114699995 | 2114305.32947 | 37.7848270128848 | -122.482851795657 | (37.7848270128848, -122.482851795657) | ||
| 55606 | 55606 | 51326 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 489 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2004 12:00:00 AM | 2 | Permit Number 47685 | 6013940.29088 | 2112585.38247 | 37.781540755646894 | -122.39540297587799 | (37.7815407556469, -122.395402975878) | ||
| 66945 | 66945 | 47439 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 855 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45350 | 5982911.03807 | 2109970.6301700003 | 37.772586745672996 | -122.50255398243 | (37.772586745673, -122.50255398243) | |
| 77663 | 77663 | 115778 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 1258 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772460 | 6014378.5 | 2090761.5 | 37.721641380247995 | -122.392360079917 | (37.721641380248, -122.392360079917) | ||
| 84460 | 84460 | 58589 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 232 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1979 12:00:00 AM | Permit Number 17789 | 5997635.76865 | 2106178.20779874 | 37.7630279802836 | -122.45134629008601 | (37.7630279802836, -122.451346290086) | |||
| 89827 | 89827 | 115284 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 70 Lurline St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 773684 | 5991870.1 | 2105051.8 | 37.759603333604296 | -122.47120551241301 | (37.7596033336043, -122.471205512413) | |||
| 95425 | 95425 | 95560 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 708 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767354 | 6001217.0 | 2102264.0 | 37.75248492744 | -122.438679572623 | (37.75248492744, -122.438679572623) | |
| 95652 | 95652 | 34442 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 51 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38186 | 6002033.25369179 | 2096285.02553427 | 37.736114468900105 | -122.435429168133 | (37.7361144689001, -122.435429168133) | ||
| 108966 | 108966 | 97547 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 90X Valparaiso St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 769183 | 6008640.0 | 2119879.0 | 37.8012710279062 | -122.4142556975 | (37.8012710279062, -122.4142556975) | ||
| 111108 | 111108 | 67995 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 242 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31720 | 5994595.75102873 | 2089048.56400841 | 37.7158196896579 | -122.460619224226 | (37.7158196896579, -122.460619224226) | ||
| 111117 | 111117 | 93143 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 249 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5990845.47769 | 2113717.02599 | 37.783336368979995 | -122.47538179383801 | (37.78333636898, -122.475381793838) | |||
| 112611 | 112611 | 34408 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 153 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2005 12:00:00 AM | Permit Number 48126 | 6004564.73535669 | 2097520.70439989 | 37.7396508092604 | -122.426764774135 | (37.7396508092604, -122.426764774135) | ||
| 123523 | 123523 | 115283 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 70 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 773684 | 5991870.1 | 2105051.8 | 37.759603333604296 | -122.47120551241301 | (37.7596033336043, -122.471205512413) | |||
| 126493 | 126493 | 108504 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 1445 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773649 | 5991782.44635 | 2105596.59043 | 37.7610941136514 | -122.47154835850401 | (37.7610941136514, -122.471548358504) |
| 141179 | 141179 | 89097 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 555 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990302.8549 | 2111587.58399 | 37.77745804397411 | -122.477103374633 | (37.7774580439741, -122.477103374633) | ||
| 141419 | 141419 | 49471 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 3328@ VALENCIA 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/2003 12:00:00 AM | Permit Number 46396 | 6006136.25469951 | 2103196.12306543 | 37.7553229433082 | -122.421734137516 | (37.7553229433082, -122.421734137516) | ||
| 145591 | 145591 | 108532 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 70 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773684 | 5991847.86236 | 2105069.58022 | 37.759650867089 | -122.47128371602301 | (37.759650867089, -122.471283716023) |
| 149652 | 149652 | 115009 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 118 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 2 | Permit Number 772567 | 6009049.21321 | 2093699.6892 | 37.729411653006395 | -122.410989499484 | (37.7294116530064, -122.410989499484) | ||
| 161225 | 161225 | 65923 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 102 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 4 | Permit Number 28939 | 6014289.96191 | 2112626.2206900003 | 37.7816723300522 | -122.394196132467 | (37.7816723300522, -122.394196132467) | |
| 161384 | 161384 | 51325 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 489 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2004 12:00:00 AM | 2 | Permit Number 47685 | 6013925.58695 | 2112575.54425 | 37.781512924321106 | -122.395453155354 | (37.7815129243211, -122.395453155354) | ||
| 163152 | 163152 | 42836 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 1184 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | 3 | Permit Number 42768 | 6006179.23317 | 2120408.8574599996 | 37.80258734937421 | -122.42280872257099 | (37.8025873493742, -122.422808722571) | |
| 169963 | 169963 | 82365 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 74 West View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53884 | 6007138.42533 | 2094313.10717 | 37.730988630404205 | -122.41763875034401 | (37.7309886304042, -122.417638750344) | |
| 172893 | 172893 | 53947 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 100 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 2 | Permit Number 9662 | 6010008.98982 | 2095241.8280099998 | 37.7336998129817 | -122.407780142849 | (37.7336998129817, -122.407780142849) |
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");