units_with_maps

Table actions

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

2 rows where DES_TP = 2, LAYER = 4 and YR_EST = 2000

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 2

ACCESS_TYP 2

DES_TP 1

  • Local Park · 2 ✖
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
3237 3237 3236 {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} Restricted Access 2 48110 Sunflower Park 32835 2422 El Centro Elementary School District 602 Special District 4 School District 14 www.ecesd.org Special District 4 1093 El Centro, City of 92 City 2 City Agency 2 http://www.cityofelcentro.org Imperial 20 18.451 Sunflower Park 2000 Local Park 2 4
10018 10018 10017 {"type": "Polygon", "coordinates": [[[-122.03765, 38.49876], [-122.03721, 38.49835], [-122.03564, 38.49724], [-122.03484, 38.49684], [-122.03469, 38.4967], [-122.03412, 38.4963], [-122.03367, 38.49607], [-122.03339, 38.49582], [-122.03212, 38.49502], [-122.03074, 38.49442], [-122.03003, 38.49422], [-122.02894, 38.49368], [-122.02811, 38.4932], [-122.02771, 38.493], [-122.02722, 38.49292], [-122.02461, 38.49263], [-122.02426, 38.49248], [-122.02391, 38.49215], [-122.02324, 38.49176], [-122.02279, 38.4914], [-122.02207, 38.49109], [-122.02168, 38.49098], [-122.02141, 38.49063], [-122.02107, 38.49048], [-122.02081, 38.49028], [-122.02032, 38.48997], [-122.02062, 38.48927], [-122.02073, 38.48883], [-122.02125, 38.48913], [-122.02143, 38.48916], [-122.02174, 38.48929], [-122.02201, 38.48943], [-122.02279, 38.48968], [-122.02314, 38.48984], [-122.02384, 38.49003], [-122.02431, 38.49022], [-122.02482, 38.49053], [-122.02565, 38.49095], [-122.02623, 38.49029], [-122.02608, 38.48995], [-122.02557, 38.48914], [-122.0262, 38.4891], [-122.02719, 38.48912], [-122.0285, 38.48911], [-122.0294, 38.48918], [-122.03036, 38.48919], [-122.03016, 38.48966], [-122.03006, 38.49023], [-122.02969, 38.49069], [-122.02974, 38.49095], [-122.02965, 38.49127], [-122.03049, 38.49266], [-122.03086, 38.49287], [-122.0312, 38.49324], [-122.03198, 38.49353], [-122.03288, 38.49373], [-122.03315, 38.49382], [-122.03415, 38.49464], [-122.03447, 38.49508], [-122.03474, 38.49528], [-122.0362, 38.49588], [-122.0364, 38.49603], [-122.03667, 38.49668], [-122.03679, 38.49718], [-122.03681, 38.49738], [-122.03708, 38.49793], [-122.03765, 38.49876]]]} Open Access 1 17260 Lake Solano County Park 20965 2187 Solano Tri-City and County Cooperative Planning Group 74 Special District 4 Open Space District 6   Special District 4 2187 Solano Tri-City and County Cooperative Planning Group 72 Special District 4 Open Space District 6   Solano 26 90.663 Lake Solano County Park 2000 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]);