superunits_with_maps

Table actions

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

12 rows where MNG_AGENCY = 272

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Inglewood, City of · 12 ✖

ACCESS_TYP 1

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
1637 1637 1636 {"type": "Polygon", "coordinates": [[[-118.36875, 33.95782], [-118.36872, 33.95811], [-118.36872, 33.95829], [-118.36868, 33.95861], [-118.36851, 33.95933], [-118.36833, 33.9606], [-118.36829, 33.95783], [-118.36875, 33.95782]]]} Open Access 1 Ashwood Park   15657 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.68 Ashwood Park  
2050 2050 2049 {"type": "Polygon", "coordinates": [[[-118.33732, 33.93475], [-118.33652, 33.93476], [-118.33651, 33.93461], [-118.33636, 33.9346], [-118.33636, 33.93393], [-118.33732, 33.93393], [-118.33732, 33.93475]]]} Open Access 1 Center Park   17037 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.945 Ctr. Park  
2759 2759 2758 {"type": "Polygon", "coordinates": [[[-118.37282, 33.96765], [-118.37236, 33.96799], [-118.3721, 33.96783], [-118.37205, 33.96776], [-118.37192, 33.96739], [-118.37247, 33.96718], [-118.37256, 33.96732], [-118.37282, 33.96765]]]} Open Access 1 Centinela Adobe Park   17043 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.077 Centinela Adobe Park  
2947 2947 2946 {"type": "Polygon", "coordinates": [[[-118.32256, 33.96368], [-118.32254, 33.96376], [-118.3225, 33.96384], [-118.32239, 33.96395], [-118.32231, 33.96399], [-118.32221, 33.96402], [-118.32203, 33.96402], [-118.32191, 33.96399], [-118.32176, 33.96388], [-118.32168, 33.96374], [-118.32167, 33.96364], [-118.32171, 33.96349], [-118.32181, 33.96337], [-118.32189, 33.96333], [-118.32199, 33.96329], [-118.32216, 33.96328], [-118.32225, 33.9633], [-118.32234, 33.96333], [-118.32248, 33.96344], [-118.32255, 33.96356], [-118.32256, 33.96368]]]} Open Access 1 Circle Park   17264 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.316 Circle Park  
3439 3439 3438 {"type": "Polygon", "coordinates": [[[-118.33084, 33.9561], [-118.32917, 33.95611], [-118.32915, 33.95528], [-118.32933, 33.95526], [-118.32933, 33.95245], [-118.32973, 33.95246], [-118.32978, 33.95248], [-118.33084, 33.95274], [-118.33084, 33.9561]]]} Open Access 1 Darby Park   17925 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 13.903 Darby Park  
4750 4750 4749 {"type": "MultiPolygon", "coordinates": [[[[-118.35476, 33.96038], [-118.35458, 33.96037], [-118.35456, 33.95959], [-118.35472, 33.95959], [-118.35476, 33.96038]]], [[[-118.35495, 33.96159], [-118.35464, 33.96161], [-118.35461, 33.96062], [-118.35489, 33.96062], [-118.35495, 33.96159]]]]} Open Access 1 Grevillea Park   19503 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.072 Grevillea Park  
6324 6324 6323 {"type": "Polygon", "coordinates": [[[-118.33984, 33.93393], [-118.33983, 33.93417], [-118.33942, 33.93417], [-118.33943, 33.93394], [-118.33984, 33.93393]]]} Open Access 1 Lockhaven Center Playground   21396 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 0.244 Lockhaven Ctr. Playground  
7448 7448 7447 {"type": "Polygon", "coordinates": [[[-118.34826, 33.98043], [-118.34743, 33.98044], [-118.34742, 33.97934], [-118.34824, 33.97933], [-118.34826, 33.98043]]]} Open Access 1 North Park   22840 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 2.307 North Park  
7508 7508 7507 {"type": "Polygon", "coordinates": [[[-118.36225, 33.96855], [-118.36199, 33.96877], [-118.3617, 33.96878], [-118.3617, 33.96902], [-118.3608, 33.96978], [-118.35917, 33.96897], [-118.35922, 33.96886], [-118.35924, 33.96886], [-118.35954, 33.96848], [-118.35954, 33.96837], [-118.35907, 33.96893], [-118.35885, 33.96881], [-118.35884, 33.96808], [-118.3594, 33.96695], [-118.36169, 33.96828], [-118.36209, 33.96849], [-118.36225, 33.96855]]]} Open Access 1 Rogers Park   24561 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 12.818 Rogers Park  
8451 8451 8450 {"type": "Polygon", "coordinates": [[[-118.34509, 33.96217], [-118.34509, 33.96257], [-118.34443, 33.96258], [-118.34443, 33.96178], [-118.34493, 33.96177], [-118.34492, 33.96215], [-118.34509, 33.96217]]]} Open Access 1 Queen Park   24062 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.182 Queen Park  
9694 9694 9693 {"type": "Polygon", "coordinates": [[[-118.36408, 33.94814], [-118.36392, 33.94814], [-118.36391, 33.94821], [-118.36359, 33.94821], [-118.36358, 33.94849], [-118.36351, 33.94847], [-118.3635, 33.94805], [-118.36144, 33.94805], [-118.36144, 33.9478], [-118.36408, 33.9478], [-118.36408, 33.94814]]]} Open Access 1 Siminski Park   25508 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1.941 Siminski Park  
10901 10901 10900 {"type": "MultiPolygon", "coordinates": [[[[-118.344, 33.97165], [-118.34398, 33.97217], [-118.34399, 33.97312], [-118.34396, 33.97333], [-118.34398, 33.97377], [-118.34396, 33.97379], [-118.34395, 33.97549], [-118.34233, 33.97551], [-118.34231, 33.97592], [-118.34171, 33.97593], [-118.34101, 33.97615], [-118.34058, 33.97617], [-118.34056, 33.97553], [-118.33999, 33.97552], [-118.34, 33.97349], [-118.34396, 33.97163], [-118.344, 33.97165]]], [[[-118.34823, 33.97142], [-118.34633, 33.97248], [-118.34403, 33.97374], [-118.34402, 33.97333], [-118.34404, 33.97312], [-118.34403, 33.97217], [-118.34405, 33.97164], [-118.344, 33.9716], [-118.3472, 33.9701], [-118.34823, 33.97142]]]]} Open Access 1 Vincent Park   27127 1147 Inglewood, City of 272 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 50.74 Vincent 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]);