units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1, AGNCY_NAME = 233, DES_TP = 2 and MNG_AGENCY = 229

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Brea, City of · 10 ✖

DES_TP 1

  • Local Park · 10 ✖

ACCESS_TYP 1

  • Open Access · 10 ✖
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
662 662 661 {"type": "Polygon", "coordinates": [[[-117.89727, 33.91708], [-117.89707, 33.91745], [-117.89698, 33.9175], [-117.89608, 33.91752], [-117.89608, 33.91692], [-117.89678, 33.91691], [-117.89679, 33.91708], [-117.89727, 33.91708]]]} Open Access 1 3273 Lagos De Moreno Park 20844 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 1.461 Lagos De Moreno Park 0 Local Park 2 4
6177 6177 6176 {"type": "MultiPolygon", "coordinates": [[[[-117.8775, 33.91422], [-117.87732, 33.91439], [-117.87723, 33.91456], [-117.87719, 33.9147], [-117.87705, 33.91547], [-117.877, 33.91558], [-117.87695, 33.91564], [-117.87684, 33.91572], [-117.87675, 33.91577], [-117.8765, 33.91584], [-117.87666, 33.91523], [-117.87683, 33.91489], [-117.87699, 33.91466], [-117.87709, 33.91455], [-117.87722, 33.91443], [-117.8775, 33.91422]]], [[[-117.87909, 33.91436], [-117.87878, 33.9149], [-117.87849, 33.91478], [-117.87832, 33.91481], [-117.87806, 33.9149], [-117.87787, 33.915], [-117.87776, 33.91508], [-117.8776, 33.91527], [-117.8775, 33.91542], [-117.87746, 33.91542], [-117.87758, 33.91475], [-117.87761, 33.91466], [-117.87767, 33.91455], [-117.8778, 33.91445], [-117.87852, 33.91403], [-117.87869, 33.91418], [-117.8788, 33.91425], [-117.87892, 33.9143], [-117.87909, 33.91436]]]]} Open Access 1 1207 Greenbriar Park 19475 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 3.487 Greenbriar Park 0 Local Park 2 4
9287 9287 9286 {"type": "Polygon", "coordinates": [[[-117.91198, 33.94546], [-117.91169, 33.9456], [-117.91163, 33.94581], [-117.91132, 33.94575], [-117.9114, 33.94543], [-117.91137, 33.94537], [-117.91102, 33.94531], [-117.91107, 33.94526], [-117.91151, 33.94534], [-117.91164, 33.94544], [-117.91191, 33.94536], [-117.91198, 33.94546]]]} Open Access 1 15471 Woodcrest Park 27705 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 0.477 Woodcrest Park 0 Local Park 2 4
9482 9482 9481 {"type": "Polygon", "coordinates": [[[-117.90314, 33.91356], [-117.90225, 33.91519], [-117.90138, 33.91486], [-117.90226, 33.91323], [-117.90314, 33.91356]]]} Open Access 1 15881 City Hall Park 17294 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 4.345 City Hall Park 0 Local Park 2 4
10321 10321 10320 {"type": "Polygon", "coordinates": [[[-117.87137, 33.92129], [-117.87131, 33.92148], [-117.87099, 33.92206], [-117.87051, 33.9221], [-117.87025, 33.92207], [-117.86998, 33.92199], [-117.86981, 33.9219], [-117.8696, 33.92171], [-117.86953, 33.92161], [-117.86944, 33.92142], [-117.86941, 33.92127], [-117.86941, 33.9211], [-117.86945, 33.92097], [-117.86963, 33.92052], [-117.86966, 33.92029], [-117.86962, 33.92001], [-117.86963, 33.91997], [-117.86968, 33.91994], [-117.86994, 33.91986], [-117.87008, 33.91984], [-117.87041, 33.91971], [-117.87054, 33.91974], [-117.87069, 33.91991], [-117.87059, 33.91997], [-117.87017, 33.92002], [-117.86984, 33.9204], [-117.87065, 33.9209], [-117.87073, 33.92089], [-117.87137, 33.92129]]]} Open Access 1 18180 Country Hills Park 17698 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 6.38 Country Hills Park 0 Local Park 2 4
10347 10347 10346 {"type": "MultiPolygon", "coordinates": [[[[-117.90883, 33.9129], [-117.90847, 33.91348], [-117.90806, 33.91392], [-117.90793, 33.91408], [-117.90779, 33.91432], [-117.90776, 33.91459], [-117.90815, 33.91469], [-117.90844, 33.91507], [-117.90845, 33.91536], [-117.90821, 33.91575], [-117.9082, 33.91597], [-117.90787, 33.91616], [-117.90753, 33.91628], [-117.90695, 33.91639], [-117.90685, 33.91639], [-117.90685, 33.91667], [-117.90669, 33.91678], [-117.90649, 33.91684], [-117.90633, 33.91705], [-117.9063, 33.91728], [-117.90581, 33.91729], [-117.90602, 33.91691], [-117.90722, 33.91455], [-117.90737, 33.91427], [-117.90828, 33.9129], [-117.90883, 33.9129]]], [[[-117.908, 33.91291], [-117.90715, 33.91418], [-117.90699, 33.91446], [-117.90593, 33.91656], [-117.9059, 33.91654], [-117.90642, 33.91548], [-117.90618, 33.91425], [-117.90636, 33.91391], [-117.9067, 33.91374], [-117.90688, 33.91358], [-117.90689, 33.91291], [-117.908, 33.91291]]]]} Open Access 1 18267 Arovista Park 15605 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 14.5 Arovista Park 0 Local Park 2 4
10752 10752 10751 {"type": "Polygon", "coordinates": [[[-117.90008, 33.925], [-117.90001, 33.92741], [-117.89888, 33.92739], [-117.89846, 33.92719], [-117.89999, 33.92493], [-117.90002, 33.92493], [-117.90008, 33.925]]]} Open Access 1 20024 Tamarack Park 26176 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 5.452 Tamarack Park 0 Local Park 2 4
10755 10755 10754 {"type": "Polygon", "coordinates": [[[-117.84753, 33.9245], [-117.84711, 33.92449], [-117.84698, 33.92442], [-117.84687, 33.9244], [-117.84639, 33.92444], [-117.84634, 33.92447], [-117.84573, 33.92446], [-117.84572, 33.9245], [-117.84543, 33.92449], [-117.84542, 33.92442], [-117.84454, 33.92443], [-117.84452, 33.92441], [-117.84427, 33.92441], [-117.84412, 33.92448], [-117.84176, 33.92442], [-117.84169, 33.92446], [-117.8416, 33.9244], [-117.84152, 33.92439], [-117.84144, 33.92442], [-117.84138, 33.92437], [-117.84106, 33.9244], [-117.84103, 33.92464], [-117.84053, 33.92444], [-117.83931, 33.92407], [-117.83925, 33.92419], [-117.8392, 33.92401], [-117.83892, 33.92379], [-117.83873, 33.9237], [-117.8386, 33.92366], [-117.83862, 33.92361], [-117.83791, 33.92341], [-117.83725, 33.9233], [-117.83677, 33.92325], [-117.83691, 33.9231], [-117.83699, 33.92298], [-117.83705, 33.92281], [-117.83708, 33.92263], [-117.83729, 33.92265], [-117.83732, 33.92256], [-117.83758, 33.9226], [-117.83863, 33.92279], [-117.8391, 33.92291], [-117.84061, 33.92338], [-117.84151, 33.92368], [-117.84248, 33.92389], [-117.84321, 33.92399], [-117.84566, 33.92424], [-117.8467, 33.92428], [-117.84742, 33.92429], [-117.84752, 33.92435], [-117.84753, 33.9245]]]} Open Access 1 20031 Olinda Ranch Park 23116 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 16.006 Olinda Ranch Park 0 Local Park 2 4
10756 10756 10755 {"type": "Polygon", "coordinates": [[[-117.90928, 33.93405], [-117.90849, 33.93406], [-117.90848, 33.93403], [-117.9083, 33.93403], [-117.90829, 33.93406], [-117.90816, 33.93406], [-117.90815, 33.93403], [-117.90797, 33.93403], [-117.90796, 33.93407], [-117.90721, 33.93407], [-117.90711, 33.93404], [-117.907, 33.93395], [-117.90697, 33.9339], [-117.90699, 33.93382], [-117.90697, 33.93374], [-117.90701, 33.93366], [-117.90706, 33.93361], [-117.90722, 33.93355], [-117.90791, 33.93354], [-117.90792, 33.93357], [-117.90812, 33.93357], [-117.90813, 33.93354], [-117.90824, 33.93354], [-117.90825, 33.93357], [-117.90843, 33.93357], [-117.90844, 33.93354], [-117.90926, 33.93354], [-117.90928, 33.93405]]]} Open Access 1 20032 Founder's Park 19018 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2   Orange 3 2.904 Founder's Park 0 Local Park 2 4
11603 11603 11602 {"type": "Polygon", "coordinates": [[[-117.85081, 33.92761], [-117.84998, 33.92778], [-117.84822, 33.9279], [-117.84813, 33.92759], [-117.84813, 33.92748], [-117.85047, 33.92737], [-117.85061, 33.92727], [-117.85073, 33.9273], [-117.85079, 33.92746], [-117.85081, 33.92761]]]} Open Access 1 48728 Wildcatters Dog Park 33455 1033 Brea, City of 233 City 2 City Agency 2 http://www.ci.brea.ca.us/index.aspx?NID=439 City 2 1033 Brea, City of 229 City 2 City Agency 2 https://www.ci.brea.ca.us/729/Wildcatters-Dog-Park Orange 3 2.562 Wildcatters Dog Park 0 Local Park 2 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]);