superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, MNG_AGENCY = 1009 and MNG_AG_TYP = 15

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Home Owners Association · 3 ✖

MNG_AGENCY 1

  • Turtle Rock Broadmoor Community Association · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
365 365 364 {"type": "Polygon", "coordinates": [[[-117.82121, 33.6453], [-117.82118, 33.64532], [-117.82079, 33.64543], [-117.8205, 33.64551], [-117.82045, 33.6455], [-117.82042, 33.64546], [-117.82039, 33.64537], [-117.82026, 33.64493], [-117.82024, 33.64481], [-117.82107, 33.64473], [-117.82111, 33.64476], [-117.82122, 33.64527], [-117.82121, 33.6453]]]} Restricted Access 2 Grosmont Park   31978 6026 Turtle Rock Broadmoor Community Association 1009 Private 7 Home Owners Association 15 http://turtlerockhills.com/ Private 14 1.433 Grosmont Park  
6951 6951 6950 {"type": "Polygon", "coordinates": [[[-117.82296, 33.6384], [-117.82261, 33.63889], [-117.82256, 33.63893], [-117.82252, 33.63893], [-117.82171, 33.63867], [-117.82168, 33.63864], [-117.82166, 33.63858], [-117.82177, 33.63812], [-117.82179, 33.63809], [-117.82184, 33.63808], [-117.82215, 33.6381], [-117.82248, 33.63817], [-117.82289, 33.63833], [-117.82294, 33.63836], [-117.82296, 33.6384]]]} Restricted Access 2 Mountain View Park   32336 6026 Turtle Rock Broadmoor Community Association 1009 Private 7 Home Owners Association 15 http://turtlerockhills.com/ Private 14 1.899 Mtn. View Park  
13329 13329 13328 {"type": "Polygon", "coordinates": [[[-117.82179, 33.64159], [-117.8217, 33.6419], [-117.8216, 33.64235], [-117.81974, 33.64217], [-117.81988, 33.64157], [-117.81999, 33.64118], [-117.82077, 33.64137], [-117.82179, 33.64159]]]} Restricted Access 2 Culver Park   32333 6026 Turtle Rock Broadmoor Community Association 1009 Private 7 Home Owners Association 15 http://turtlerockhills.com/ Private 14 4.222 Culver Park  

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]);