calands: units_with_maps: 4 rows where DES_TP = 3, LAYER = 2 and MNG

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

4 rows where DES_TP = 3, LAYER = 2 and MNG_AGENCY = 510

Search:

descending

This data as json, copyable, CSV (advanced)

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
12326	12326	12325	{"type": "MultiPolygon", "coordinates": [[[[-121.04968, 37.68284], [-121.04964, 37.68286], [-121.04072, 37.68546], [-121.04071, 37.68514], [-121.04967, 37.68252], [-121.04968, 37.68284]]], [[[-121.04051, 37.68552], [-121.03338, 37.6876], [-121.03168, 37.68809], [-121.03168, 37.68777], [-121.0405, 37.6852], [-121.04051, 37.68552]]], [[[-121.03142, 37.68816], [-121.02727, 37.68937], [-121.02669, 37.68937], [-121.0267, 37.68922], [-121.03142, 37.68784], [-121.03142, 37.68816]]], [[[-121.02637, 37.68964], [-121.02317, 37.69057], [-121.02251, 37.69076], [-121.0225, 37.69044], [-121.02532, 37.68962], [-121.02637, 37.68964]]], [[[-121.02237, 37.69086], [-121.02159, 37.69113], [-121.02161, 37.69143], [-121.01974, 37.69157], [-121.01781, 37.69213], [-121.01771, 37.69184], [-121.02069, 37.69097], [-121.02069, 37.69137], [-121.02155, 37.69138], [-121.02155, 37.69109], [-121.02237, 37.69079], [-121.02237, 37.69086]]], [[[-121.01761, 37.69219], [-121.01578, 37.69273], [-121.01265, 37.69363], [-121.01264, 37.69331], [-121.01377, 37.69298], [-121.01751, 37.6919], [-121.01761, 37.69219]]], [[[-121.0124, 37.69371], [-121.00845, 37.69486], [-121.00832, 37.69457], [-121.0124, 37.69339], [-121.0124, 37.69371]]], [[[-121.00826, 37.69491], [-121.00639, 37.69546], [-121.00416, 37.6961], [-121.00417, 37.69578], [-121.00813, 37.69463], [-121.00826, 37.69491]]]]}	Open Access 1	25993	Hetch Hetchy Trail	19886	1208	Modesto, City of 517	City 2	City Agency 2	http://www.modestogov.com/prnd/	City 2	1208	Modesto, City of 510	City 2	City Agency 2	Stanislaus 2	32.984	Hetch Hetchy Trail	Local Recreation Area 3	4
15697	15697	15696	{"type": "Polygon", "coordinates": [[[-120.94998, 37.64964], [-120.94987, 37.64947], [-120.94973, 37.64935], [-120.94933, 37.64916], [-120.94892, 37.64904], [-120.94857, 37.64887], [-120.94821, 37.6486], [-120.94808, 37.64857], [-120.94792, 37.64849], [-120.94767, 37.64842], [-120.94752, 37.64832], [-120.94726, 37.64824], [-120.94705, 37.64824], [-120.94689, 37.64827], [-120.94604, 37.64854], [-120.94578, 37.64871], [-120.94549, 37.64892], [-120.94541, 37.649], [-120.94526, 37.6492], [-120.9452, 37.64934], [-120.94519, 37.64946], [-120.94455, 37.6507], [-120.94414, 37.65124], [-120.94359, 37.65155], [-120.9433, 37.65173], [-120.94296, 37.65199], [-120.94286, 37.65209], [-120.94267, 37.65231], [-120.94275, 37.65236], [-120.94262, 37.65253], [-120.94256, 37.65267], [-120.94237, 37.65297], [-120.94211, 37.65331], [-120.94171, 37.65367], [-120.94162, 37.65382], [-120.94154, 37.65391], [-120.94143, 37.654], [-120.94125, 37.65409], [-120.94096, 37.6542], [-120.94082, 37.65422], [-120.94049, 37.65421], [-120.94027, 37.65418], [-120.93922, 37.65415], [-120.9392, 37.65408], [-120.93862, 37.6541], [-120.93813, 37.65394], [-120.93784, 37.65395], [-120.93715, 37.65383], [-120.93698, 37.65383], [-120.93663, 37.65371], [-120.93635, 37.65364], [-120.93558, 37.65356], [-120.93523, 37.65357], [-120.93523, 37.65365], [-120.93405, 37.65329], [-120.9337, 37.65323], [-120.9332, 37.65298], [-120.93291, 37.65275], [-120.9319, 37.65225], [-120.93167, 37.65218], [-120.93136, 37.65204], [-120.93064, 37.65213], [-120.93016, 37.6523], [-120.93014, 37.65079], [-120.93024, 37.65078], [-120.93022, 37.64918], [-120.93024, 37.64915], [-120.93026, 37.64914], [-120.93898, 37.64909], [-120.93901, 37.64911], [-120.93909, 37.64943], [-120.93911, 37.65109], [-120.93918, 37.65109], [-120.93919, 37.65111], [-120.94141, 37.65108], [-120.9414, 37.65094], [-120.93924, 37.65097], [-120.93923, 37.64954], [-120.93916, 37.64929], [-120.93916, 37.6492], [-120.93926, 37.64917], [-120.93926, 37.64923], [-120.93927, 37.64924], [-120.94039, 37.64881], [-120.94039, 37.64872], [-120.94066, 37.64859], [-120.94207, 37.64761], [-120.94226, 37.6475], [-120.94247, 37.64742], [-120.94438, 37.64684], [-120.94459, 37.64676], [-120.94479, 37.64665], [-120.94661, 37.64545], [-120.94678, 37.64537], [-120.94705, 37.6453], [-120.94724, 37.64529], [-120.94804, 37.64529], [-120.94813, 37.64549], [-120.94817, 37.64844], [-120.94821, 37.64848], [-120.9483, 37.64851], [-120.9483, 37.64864], [-120.94908, 37.64902], [-120.94982, 37.64935], [-120.94998, 37.64949], [-120.94998, 37.64964]], [[-120.94255, 37.65248], [-120.94255, 37.65246], [-120.94248, 37.65247], [-120.9424, 37.65264], [-120.94244, 37.65264], [-120.94255, 37.65248]]]}	Restricted Access 2	18555	Creekside Golf Course	33066	1208	Modesto, City of 517	City 2	City Agency 2	http://www.modestogov.com/prnd/	City 2	1208	Modesto, City of 510	City 2	City Agency 2	Stanislaus 2	181.194	Creekside GC	Local Recreation Area 3	4
15698	15698	15697	{"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61165], [-121.01028, 37.61259], [-121.00951, 37.61259], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00713, 37.6133], [-121.0069, 37.61319], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61662], [-121.00346, 37.61667], [-121.00336, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61768], [-121.00264, 37.61767], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99953, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00952, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]}	Restricted Access 2	18585	Dryden Park Golf Course	33067	1208	Modesto, City of 517	City 2	City Agency 2	http://www.modestogov.com/prnd/	City 2	1208	Modesto, City of 510	City 2	City Agency 2	Stanislaus 2	145.239	Dryden Park GC	Local Recreation Area 3	4
15699	15699	15698	{"type": "MultiPolygon", "coordinates": [[[[-120.99932, 37.62134], [-120.99917, 37.62154], [-120.99906, 37.62181], [-120.99884, 37.62328], [-120.99886, 37.62347], [-120.99888, 37.62356], [-120.99917, 37.62423], [-120.99856, 37.62423], [-120.99861, 37.62338], [-120.99842, 37.62163], [-120.99844, 37.62135], [-120.99932, 37.62134]]], [[[-121.00483, 37.6277], [-121.00335, 37.6277], [-121.00334, 37.6274], [-121.00293, 37.6274], [-121.00293, 37.6277], [-121.0001, 37.62764], [-120.99933, 37.62754], [-120.99931, 37.62579], [-120.9994, 37.62481], [-120.99939, 37.6246], [-120.99936, 37.62439], [-120.9993, 37.62419], [-120.99901, 37.62354], [-120.99899, 37.62345], [-120.99898, 37.62328], [-120.99919, 37.62183], [-120.9993, 37.62158], [-120.99941, 37.62144], [-120.99954, 37.6213], [-121.00026, 37.62082], [-121.00037, 37.62075], [-121.0005, 37.6207], [-121.00077, 37.62066], [-121.0015, 37.62067], [-121.00149, 37.62352], [-121.00206, 37.62352], [-121.00206, 37.62423], [-121.00252, 37.62424], [-121.00253, 37.62432], [-121.0048, 37.62432], [-121.00483, 37.6277]]]]}	Restricted Access 2	18745	Modesto Municipal Golf Course	33068	1208	Modesto, City of 517	City 2	City Agency 2	http://www.modestogov.com/prnd/	City 2	1208	Modesto, City of 510	City 2	City Agency 2	Stanislaus 2	67.968	Modesto Municipal GC	Local Recreation Area 3	4

Advanced export

JSON shape: default, array, newline-delimited

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]);