units_with_maps

Table actions

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

790 rows where COUNTY = 3, DES_TP = 2 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV

ACCESS_TYP 2

DES_TP 1

  • Local Park · 790 ✖
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
5 5 4 {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} Open Access 1 25 Eisenhower Park 18475 1329 Seal Beach, City of 3 City 2 City Agency 2 http://www.sealbeachca.gov/living/community/facilities/ City 2 1329 Seal Beach, City of 3 City 2 City Agency 2   Orange 3 1.46 Eisenhower Park 0 Local Park 2 4
28 28 27 {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} Open Access 1 154 El Salvador Park 18538 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 7.57 El Salvador Park 0 Local Park 2 4
126 126 125 {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} Open Access 1 318 Ensign View Park 18682 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 2.134 Ensign View Park 0 Local Park 2 4
149 149 148 {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77421, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77384, 33.85862], [-117.77368, 33.85847], [-117.77332, 33.85794], [-117.77303, 33.85744], [-117.77303, 33.85684], [-117.77418, 33.8563], [-117.77437, 33.85656], [-117.77436, 33.85678], [-117.77438, 33.8569], [-117.77443, 33.85701], [-117.77465, 33.85731], [-117.77471, 33.85734], [-117.77478, 33.85736], [-117.7749, 33.85735], [-117.77568, 33.85853]]]} Open Access 1 381 Eucalyptus Park 18740 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 9.905 Eucalyptus Park 0 Local Park 2 4
153 153 152 {"type": "Polygon", "coordinates": [[[-117.95453, 33.79354], [-117.95368, 33.79353], [-117.95366, 33.79224], [-117.9545, 33.79224], [-117.95453, 33.79354]]]} Open Access 1 483 Faylane Park 18859 1116 Garden Grove, City of 62 City 2 City Agency 2 http://www.ci.garden-grove.ca.us/commserv/recreation City 2 1116 Garden Grove, City of 60 City 2 City Agency 2   Orange 3 2.786 Faylane Park 0 Local Park 2 4
166 166 165 {"type": "Polygon", "coordinates": [[[-117.79359, 33.89318], [-117.7925, 33.89354], [-117.79204, 33.89354], [-117.79144, 33.89368], [-117.79082, 33.89369], [-117.79105, 33.89335], [-117.79115, 33.89317], [-117.79126, 33.89285], [-117.79131, 33.8926], [-117.79133, 33.89305], [-117.79295, 33.89303], [-117.79295, 33.89283], [-117.79312, 33.89283], [-117.79312, 33.89263], [-117.79317, 33.89262], [-117.79317, 33.89234], [-117.79344, 33.89233], [-117.79343, 33.89188], [-117.79357, 33.89188], [-117.79359, 33.89318]]]} Open Access 1 437 Fairmont Knolls Park 18803 1384 Yorba Linda, City of 64 City 2 City Agency 2 http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services City 2 1384 Yorba Linda, City of 62 City 2 City Agency 2   Orange 3 4.085 Fairmont Knolls Park 0 Local Park 2 4
168 168 167 {"type": "Polygon", "coordinates": [[[-117.89514, 33.614], [-117.89456, 33.61397], [-117.89358, 33.61385], [-117.8935, 33.61387], [-117.89229, 33.61421], [-117.89219, 33.61426], [-117.89104, 33.61503], [-117.89096, 33.61513], [-117.89091, 33.61526], [-117.89088, 33.61554], [-117.89077, 33.61565], [-117.89026, 33.61591], [-117.88975, 33.61562], [-117.88988, 33.61545], [-117.89005, 33.61555], [-117.89018, 33.61539], [-117.89068, 33.61565], [-117.89078, 33.61558], [-117.89081, 33.61554], [-117.89085, 33.61536], [-117.8908, 33.61528], [-117.89079, 33.61519], [-117.8908, 33.61509], [-117.89113, 33.61463], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89036, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.8898, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89076, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89433, 33.61373], [-117.89514, 33.614]]]} Open Access 1 536 Back Bay View Park 15751 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 10.648 Back Bay View Park 0 Local Park 2 4
203 203 202 {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} Open Access 1 544 Fisher Park 18919 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 3.993 Fisher Park 0 Local Park 2 4
225 225 224 {"type": "Polygon", "coordinates": [[[-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.5026], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229]]]} Open Access 1 612 Four Oaks Park 19025 1305 San Juan Capistrano, City of 92 City 2 City Agency 2 http://www.sanjuancapistrano.org/ City 2 1305 San Juan Capistrano, City of 90 City 2 City Agency 2   Orange 3 2.499 Four Oaks Park 0 Local Park 2 4
274 274 273 {"type": "Polygon", "coordinates": [[[-117.72318, 33.87548], [-117.72312, 33.87587], [-117.7229, 33.87584], [-117.72266, 33.87578], [-117.72254, 33.87582], [-117.72248, 33.87589], [-117.72204, 33.87581], [-117.72218, 33.87558], [-117.72251, 33.87523], [-117.72255, 33.87523], [-117.72297, 33.87543], [-117.72318, 33.87548]]]} Open Access 1 47365 Vista Lampara Park 31088 1384 Yorba Linda, City of 64 City 2 City Agency 2 http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services City 2 1384 Yorba Linda, City of 62 City 2 City Agency 2   Orange 3 1.193 Vista Lampara Park 0 Local Park 2 4
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
293 293 292 {"type": "Polygon", "coordinates": [[[-117.95895, 33.78192], [-117.95877, 33.78192], [-117.95878, 33.78147], [-117.95882, 33.78141], [-117.95886, 33.7814], [-117.95894, 33.7814], [-117.95895, 33.78192]]]} Open Access 1 47369 Bicentennial Park 31093 1116 Garden Grove, City of 62 City 2 City Agency 2 http://www.ci.garden-grove.ca.us/commserv/recreation City 2 1116 Garden Grove, City of 60 City 2 City Agency 2   Orange 3 0.219 Bicentennial Park 0 Local Park 2 4
299 299 298 {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} Open Access 1 803 Galaxy View Park 19171 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.948 Galaxy View Park 0 Local Park 2 4
305 305 304 {"type": "Polygon", "coordinates": [[[-118.01213, 33.73489], [-118.01191, 33.73503], [-118.01177, 33.73516], [-118.0117, 33.73525], [-118.01163, 33.7355], [-118.01163, 33.73585], [-118.01122, 33.73585], [-118.01119, 33.73402], [-118.01212, 33.73402], [-118.01213, 33.73489]]]} Open Access 1 1042 Glen View Park 19325 1141 Huntington Beach, City of 125 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 1141 Huntington Beach, City of 122 City 2 City Agency 2   Orange 3 3.31 Glen View Park 0 Local Park 2 4
329 329 328 {"type": "MultiPolygon", "coordinates": [[[[-117.66596, 33.50768], [-117.66577, 33.5077], [-117.66572, 33.50768], [-117.66541, 33.50707], [-117.66567, 33.50698], [-117.66596, 33.50768]]], [[[-117.66901, 33.51494], [-117.66882, 33.51458], [-117.66808, 33.51326], [-117.66775, 33.51256], [-117.6669, 33.5106], [-117.66646, 33.50942], [-117.66623, 33.50895], [-117.6658, 33.50793], [-117.66583, 33.50788], [-117.66603, 33.50784], [-117.66648, 33.50895], [-117.66686, 33.50979], [-117.66745, 33.51124], [-117.66772, 33.51189], [-117.66779, 33.512], [-117.66792, 33.5123], [-117.66884, 33.51451], [-117.66901, 33.51494]]]]} Open Access 1 1112 El Camino Real Park 18482 1305 San Juan Capistrano, City of 92 City 2 City Agency 2 http://www.sanjuancapistrano.org/ City 2 1305 San Juan Capistrano, City of 90 City 2 City Agency 2   Orange 3 4.569 El Camino Real Park 0 Local Park 2 4
330 330 329 {"type": "Polygon", "coordinates": [[[-117.67006, 33.45754], [-117.67005, 33.45792], [-117.66979, 33.45796], [-117.66978, 33.45783], [-117.66974, 33.45773], [-117.66967, 33.45761], [-117.66935, 33.45735], [-117.66951, 33.45716], [-117.67006, 33.45754]]]} Open Access 1 887 Palisades Gazebo Park 23328 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.658 Palisades Gazebo Park 0 Local Park 2 4
334 334 333 {"type": "Polygon", "coordinates": [[[-118.01117, 33.86901], [-118.00852, 33.86905], [-118.0085, 33.86928], [-118.00512, 33.86932], [-118.00511, 33.86863], [-118.0042, 33.86862], [-118.0042, 33.86848], [-118.00834, 33.86842], [-118.00833, 33.86716], [-118.01114, 33.86713], [-118.01117, 33.86901]]]} Open Access 1 913 George Bellis Park 19259 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 20.977 George Bellis Park 0 Local Park 2 4
349 349 348 {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81369, 33.75976], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} Open Access 1 959 Holderman Park 20027 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 0.281 Holderman Park 0 Local Park 2 4
376 376 375 {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.77031], [-118.01061, 33.77047], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} Open Access 1 1108 Goldenwest Park 19378 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 1.77 Goldenwest Park 0 Local Park 2 4
386 386 385 {"type": "Polygon", "coordinates": [[[-118.05417, 33.72241], [-118.05416, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72108], [-118.05364, 33.72069], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241]]]} Open Access 1 1408 Harbour View Park 19671 1141 Huntington Beach, City of 125 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 1141 Huntington Beach, City of 122 City 2 City Agency 2   Orange 3 3.406 Harbour View 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]);