units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where AGNCY_TYP = 4, DES_TP = 2 and MNG_AGENCY = 572

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Paradise Recreation and Park District · 4 ✖

DES_TP 1

  • Local Park · 4 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
3093 3093 3092 {"type": "MultiPolygon", "coordinates": [[[[-121.61374, 39.74863], [-121.61373, 39.74885], [-121.61371, 39.74895], [-121.61363, 39.74907], [-121.61353, 39.74918], [-121.61292, 39.74964], [-121.6125, 39.74964], [-121.61251, 39.74863], [-121.61374, 39.74863]]], [[[-121.61484, 39.74863], [-121.61482, 39.74964], [-121.61323, 39.74964], [-121.61369, 39.74929], [-121.61384, 39.74913], [-121.6139, 39.74902], [-121.61393, 39.74892], [-121.61395, 39.74863], [-121.61484, 39.74863]]]]} Open Access 1 25178 Aquatic Park 15549 2250 Paradise Recreation and Park District 580 Special District 4 Recreation/Parks District 4 http://www.paradiseprpd.com/ Special District 4 2250 Paradise Recreation and Park District 572 Special District 4 Recreation/Parks District 4   Butte 42 4.914 Aquatic Park 0 Local Park 2 4
9622 9622 9621 {"type": "Polygon", "coordinates": [[[-121.63305, 39.77263], [-121.63295, 39.77264], [-121.63295, 39.77294], [-121.63122, 39.77294], [-121.63122, 39.7705], [-121.63303, 39.77051], [-121.63305, 39.77263]]]} Open Access 1 16475 Bille Park 16114 2250 Paradise Recreation and Park District 580 Special District 4 Recreation/Parks District 4 http://www.paradiseprpd.com/ Special District 4 2250 Paradise Recreation and Park District 572 Special District 4 Recreation/Parks District 4   Butte 42 10.366 Bille Park 0 Local Park 2 4
9731 9731 9730 {"type": "Polygon", "coordinates": [[[-121.59294, 39.786], [-121.59259, 39.78655], [-121.59161, 39.78859], [-121.58893, 39.7886], [-121.58894, 39.78601], [-121.59294, 39.786]]]} Open Access 1 16480 Moore Road Park 22462 2250 Paradise Recreation and Park District 580 Special District 4 Recreation/Parks District 4 http://www.paradiseprpd.com/ Special District 4 2250 Paradise Recreation and Park District 572 Special District 4 Recreation/Parks District 4   Butte 42 20.103 Moore Road Park 0 Local Park 2 4
11381 11381 11380 {"type": "Polygon", "coordinates": [[[-121.51191, 39.7646], [-121.51174, 39.76803], [-121.51098, 39.76804], [-121.51097, 39.7663], [-121.51115, 39.7646], [-121.51191, 39.7646]]]} Open Access 1 28145 Crain Memorial Park 17753 2250 Paradise Recreation and Park District 580 Special District 4 Recreation/Parks District 4 http://www.paradiseprpd.com/ Special District 4 2250 Paradise Recreation and Park District 572 Special District 4 Recreation/Parks District 4   Butte 42 6.572 Crain Memorial Park 0 Local Park 2 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);