units_with_maps

Table actions

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

7 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 52

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Newport Beach, City of · 7 ✖

DES_TP 1

  • Local Recreation Area · 7 ✖

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
4093 4093 4092 {"type": "Polygon", "coordinates": [[[-117.90419, 33.63263], [-117.90311, 33.63371], [-117.90243, 33.63323], [-117.90214, 33.63297], [-117.90198, 33.63277], [-117.90184, 33.63256], [-117.90169, 33.63222], [-117.90161, 33.63187], [-117.90159, 33.63163], [-117.90196, 33.6316], [-117.90221, 33.63156], [-117.90352, 33.63246], [-117.90368, 33.63231], [-117.90419, 33.63263]]]} Open Access 1 47498 Mariners Park and VJ Community Center 31213 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 7.141 Mariners Park and VJ Community Ctr. 0 Local Recreation Area 3 4
5227 5227 5226 {"type": "Polygon", "coordinates": [[[-117.86524, 33.60879], [-117.86483, 33.60907], [-117.86416, 33.6095], [-117.86411, 33.60951], [-117.86405, 33.60949], [-117.86372, 33.60917], [-117.86319, 33.60873], [-117.86378, 33.60813], [-117.86428, 33.60812], [-117.86524, 33.60879]]]} Open Access 1 47423 San Joaquin Hills Park and Lawn Bowling Center 31139 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 4.07 San Joaquin Hills Park and Lawn Bowling Ctr. 0 Local Recreation Area 3 4
6613 6613 6612 {"type": "Polygon", "coordinates": [[[-117.86382, 33.60982], [-117.86172, 33.61131], [-117.86129, 33.61119], [-117.86101, 33.61109], [-117.86082, 33.61098], [-117.86122, 33.6105], [-117.86108, 33.6102], [-117.86144, 33.6101], [-117.86202, 33.60937], [-117.86076, 33.60849], [-117.8612, 33.60805], [-117.86152, 33.60818], [-117.86184, 33.60833], [-117.86257, 33.60876], [-117.86318, 33.6092], [-117.86358, 33.60957], [-117.86382, 33.60982]]]} Open Access 1 4178 Lincoln Athletic Center 21246 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 11.879 Lincoln Athletic Ctr. 0 Local Recreation Area 3 4
6714 6714 6713 {"type": "Polygon", "coordinates": [[[-117.89547, 33.62507], [-117.89512, 33.62537], [-117.89455, 33.62546], [-117.89418, 33.62594], [-117.89326, 33.6255], [-117.89307, 33.62508], [-117.89331, 33.6246], [-117.89335, 33.62458], [-117.89391, 33.62465], [-117.89473, 33.62505], [-117.8949, 33.62511], [-117.895, 33.62513], [-117.89516, 33.6251], [-117.89533, 33.62496], [-117.89547, 33.62507]]]} Open Access 1 5667 Newport Aquatic Center 22732 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 4.173 Newport Aquatic Ctr. 0 Local Recreation Area 3 4
7710 7710 7709 {"type": "MultiPolygon", "coordinates": [[[[-117.85528, 33.62737], [-117.85512, 33.62771], [-117.85493, 33.62817], [-117.85485, 33.62821], [-117.85431, 33.62807], [-117.85385, 33.62797], [-117.85346, 33.62791], [-117.85297, 33.62786], [-117.85262, 33.62785], [-117.85196, 33.62787], [-117.85144, 33.62793], [-117.85086, 33.62804], [-117.84982, 33.6283], [-117.84977, 33.62827], [-117.84956, 33.6274], [-117.8496, 33.62734], [-117.85038, 33.62707], [-117.85038, 33.62705], [-117.85084, 33.62693], [-117.85128, 33.62684], [-117.85167, 33.62679], [-117.85241, 33.62675], [-117.8531, 33.62677], [-117.85392, 33.62689], [-117.8541, 33.62692], [-117.85442, 33.627], [-117.85523, 33.62726], [-117.85528, 33.62737]]], [[[-117.86099, 33.62921], [-117.85988, 33.62926], [-117.85987, 33.62924], [-117.85905, 33.62926], [-117.85843, 33.62921], [-117.85801, 33.62915], [-117.858, 33.62917], [-117.85748, 33.62906], [-117.85688, 33.62887], [-117.85641, 33.6287], [-117.85616, 33.62859], [-117.85537, 33.62835], [-117.85528, 33.62827], [-117.85563, 33.62746], [-117.85574, 33.62742], [-117.85622, 33.62759], [-117.85778, 33.6279], [-117.85833, 33.62799], [-117.85992, 33.62813], [-117.85963, 33.62876], [-117.86099, 33.62921]]], [[[-117.86191, 33.62918], [-117.86118, 33.62842], [-117.86097, 33.62823], [-117.86069, 33.62805], [-117.86033, 33.62792], [-117.86016, 33.62788], [-117.86035, 33.62761], [-117.86067, 33.62697], [-117.86081, 33.62647], [-117.86078, 33.62612], [-117.86074, 33.62521], [-117.86068, 33.62474], [-117.86023, 33.62329], [-117.86013, 33.62198], [-117.86037, 33.62199], [-117.86042, 33.62174], [-117.86048, 33.62129], [-117.86055, 33.62104], [-117.8603, 33.62065], [-117.86052, 33.62055], [-117.86071, 33.62036], [-117.86076, 33.62029], [-117.86084, 33.6201], [-117.86093, 33.6198], [-117.86147, 33.61991], [-117.86116, 33.62058], [-117.86105, 33.62093], [-117.86089, 33.62157], [-117.86083, 33.62201], [-117.8608, 33.62277], [-117.86083, 33.62325], [-117.86092, 33.6238], [-117.86102, 33.62428], [-117.86131, 33.62535], [-117.86158, 33.62667], [-117.86184, 33.62781], [-117.86212, 33.62888], [-117.86212, 33.62902], [-117.8621, 33.62908], [-117.86201, 33.62915], [-117.86191, 33.62918]]]]} Open Access 1 7785 Bonita Canyon Sports Park 16258 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 44.715 Bonita Canyon Sports Park 0 Local Recreation Area 3 4
8844 8844 8843 {"type": "Polygon", "coordinates": [[[-117.89841, 33.60599], [-117.89815, 33.60629], [-117.89792, 33.60615], [-117.89821, 33.60581], [-117.89841, 33.60599]]]} Open Access 1 14438 Balboa Island Park at Carroll Beek Community Center 15771 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 0.279 Balboa Island Park at Carroll Beek Community Ctr. 0 Local Recreation Area 3 4
14510 14510 14509 {"type": "Polygon", "coordinates": [[[-117.86267, 33.64909], [-117.86194, 33.64709], [-117.86197, 33.64568], [-117.862, 33.64568], [-117.862, 33.64573], [-117.86204, 33.64578], [-117.86211, 33.64582], [-117.86267, 33.64583], [-117.86309, 33.6458], [-117.86336, 33.64575], [-117.86363, 33.64567], [-117.86368, 33.64567], [-117.86372, 33.6457], [-117.8638, 33.64593], [-117.86392, 33.64669], [-117.86398, 33.64689], [-117.86406, 33.64708], [-117.86447, 33.64777], [-117.86448, 33.64781], [-117.86446, 33.64784], [-117.86439, 33.64789], [-117.86428, 33.64793], [-117.86413, 33.64804], [-117.86405, 33.64814], [-117.86313, 33.6488], [-117.86267, 33.64909]]]} Open Access 1 47406 Bonita Creek Park and Community Center 31123 1224 Newport Beach, City of 54 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 1224 Newport Beach, City of 52 City 2 City Agency 2   Orange 3 14.269 Bonita Creek Park and Community Ctr. 0 Local Recreation Area 3 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]);