home

sf-trees

Data source: data.sfgov.org

Custom SQL query

PlantType

id, value

3 rows

Street_Tree_List

TreeID, qLegalStatus, qSpecies, qAddress, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant...

189,144 rows

qCareAssistant

id, value

15 rows

qCaretaker

id, value

21 rows

qLegalStatus

id, value

9 rows

qSiteInfo

id, value

31 rows

qSpecies

id, value

562 rows

Street_Tree_List_fts (hidden)

qLegalStatus, qSpecies, qAddress, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PermitNotes

189,144 rows

Street_Tree_List_fts_docsize (hidden)

docid, size

189,144 rows

Street_Tree_List_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

5 rows

Street_Tree_List_fts_segments (hidden)

blockid, block

1,570 rows

Street_Tree_List_fts_stat (hidden)

id, value

1 row

Download SQLite DB: sf-trees.db

Powered by Datasette · Query took 0.057ms · Data source: data.sfgov.org