units_with_maps

Table actions

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

1 row where AGNCY_NAME = 287, DES_TP = 3 and MNG_AGENCY = 18

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Culver City, City of · 1 ✖

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

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
12179 12179 12178 {"type": "MultiPolygon", "coordinates": [[[[-118.38534, 34.02767], [-118.38533, 34.02775], [-118.38316, 34.02755], [-118.38313, 34.02751], [-118.38309, 34.0275], [-118.38298, 34.02753], [-118.38198, 34.02744], [-118.38195, 34.02739], [-118.38189, 34.02736], [-118.38182, 34.02738], [-118.38178, 34.02742], [-118.38094, 34.02734], [-118.38089, 34.02732], [-118.38082, 34.02733], [-118.38001, 34.02726], [-118.3797, 34.02726], [-118.37928, 34.02722], [-118.37927, 34.02723], [-118.37835, 34.02715], [-118.37835, 34.0271], [-118.37701, 34.02698], [-118.37683, 34.02711], [-118.37688, 34.02697], [-118.37693, 34.02697], [-118.37696, 34.02687], [-118.37985, 34.02713], [-118.38058, 34.02722], [-118.38187, 34.02732], [-118.38261, 34.02742], [-118.38439, 34.0276], [-118.38534, 34.02767]]], [[[-118.37843, 34.02209], [-118.37823, 34.02223], [-118.37792, 34.02253], [-118.37772, 34.02278], [-118.37754, 34.0231], [-118.37743, 34.02339], [-118.37735, 34.02373], [-118.37719, 34.02459], [-118.37694, 34.02617], [-118.37689, 34.02614], [-118.37706, 34.02505], [-118.37732, 34.02354], [-118.37746, 34.02312], [-118.37759, 34.02288], [-118.37777, 34.02264], [-118.37802, 34.02233], [-118.37831, 34.02207], [-118.37843, 34.02209]]], [[[-118.3894, 34.01753], [-118.38804, 34.01937], [-118.38793, 34.0195], [-118.3877, 34.01973], [-118.38746, 34.01993], [-118.38719, 34.02011], [-118.38689, 34.02028], [-118.38683, 34.02025], [-118.38618, 34.02045], [-118.38437, 34.02073], [-118.38192, 34.02117], [-118.38012, 34.02145], [-118.37941, 34.02159], [-118.37886, 34.02181], [-118.3786, 34.02198], [-118.37848, 34.02196], [-118.37891, 34.02172], [-118.37924, 34.02159], [-118.37958, 34.02149], [-118.37995, 34.02141], [-118.38256, 34.021], [-118.38282, 34.02093], [-118.38381, 34.02079], [-118.38605, 34.02043], [-118.38691, 34.02013], [-118.38744, 34.0198], [-118.38767, 34.01961], [-118.38797, 34.01929], [-118.38927, 34.01747], [-118.3894, 34.01753]]], [[[-118.39626, 34.00748], [-118.39489, 34.00787], [-118.39486, 34.00782], [-118.39472, 34.00783], [-118.39467, 34.00785], [-118.39467, 34.00787], [-118.39449, 34.00792], [-118.39447, 34.00791], [-118.3943, 34.00795], [-118.39392, 34.00807], [-118.39372, 34.00814], [-118.39342, 34.00828], [-118.39314, 34.00844], [-118.39311, 34.00842], [-118.39299, 34.00851], [-118.39295, 34.00854], [-118.39297, 34.00856], [-118.39284, 34.00866], [-118.39282, 34.00865], [-118.39262, 34.00883], [-118.39236, 34.00915], [-118.39222, 34.00938], [-118.39211, 34.00962], [-118.39203, 34.00987], [-118.39197, 34.01026], [-118.39197, 34.01111], [-118.392, 34.01112], [-118.39205, 34.01123], [-118.392, 34.01128], [-118.392, 34.01136], [-118.39205, 34.01142], [-118.39214, 34.01256], [-118.39142, 34.01421], [-118.39072, 34.01513], [-118.39064, 34.01526], [-118.39061, 34.01536], [-118.3904, 34.01569], [-118.39004, 34.0162], [-118.39001, 34.0163], [-118.38976, 34.01679], [-118.38968, 34.01708], [-118.38946, 34.01743], [-118.3893, 34.01735], [-118.39002, 34.01615], [-118.39057, 34.01534], [-118.39061, 34.01523], [-118.39138, 34.01422], [-118.39175, 34.01334], [-118.39194, 34.01259], [-118.39199, 34.01209], [-118.392, 34.01137], [-118.39195, 34.01131], [-118.39197, 34.01112], [-118.39192, 34.01109], [-118.39192, 34.01039], [-118.39193, 34.01012], [-118.39198, 34.00986], [-118.39206, 34.00961], [-118.39218, 34.00936], [-118.39232, 34.00912], [-118.3925, 34.0089], [-118.3928, 34.00861], [-118.39311, 34.00838], [-118.39338, 34.00823], [-118.39386, 34.00805], [-118.39482, 34.00775], [-118.39482, 34.00772], [-118.39611, 34.00728], [-118.39626, 34.00748]]], [[[-118.40046, 34.0022], [-118.39956, 34.00495], [-118.39937, 34.00545], [-118.39916, 34.00583], [-118.39902, 34.00601], [-118.39899, 34.006], [-118.39878, 34.00623], [-118.39844, 34.00653], [-118.39818, 34.0067], [-118.3979, 34.00686], [-118.39739, 34.00708], [-118.39641, 34.00737], [-118.39631, 34.00723], [-118.39746, 34.00699], [-118.39765, 34.00694], [-118.398, 34.00676], [-118.39838, 34.0065], [-118.39877, 34.00616], [-118.39901, 34.00588], [-118.39842, 34.00569], [-118.39834, 34.0057], [-118.39795, 34.00605], [-118.39791, 34.00603], [-118.39823, 34.0057], [-118.39835, 34.00555], [-118.39848, 34.00532], [-118.39858, 34.00535], [-118.39845, 34.00565], [-118.39904, 34.00584], [-118.39907, 34.00582], [-118.39922, 34.00559], [-118.3999, 34.00373], [-118.40042, 34.00218], [-118.40046, 34.0022]]], [[[-118.40141, 34.00002], [-118.40121, 34.00039], [-118.40123, 34.00041], [-118.40094, 34.00091], [-118.40074, 34.00142], [-118.40068, 34.00143], [-118.4012, 33.99986], [-118.40126, 33.99987], [-118.40106, 34.00058], [-118.40138, 34.0], [-118.40141, 34.00002]]], [[[-118.40502, 33.99457], [-118.40495, 33.99462], [-118.40476, 33.9948], [-118.4045, 33.99491], [-118.40491, 33.99456], [-118.405, 33.99449], [-118.40502, 33.99457]]]]} Open Access 1 46848 Ballona Creek Trail and Bike Path 30331 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 9.968 Ballona Creek Trail and Bike Path 0 Local Recreation Area 3 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]);