home

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...

191,550 rows

qCareAssistant

id, value

15 rows

qCaretaker

id, value

22 rows

qLegalStatus

id, value

9 rows

qSiteInfo

id, value

31 rows

qSpecies

id, value

568 rows

PlantType_value_fts (hidden)

value

3 rows

PlantType_value_fts_docsize (hidden)

docid, size

3 rows

PlantType_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

PlantType_value_fts_segments (hidden)

blockid, block

0 rows

PlantType_value_fts_stat (hidden)

id, value

1 row

Street_Tree_List_fts (hidden)

qAddress, qSpecies

191,550 rows

Street_Tree_List_fts_docsize (hidden)

docid, size

191,550 rows

Street_Tree_List_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

8 rows

Street_Tree_List_fts_segments (hidden)

blockid, block

1,465 rows

Street_Tree_List_fts_stat (hidden)

id, value

1 row

qCareAssistant_value_fts (hidden)

value

15 rows

qCareAssistant_value_fts_docsize (hidden)

docid, size

15 rows

qCareAssistant_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

qCareAssistant_value_fts_segments (hidden)

blockid, block

0 rows

qCareAssistant_value_fts_stat (hidden)

id, value

1 row

qCaretaker_value_fts (hidden)

value

22 rows

qCaretaker_value_fts_docsize (hidden)

docid, size

22 rows

qCaretaker_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

qCaretaker_value_fts_segments (hidden)

blockid, block

0 rows

qCaretaker_value_fts_stat (hidden)

id, value

1 row

qLegalStatus_value_fts (hidden)

value

9 rows

qLegalStatus_value_fts_docsize (hidden)

docid, size

9 rows

qLegalStatus_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

qLegalStatus_value_fts_segments (hidden)

blockid, block

0 rows

qLegalStatus_value_fts_stat (hidden)

id, value

1 row

qSiteInfo_value_fts (hidden)

value

31 rows

qSiteInfo_value_fts_docsize (hidden)

docid, size

31 rows

qSiteInfo_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

qSiteInfo_value_fts_segments (hidden)

blockid, block

0 rows

qSiteInfo_value_fts_stat (hidden)

id, value

1 row

qSpecies_value_fts (hidden)

value

568 rows

qSpecies_value_fts_docsize (hidden)

docid, size

568 rows

qSpecies_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

qSpecies_value_fts_segments (hidden)

blockid, block

5 rows

qSpecies_value_fts_stat (hidden)

id, value

1 row

Download SQLite DB: trees.db

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