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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18000 | 18000 | 62553 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 932 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.77241623268171 | -122.436140888716 | (37.7724162326817, -122.436140888716) | ||
| 19615 | 19615 | 62550 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 851 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468696999 | (37.7724466097716, -122.43474468697) | ||
| 20389 | 20389 | 62561 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | ||
| 57978 | 57978 | 71993 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 20 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | ||
| 82454 | 82454 | 63210 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23753 | 5984371.56597884 | 2113133.02236934 | 37.7813554779566 | -122.497735487323 | (37.7813554779566, -122.497735487323) | ||
| 83780 | 83780 | 74217 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 10 | 5989626.45991 | 2114449.60046 | 37.785277076979796 | -122.47965268471701 | (37.7852770769798, -122.479652684717) | ||
| 85992 | 85992 | 62564 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 401 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22765 | 6001708.19271751 | 2109769.06982879 | 37.7731199456311 | -122.437518353384 | (37.7731199456311, -122.437518353384) | ||
| 88830 | 88830 | 56310 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21650 | 5993077.11990526 | 2114307.36148956 | 37.7850863731263 | -122.467704208587 | (37.7850863731263, -122.467704208587) | ||
| 89303 | 89303 | 64732 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.77142047705029 | -122.43721227336701 | (37.7714204770503, -122.437212273367) | ||
| 91149 | 91149 | 62544 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.771250979895704 | -122.43714042967301 | (37.7712509798957, -122.437140429673) | ||
| 93509 | 93509 | 62552 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 925 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22749 | 6002145.34756636 | 2109458.3701838003 | 37.7722916859717 | -122.435983944483 | (37.7722916859717, -122.435983944483) | ||
| 95422 | 95422 | 65918 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1346 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28933 | 5994594.09113824 | 2106359.56698751 | 37.763351309716604 | -122.46187948930901 | (37.7633513097166, -122.461879489309) | ||
| 100519 | 100519 | 62546 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.43714730421101 | (37.7724587144958, -122.437147304211) | ||
| 104616 | 104616 | 63746 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 963 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24418 | 6001968.69414602 | 2109433.58921739 | 37.772213606480605 | -122.43659322947201 | (37.7722136064806, -122.436593229472) | ||
| 104951 | 104951 | 62548 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | ||
| 107394 | 107394 | 59644 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 865 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22747 | 6002440.7343378 | 2109498.78550878 | 37.772419432694505 | -122.434965067297 | (37.7724194326945, -122.434965067297) | ||
| 108904 | 108904 | 62556 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1009 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22755 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
| 109306 | 109306 | 62558 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 240 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1992 12:00:00 AM | Permit Number 30458 | 6002321.70129221 | 2109304.4334506 | 37.771879030768 | -122.43536290851999 | (37.771879030768, -122.43536290852) | ||
| 109387 | 109387 | 65122 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 328 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27092 | 5989675.82756959 | 2113141.97698014 | 37.7816895771658 | -122.47938619127399 | (37.7816895771658, -122.479386191274) | ||
| 112106 | 112106 | 35038 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 955 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38604 | 6002005.88434069 | 2109438.80626308 | 37.772230044530396 | -122.436464959051 | (37.7722300445304, -122.436464959051) | ||
| 113489 | 113489 | 34853 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 85 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/1997 12:00:00 AM | Permit Number 38476 | 6001445.41488356 | 2093713.29123004 | 37.7290196763486 | -122.437277475077 | (37.7290196763486, -122.437277475077) | ||
| 118552 | 118552 | 62554 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 950 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22751 | 6002017.25559301 | 2109492.91057277 | 37.772379247666 | -122.436429497983 | (37.772379247666, -122.436429497983) | ||
| 118915 | 118915 | 62557 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 231 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22756 | 6002274.80033002 | 2109264.35337792 | 37.7717663171547 | -122.435522274291 | (37.7717663171547, -122.435522274291) | ||
| 120126 | 120126 | 63217 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3621 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23761 | 5984312.74399006 | 2113130.81658791 | 37.78134597315321 | -122.497938816629 | (37.7813459731532, -122.497938816629) | ||
| 121421 | 121421 | 61492 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 171 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/1984 12:00:00 AM | Permit Number 21441 | 5989584.76357215 | 2114231.48161607 | 37.7846757617561 | -122.479780973493 | (37.7846757617561, -122.479780973493) | ||
| 121534 | 121534 | 62547 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 339 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22742 | 6001725.06048849 | 2109561.60697562 | 37.772551263359 | -122.43744514665 | (37.772551263359, -122.43744514665) | ||
| 121565 | 121565 | 63206 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3641 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23748 | 5984253.92200128 | 2113128.61080648 | 37.7813364679992 | -122.498142145884 | (37.7813364679992, -122.498142145884) | ||
| 125223 | 125223 | 65914 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 431 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28924 | 5994447.75768828 | 2106990.5338514 | 37.7650753550186 | -122.462431373492 | (37.7650753550186, -122.462431373492) | ||
| 125545 | 125545 | 62551 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 873 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | ||
| 137956 | 137956 | 72077 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 12 | 5989623.30395 | 2114484.58501 | 37.785372951377894 | -122.479666163956 | (37.7853729513779, -122.479666163956) | ||
| 138273 | 138273 | 34992 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 829 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/17/2000 12:00:00 AM | Permit Number 38570 | 5998631.01806421 | 2107405.55103252 | 37.7664548933778 | -122.447992448577 | (37.7664548933778, -122.447992448577) | ||
| 140069 | 140069 | 36668 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 973 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39474 | 6001922.20638095 | 2109427.06790723 | 37.7721930587125 | -122.436753567493 | (37.7721930587125, -122.436753567493) | ||
| 141389 | 141389 | 61500 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 155 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | Permit Number 21453 | 5989580.98367675 | 2114335.37160458 | 37.784960794856 | -122.47980165523799 | (37.784960794856, -122.479801655238) | ||
| 142959 | 142959 | 62555 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 968 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22753 | 6001933.57765066 | 2109481.17221936 | 37.7723422619436 | -122.43671810696199 | (37.7723422619436, -122.436718106962) | ||
| 143512 | 143512 | 53569 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1988 12:00:00 AM | Permit Number 6489 | 6002262.08955542 | 2108831.48537983 | 37.7705770468004 | -122.435535269571 | (37.7705770468004, -122.435535269571) | ||
| 180699 | 180699 | 74002 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 7 | 5989624.30976 | 2114465.1650799997 | 37.785319688143396 | -122.47966126275 | (37.7853196881434, -122.47966126275) |
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");