superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 129 and PARK_NAME = "City of Poway Open Space"

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Poway, City of · 2 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
14839 14839 14838 {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04502], [-117.03842, 33.04512], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03816, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03761, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04815], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03527, 33.05166], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03494, 33.05207], [-117.03495, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.03101, 33.05176], [-117.03083, 33.05169], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02966, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02986, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02999, 33.05367], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02992, 33.0543], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02959, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05039], [-117.02823, 33.05039], [-117.02836, 33.05022], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04971], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03186, 33.04408], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02935, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03684], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03104, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03548], [-117.03175, 33.03534], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.03129, 33.03386], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04406], [-117.03972, 33.04402]]]} No Public Access 3 City of Poway Open Space   17327 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 193.997 City of Poway OS  
14840 14840 14839 {"type": "MultiPolygon", "coordinates": [[[[-117.0238, 32.94716], [-117.02334, 32.94716], [-117.02334, 32.94677], [-117.02334, 32.94677], [-117.0238, 32.94716]]], [[[-117.02744, 32.94658], [-117.02719, 32.94638], [-117.02698, 32.94608], [-117.02686, 32.94597], [-117.02666, 32.94591], [-117.02636, 32.94586], [-117.02634, 32.94595], [-117.02591, 32.94584], [-117.02519, 32.94576], [-117.02517, 32.94566], [-117.02466, 32.94565], [-117.02464, 32.94555], [-117.02432, 32.94554], [-117.0241, 32.94551], [-117.02409, 32.94572], [-117.02373, 32.94561], [-117.02335, 32.94552], [-117.02335, 32.94532], [-117.02743, 32.94536], [-117.02744, 32.94658]]]]} Open Access 1 City of Poway Open Space   17328 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 5.1 City of Poway OS  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);