units_with_maps

Table actions

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

11 rows where ACCESS_TYP = 1, AGNCY_NAME = 277 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

MNG_AGENCY 1

ACCESS_TYP 1

  • Open Access · 11 ✖
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
876 876 875 {"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.35955, 33.96848], [-118.35954, 33.96836], [-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 6290 Rogers Park 24561 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 12.808 Rogers Park 0 Local Park 2 4
877 877 876 {"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 6291 Ashwood Park 15657 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.68 Ashwood Park 0 Local Park 2 4
878 878 877 {"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.96216], [-118.34509, 33.96217]]]} Open Access 1 6292 Queen Park 24062 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.18 Queen Park 0 Local Park 2 4
879 879 878 {"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.36351, 33.94805], [-118.36144, 33.94805], [-118.36144, 33.9478], [-118.36408, 33.9478], [-118.36408, 33.94814]]]} Open Access 1 6293 Siminski Park 25508 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.934 Siminski Park 0 Local Park 2 4
1014 1014 1013 {"type": "Polygon", "coordinates": [[[-118.33732, 33.93475], [-118.33652, 33.93476], [-118.33652, 33.93461], [-118.33636, 33.9346], [-118.33636, 33.93393], [-118.33732, 33.93393], [-118.33732, 33.93475]]]} Open Access 1 6286 Center Park 17037 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.945 Ctr. Park 0 Local Park 2 4
1018 1018 1017 {"type": "MultiPolygon", "coordinates": [[[[-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.97163], [-118.344, 33.9716], [-118.3472, 33.9701], [-118.34823, 33.97142]]], [[[-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]]]]} Open Access 1 6288 Vincent Park 27127 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 50.732 Vincent Park 0 Local Park 2 4
2486 2486 2485 {"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 6279 Grevillea Park 19503 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.073 Grevillea Park 0 Local Park 2 4
2487 2487 2486 {"type": "Polygon", "coordinates": [[[-118.32256, 33.96368], [-118.32254, 33.96376], [-118.3225, 33.96384], [-118.32239, 33.96394], [-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.32166, 33.96364], [-118.32171, 33.96349], [-118.32181, 33.96337], [-118.32189, 33.96333], [-118.322, 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 6280 Circle Park 17264 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.316 Circle Park 0 Local Park 2 4
2488 2488 2487 {"type": "Polygon", "coordinates": [[[-118.33084, 33.9561], [-118.32917, 33.95611], [-118.32915, 33.95528], [-118.32933, 33.95527], [-118.32933, 33.95245], [-118.32973, 33.95246], [-118.32978, 33.95248], [-118.33084, 33.95274], [-118.33084, 33.9561]]]} Open Access 1 6281 Darby Park 17925 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 13.903 Darby Park 0 Local Park 2 4
7162 7162 7161 {"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 6284 Centinela Adobe Park 17043 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 1.077 Centinela Adobe Park 0 Local Park 2 4
7164 7164 7163 {"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 6289 North Park 22840 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 2.308 North 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]);