units_with_maps

Table actions

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

32 rows where COUNTY = 3, GAP_STS = 4 and MNG_AGENCY = 114

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Costa Mesa, City of · 32 ✖
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
287 287 286 {"type": "Polygon", "coordinates": [[[-117.89292, 33.66951], [-117.89279, 33.6695], [-117.89269, 33.66962], [-117.89278, 33.66984], [-117.89242, 33.66996], [-117.89271, 33.67061], [-117.89241, 33.67062], [-117.8924, 33.67015], [-117.89135, 33.67016], [-117.89223, 33.66934], [-117.89259, 33.66924], [-117.89292, 33.66924], [-117.89292, 33.66951]]]} Open Access 1 47380 Bark Park 31103 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=1207 Orange 3 2.234 Bark Park 0 Local Park 2 4
766 766 765 {"type": "Polygon", "coordinates": [[[-117.91056, 33.6321], [-117.91, 33.63265], [-117.90957, 33.63237], [-117.91011, 33.63178], [-117.91056, 33.6321]]]} Open Access 1 5657 Harper Park 19689 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 1.045 Harper Park 0 Local Park 2 4
2519 2519 2518 {"type": "Polygon", "coordinates": [[[-117.90111, 33.64326], [-117.90042, 33.64395], [-117.8996, 33.64336], [-117.9003, 33.64266], [-117.90111, 33.64326]]]} Open Access 1 20092 Jordan Park 20490 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 2.484 Jordan Park 0 Local Park 2 4
2943 2943 2942 {"type": "Polygon", "coordinates": [[[-117.9211, 33.63125], [-117.9205, 33.63183], [-117.92012, 33.63158], [-117.9199, 33.6314], [-117.91952, 33.63113], [-117.92009, 33.63056], [-117.9211, 33.63125]]]} Open Access 1 20084 Heller Park 19806 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 2.521 Heller Park 0 Local Park 2 4
2944 2944 2943 {"type": "Polygon", "coordinates": [[[-117.93472, 33.69366], [-117.93397, 33.69474], [-117.93286, 33.69432], [-117.93313, 33.69422], [-117.93323, 33.69429], [-117.93332, 33.6943], [-117.93356, 33.69417], [-117.93373, 33.69412], [-117.93387, 33.69411], [-117.93396, 33.69406], [-117.93399, 33.69402], [-117.93401, 33.69391], [-117.93472, 33.69366]]]} Open Access 1 20094 Moon Park 22449 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 1.682 Moon Park 0 Local Park 2 4
2994 2994 2993 {"type": "Polygon", "coordinates": [[[-117.9364, 33.69109], [-117.93599, 33.69171], [-117.93587, 33.69157], [-117.93559, 33.69172], [-117.93551, 33.69166], [-117.93541, 33.69167], [-117.93579, 33.69145], [-117.93609, 33.69122], [-117.93629, 33.69102], [-117.93637, 33.69105], [-117.9364, 33.69109]]]} Open Access 1 20095 Suburbia Park 25940 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 0.515 Suburbia Park 0 Local Park 2 4
3555 3555 3554 {"type": "Polygon", "coordinates": [[[-117.91502, 33.63059], [-117.91441, 33.6312], [-117.91347, 33.63056], [-117.9137, 33.63033], [-117.91372, 33.63034], [-117.9141, 33.62995], [-117.91502, 33.63059]]]} Open Access 1 8521 Pinkley Park 23698 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 2.465 Pinkley Park 0 Local Park 2 4
3701 3701 3700 {"type": "Polygon", "coordinates": [[[-117.92271, 33.6527], [-117.92269, 33.65297], [-117.92211, 33.65298], [-117.9221, 33.65273], [-117.92173, 33.65273], [-117.92171, 33.65261], [-117.92264, 33.65264], [-117.92271, 33.6527]]]} Open Access 1 30215 Ketchum-Libolt Park 20637 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 0.616 Ketchum-Libolt Park 0 Local Park 2 4
5069 5069 5068 {"type": "Polygon", "coordinates": [[[-117.92536, 33.68693], [-117.92049, 33.68692], [-117.92045, 33.68687], [-117.92044, 33.68679], [-117.92043, 33.6847], [-117.92533, 33.68468], [-117.92533, 33.68494], [-117.92536, 33.68693]]]} Open Access 1 1393 Harbor Rest Memorial Park 19665 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 27.826 Harbor Rest Memorial Park 0 Local Park 2 4
5374 5374 5373 {"type": "Polygon", "coordinates": [[[-117.9232, 33.64208], [-117.92122, 33.64211], [-117.9212, 33.63994], [-117.92319, 33.63992], [-117.9232, 33.64208]]]} Open Access 1 5700 Lions Park 21318 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 10.919 Lions Park 0 Local Park 2 4
5906 5906 5905 {"type": "Polygon", "coordinates": [[[-117.9385, 33.67267], [-117.93847, 33.67503], [-117.93841, 33.67502], [-117.93789, 33.67429], [-117.93753, 33.67395], [-117.93727, 33.67379], [-117.93692, 33.6736], [-117.93658, 33.67352], [-117.9363, 33.67352], [-117.93586, 33.6736], [-117.93572, 33.67329], [-117.93563, 33.67307], [-117.93559, 33.67289], [-117.93558, 33.67274], [-117.93563, 33.67273], [-117.93565, 33.67268], [-117.9385, 33.67267]]]} Open Access 1 361 Estancia Park 18720 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 8.831 Estancia Park 0 Local Park 2 4
6797 6797 6796 {"type": "Polygon", "coordinates": [[[-117.93311, 33.67525], [-117.93289, 33.67546], [-117.93278, 33.67564], [-117.93273, 33.67568], [-117.93241, 33.6756], [-117.93223, 33.67557], [-117.93019, 33.67538], [-117.93014, 33.67536], [-117.93022, 33.67502], [-117.93065, 33.67501], [-117.9312, 33.67508], [-117.93228, 33.67519], [-117.93311, 33.67525]]]} Open Access 1 5306 Mesa Verde Park 22179 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 2.756 Mesa Verde Park 0 Local Park 2 4
7295 7295 7294 {"type": "Polygon", "coordinates": [[[-117.90125, 33.6842], [-117.90105, 33.6842], [-117.90105, 33.68448], [-117.90086, 33.68448], [-117.90086, 33.68421], [-117.90077, 33.68421], [-117.90076, 33.68247], [-117.90123, 33.68247], [-117.90125, 33.6842]]]} Open Access 1 8122 Paularino Park 23534 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 2.231 Paularino Park 0 Local Park 2 4
7860 7860 7859 {"type": "Polygon", "coordinates": [[[-117.89382, 33.68704], [-117.89249, 33.68704], [-117.89243, 33.68687], [-117.89228, 33.68538], [-117.89228, 33.68471], [-117.89294, 33.68471], [-117.89295, 33.68543], [-117.89381, 33.68544], [-117.89381, 33.68569], [-117.89372, 33.68564], [-117.89352, 33.68565], [-117.89348, 33.68569], [-117.89347, 33.68584], [-117.89351, 33.6859], [-117.89355, 33.68592], [-117.89375, 33.68591], [-117.8938, 33.68586], [-117.89382, 33.68642], [-117.89373, 33.68637], [-117.89353, 33.68638], [-117.89348, 33.68644], [-117.89348, 33.68657], [-117.89352, 33.68664], [-117.89358, 33.68665], [-117.89374, 33.68664], [-117.89382, 33.68659], [-117.89382, 33.68704]]]} Open Access 1 12529 Shiffer Park 25410 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 6.721 Shiffer Park 0 Local Park 2 4
8677 8677 8676 {"type": "Polygon", "coordinates": [[[-117.94388, 33.65053], [-117.94298, 33.65055], [-117.94297, 33.64956], [-117.94221, 33.64903], [-117.94242, 33.64852], [-117.94219, 33.64805], [-117.94197, 33.64801], [-117.94124, 33.64827], [-117.93923, 33.6483], [-117.93923, 33.64781], [-117.93995, 33.6472], [-117.93958, 33.64674], [-117.93878, 33.64692], [-117.93835, 33.64726], [-117.93812, 33.64802], [-117.93748, 33.64796], [-117.93643, 33.64778], [-117.93643, 33.64733], [-117.93741, 33.64732], [-117.93742, 33.64661], [-117.93774, 33.64661], [-117.93777, 33.64667], [-117.93798, 33.64664], [-117.93798, 33.64661], [-117.93818, 33.6466], [-117.93816, 33.64589], [-117.93925, 33.64587], [-117.93924, 33.64524], [-117.93875, 33.64428], [-117.93875, 33.64414], [-117.93984, 33.64411], [-117.93984, 33.64505], [-117.94018, 33.6457], [-117.9409, 33.64553], [-117.94173, 33.64553], [-117.94174, 33.64781], [-117.94383, 33.64781], [-117.94388, 33.65053]]]} Open Access 1 14007 Canyon Park 16823 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 35.363 Canyon Park 0 Local Park 2 4
8927 8927 8926 {"type": "Polygon", "coordinates": [[[-117.92995, 33.67064], [-117.92995, 33.67067], [-117.92989, 33.6707], [-117.92974, 33.67077], [-117.92949, 33.67085], [-117.92907, 33.67085], [-117.92906, 33.67093], [-117.92817, 33.67094], [-117.92814, 33.66884], [-117.92882, 33.66884], [-117.9289, 33.66887], [-117.92917, 33.66905], [-117.92942, 33.66912], [-117.92946, 33.6695], [-117.92956, 33.66991], [-117.92967, 33.67017], [-117.92978, 33.67038], [-117.92995, 33.67064]]]} Open Access 1 14664 Tanager Park 26178 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 7.313 Tanager Park 0 Local Park 2 4
8931 8931 8930 {"type": "MultiPolygon", "coordinates": [[[[-117.89506, 33.66917], [-117.89502, 33.66945], [-117.89484, 33.66981], [-117.89453, 33.6701], [-117.89438, 33.67027], [-117.89424, 33.67046], [-117.89409, 33.67092], [-117.89407, 33.67114], [-117.89405, 33.67149], [-117.89236, 33.67151], [-117.89236, 33.67062], [-117.8927, 33.6706], [-117.89242, 33.66996], [-117.89278, 33.66984], [-117.89269, 33.66962], [-117.89279, 33.6695], [-117.89292, 33.66951], [-117.89292, 33.66924], [-117.89309, 33.66923], [-117.89309, 33.6691], [-117.89495, 33.66907], [-117.89506, 33.66917]]], [[[-117.8996, 33.67125], [-117.89837, 33.67127], [-117.89834, 33.67128], [-117.89831, 33.67133], [-117.89829, 33.67146], [-117.89432, 33.6715], [-117.89433, 33.67095], [-117.89438, 33.67073], [-117.89447, 33.67053], [-117.89464, 33.67028], [-117.8951, 33.66981], [-117.89518, 33.66969], [-117.89528, 33.66942], [-117.89532, 33.66918], [-117.89545, 33.66906], [-117.89958, 33.669], [-117.8996, 33.67125]]]]} Open Access 1 14677 Te Winkle Park 26208 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 40.98 Te Winkle Park 0 Local Park 2 4
10753 10753 10752 {"type": "Polygon", "coordinates": [[[-117.91515, 33.65803], [-117.91463, 33.65803], [-117.91462, 33.6573], [-117.91415, 33.6573], [-117.91414, 33.65665], [-117.91411, 33.65664], [-117.9141, 33.65627], [-117.91513, 33.65627], [-117.91515, 33.65803]]]} Open Access 1 20081 Wilson Park 27608 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 3.637 Wilson Park 0 Local Park 2 4
10762 10762 10761 {"type": "Polygon", "coordinates": [[[-117.91234, 33.68711], [-117.91234, 33.68758], [-117.91151, 33.68755], [-117.90816, 33.68727], [-117.90801, 33.68716], [-117.90801, 33.68702], [-117.90918, 33.68704], [-117.90918, 33.68714], [-117.90924, 33.68714], [-117.90926, 33.68705], [-117.91061, 33.68703], [-117.91061, 33.68712], [-117.91064, 33.68713], [-117.91066, 33.687], [-117.912, 33.68701], [-117.91201, 33.68711], [-117.91234, 33.68711]]]} Open Access 1 20073 Gisler Park 19303 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 4.354 Gisler Park 0 Local Park 2 4
10763 10763 10762 {"type": "Polygon", "coordinates": [[[-117.9008, 33.69206], [-117.90077, 33.69207], [-117.90076, 33.69241], [-117.89863, 33.69242], [-117.89863, 33.69057], [-117.90077, 33.69059], [-117.9008, 33.69206]]]} Open Access 1 20074 Wakeham Park 27212 1071 Costa Mesa, City of 117 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1071 Costa Mesa, City of 114 City 2 City Agency 2   Orange 3 10.046 Wakeham Park 0 Local Park 2 4

Next page

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