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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
| 48592 | 48592 | 63207 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3633 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23749 | 5984209.30853 | 2113126.2552799997 | 37.7813273844972 | -122.498296310267 | (37.7813273844972, -122.498296310267) | |
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 75879 | 75879 | 35907 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2295 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 14 | Permit Number 39091 | 6011293.56173 | 2098002.1271 | 37.7413508375758 | -122.403533112479 | (37.7413508375758, -122.403533112479) | |
| 76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
| 78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 123095 | 123095 | 63455 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 746 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28489 | 6007346.89818679 | 2095405.54054849 | 37.7339999430548 | -122.41699539620001 | (37.7339999430548, -122.4169953962) | ||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 139715 | 139715 | 32413 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 153246 | 153246 | 69457 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 19 | 3x3 | Permit Number 33567 | 5985660.203509999 | 2112573.9841400003 | 37.7798959764685 | -122.493236296991 | (37.7798959764685, -122.493236296991) |
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 177905 | 177905 | 43789 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 121 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43419 | 5988953.60454 | 2114542.0898700003 | 37.7854919174236 | -122.481987309149 | (37.7854919174236, -122.481987309149) |
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");